SQL Server Performance Forum – Threads Archive
Pass Parameter
I have a web site which contain a link to a SQL Report. Is it any way to pass parameter (in the address "Http://Sqlservername/repotrts/…" tho the Report??? If yes, How to do this?The URL used to access a report can contain parameters as well as commands tha will affect the behaviour of the ReportServer. Example:
http://MyReportServer/ReportServer?…omerID=178&rs:Command=Render&rc:Toolbar=false Export directly to PDF:
http://MyReportServer/ReportServer?…Command=Render&rc:Toolbar=false&rs:format=PDF Rui Sousa,
Portugal
oops. it seems the url i have just made up is a real one… Don’t clik it. Rui Sousa,
Portugal
But how can I read the parameters in the report???
I don’t know if i understood your question, I guess you want to show in the report the parameter value passed on the URL. To do that in a textbox, and continuing with the example I posted, you should put an expression like the following in the textbox value: =Parameters!CustomerID.Value Or something like this: ="This is the report for customer " + Parameters!CustomerID.Value Hope this helps Rui Sousa,
Portugal
So. as I understand I need to define the parameter on my report (Report-> Report Parameters ->Add)
But without Prompt
Am I right??
Yes, you have to define the parameter on your report, but it can have a prompt.
Rui Sousa,
Portugal
I did it but it’s not work! I defined in my report a parameter caled testP (No prompt) with default value "aaa".
The report contain a TextBox which it’s value is the testP parameter value.
When I open the report on the SQL report: http://SQLreportserver/Reports/Pages/Report.aspx?ItemPath=/TestReports/My_Test It’s print to me "aaa" on that textbox. When I send value on the link: http://SQLreportserver/Reports/Pages/Report.aspx?ItemPath=/TestReports/My_Test&testP=bbb It’s still print to me "aaa" and not "bbb" What’s wrong????
Depeding on you caching options a refresh, on the Reporting Services toolbar, may help. If not… I don’t know, sorry. Rui Sousa,
Portugal
Hi,
try modifiing the paramater in the report view in your browser and refresh, just to test if your report parameter is working!!!!!![?] AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS
still not work! What can I do?
any help……? pleas
Please Help
How are you calling the reports?
If you use Front End Application to call it then pass parameter value from there
In Crystal Reports, you can do from VB as follows
CR.Parameters(0)="Parameter value"
See if you are able to do the same in SSRS also Madhivanan Failing to plan is Planning to fail
]]>