SQL Server Performance Forum – Threads Archive
Parameters in URLHello,<br /><br />I created a report with 3 parameters. One should not be shown and the other two have to be shown.<br />The URL contains either "rc<img src=’/community/emoticons/emotion-4.gif’ alt=’‘ />arameters=true" (then it showns ALL the parameters) or "rc<img src=’/community/emoticons/emotion-4.gif’ alt=’‘ />arameters=false" (then it hides ALL the parameters)<br /><br />Is there a way to only show 2 of them?<br /><br />Kind regards,<br />IV
I posted this same question last week. No solution currently –
spoke with a Microsoft rep and he says this is a know issue and said :
"This is a known issue. You will be able to work around this in SP1 by clearing out the prompt string once the report has been published to the server." Ive heard SP1 is planned for release on June 15th.
Currently Im trying to set the defaults parameter at run time, maybe that will do the tick though I doubt it very much. Any Ideas?