all groups > sql server reporting services > september 2004 >
You're in the

sql server reporting services

group:

passing parameters to a SQLR from asp.net


passing parameters to a SQLR from asp.net Lee Hopkins
9/17/2004 11:29:14 AM
sql server reporting services: I have a asp.net and asp pages that need to call sql
reports easy with out parameters. How so I pass the
parameter through a url.

passing parameters to a SQLR from asp.net Lee Hopkins
9/17/2004 11:40:54 AM
I have tried to hardcode a parameter
...../Open_O_reports_Details&@monum='A049529'
..../Open_O_reports_Details&@monum=A049529
..../Open_O_reports_Details&monum=A049529
..../Open_O_reports_Details&monum='A049529'

the report opens but the value is not passing with any of
the above



[quoted text, click to view]
Re: passing parameters to a SQLR from asp.net Bruce Loehle-Conger
9/17/2004 2:28:13 PM
You didn't give the whole line but this one should have worked.
/Open_O_reports_Details&monum=A049529

Here is one that works for me:
http://myserver/ReportServer/Pages/Report.aspx?/myfoldername/myreportname&myparamname=1235678

Note that this parameter is of type string, you do not inclose it.

Bruce L-C



[quoted text, click to view]

Re: passing parameters to a SQLR from asp.net Laura
9/17/2004 2:35:34 PM
Bruce,
You mentioned, "Note that this parameter is of type string, you do not
inclose it." What if your parameter's data type is of say DateTime type,
how would you pass that value on the URL string? What about the other data
types (boolean, float, int, etc)? Do you have to do anything special to
pass values to parameter with these other data types?
Thanks!


[quoted text, click to view]

Re: passing parameters to a SQLR from asp.net Bruce Loehle-Conger
9/17/2004 3:12:27 PM
Note, I use the format below specifically so that the parameter is not
hidden. I want the user to be able to modify the parameter.

Bruce L-C

[quoted text, click to view]

Re: passing parameters to a SQLR from asp.net Bruce Loehle-Conger
9/17/2004 4:15:03 PM
No

[quoted text, click to view]

Re: passing parameters to a SQLR from asp.net Lee Hopkins
9/20/2004 6:29:10 AM
I have tried this but still not working
Report.aspx?
ItemPath=/Labor+Reporting+Services/Material+Var/Open_O_repo
rts_Details&monum=5s13406

just comes up blank and a blank box for monum.





[quoted text, click to view]
Got something to say? Click here to post a reply to this thread.
Don't see what you're looking for? Try a search.
View other messages in the sql server reporting services group.
AddThis Social Bookmark Button
View Other Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
home · blog · groups Questions? Comments? Contact the dn