Dont know if you are hijacking my thread LOL---- still i will answer you [:)]
Public
Sub OpenNewWindow(ByVal pg
As Page,
ByVal WindowName
As
String,
ByVal urlToOpen
As
String)
Dim ScriptString
As String =
"<script language=javascript>window.open('" & urlToOpen &
"','" & WindowName &
"','resizable=1,scrollbars=1,width=800,height=680,left=2,top=2,toolbar=0,status=0,location=0,menubar=0');</script>"
pg.ClientScript.RegisterStartupScript(
Me.GetType(),
"KeyName", ScriptString)
End Sub
' in the calling page ================================
Dim
url As
String = "http://localhost/ReportServer$SQLEXPRESS/Pages/ReportViewer.aspx?%2fSeaBirdReports%2fPayReceipt&rs%3aCommand=Render&rc%3aParameters=false&LRNo="
& Me.txtLRNo.Text &
""
objGenCls.OpenNewWindow(
Me,
"Receipt", url)
instead of local host u might use the ip
Disclaimer [:P] I am not an expert!! so the above might not be the best way to do!!.... but it works for me
Can you post your sp? Makes it easier for all to help if we see what you have.
- Clarence
www.ocdprogrammer.com If a post was helpful to you, take a moment and mark it as the answer.
CODE PROVIDED AS IS Yes, the license plate in my avatar is real.
Please also let us know which version of SQL Express you are using.
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
sara_23apr
Member
70 Points
112 Posts
Using Store procedure
Mar 01, 2007 06:36 AM|LINK
I have an SP which can perform 2 different operations based on the input (oprn1 and oprn2)
i have two reports -
when i open report1 i pass the oprn1 name as inputparameter
when i open report2 i pass the oprn2 name as inputparameter
but in both cases the oprn1 gets executed
can somebody help
Thanks for your time
Sara
Ramzi.Aynati
Contributor
2240 Points
531 Posts
Re: Using Store procedure
Mar 01, 2007 09:40 PM|LINK
Ramzi
--------------------------------------------
Dont Forget to mark the post as answered once replied.
sara_23apr
Member
70 Points
112 Posts
Re: Using Store procedure
Mar 02, 2007 02:04 AM|LINK
Dont know if you are hijacking my thread LOL---- still i will answer you [:)]
Public
Sub OpenNewWindow(ByVal pg As Page, ByVal WindowName As String, ByVal urlToOpen As String) Dim ScriptString As String = "<script language=javascript>window.open('" & urlToOpen & "','" & WindowName & "','resizable=1,scrollbars=1,width=800,height=680,left=2,top=2,toolbar=0,status=0,location=0,menubar=0');</script>"pg.ClientScript.RegisterStartupScript(
Me.GetType(), "KeyName", ScriptString) End Sub' in the calling page ================================
Dim
url As String = "http://localhost/ReportServer$SQLEXPRESS/Pages/ReportViewer.aspx?%2fSeaBirdReports%2fPayReceipt&rs%3aCommand=Render&rc%3aParameters=false&LRNo=" & Me.txtLRNo.Text & ""objGenCls.OpenNewWindow(
Me, "Receipt", url)instead of local host u might use the ip
Disclaimer [:P] I am not an expert!! so the above might not be the best way to do!!.... but it works for me
sara_23apr
Member
70 Points
112 Posts
Re: Using Store procedure
Mar 02, 2007 02:07 AM|LINK
Did u ask the code to help me or did u ask the code to learn how to pass parameter??
if u had asked to learn, then hope my post was helpful
Sara
Ramzi.Aynati
Contributor
2240 Points
531 Posts
Re: Using Store procedure
Mar 02, 2007 06:37 AM|LINK
Ramzi
--------------------------------------------
Dont Forget to mark the post as answered once replied.
sara_23apr
Member
70 Points
112 Posts
Re: Using Store procedure
Mar 03, 2007 02:11 AM|LINK
Opps sorry [:$]
Sara
sara_23apr
Member
70 Points
112 Posts
Re: Using Store procedure
Mar 03, 2007 02:13 AM|LINK
Thanks for trying to help
[:)]
Sara
saurin143
Member
22 Points
11 Posts
Re: Using Store procedure
Nov 20, 2008 09:27 AM|LINK
please shoe me your code because i have solution but if you show me your code then i can explain it very clearly to you.
ckincincy
Member
418 Points
127 Posts
Re: Using Store procedure
Nov 20, 2008 11:46 AM|LINK
Can you post your sp? Makes it easier for all to help if we see what you have.
www.ocdprogrammer.com
If a post was helpful to you, take a moment and mark it as the answer.
CODE PROVIDED AS IS
Yes, the license plate in my avatar is real.
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: Using Store procedure
Nov 27, 2008 06:01 AM|LINK
>Can you post your sp?
Please also let us know which version of SQL Express you are using.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239