March 26, 2008 at 9:13 am
Hello ,
i've got a report with a hidden parameter that's used to return a dropdown list for selection in the report.
When i passthrough the parameter by the url it doesn't pickup the value . Do i need to activate a setting or ... in order to get this working ?
Beneath the url i'm using , i also tried with &id_user=66
but also no result.
The dropdown works if i set a default value for the id_user
I'm using sql server 2003 SP2 with and reporting services Version 9.00.3042.00
any help would be appreciated .
stanja
March 26, 2008 at 1:10 pm
&rs:Command=Render&rs:id_user=66
You're making the same mistake I made when specifying parameters in a URL.
The report parameters don't have the "rs:" "RS" is for Report Server parameters.
So your URL should look like:
&rs:Command=Render&id_user=66
March 27, 2008 at 4:23 am
i've already tried that ,but the result is the same , in other words my problem stays
regards
stanja
March 28, 2008 at 6:36 am
If the parameter is generated from a query, then it's due to a RS limiation. URLs don't pass parameters that are generated by a query. If anyone knows a workaround, let me know.
smv929
March 28, 2008 at 6:47 am
Hi I am not sure if I understood the question correctly I am very new to Reporting Services.
If I have a report model is it possible to pass parameters (hidden to end user) to it from run time.
I want to do this using Microsoft Ad-Hoc Report Builder, like the end user clicks on the Report Builder button and it will pass certain parameters to the Report Model, these parameters are hidden to the end user.
I appreciate any help or if this is even possible with Microsoft Report Builder which use the Clickonce Application.
DD
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply