all groups > sql server reporting services > october 2005 >
You're in the

sql server reporting services

group:

hiding parameters



hiding parameters Danny Bader
10/12/2005 2:11:03 PM
sql server reporting services: I keep seeing post saying that you can hide parameters and pass the values
through a querystring by clearing out the prompt string and unchecking prompt
user. However, when I try this i get an error saying the propery is read
only. Any Suggestions.

--
Thanks,

RE: hiding parameters Robert RVRK
10/12/2005 6:30:01 PM
I too get this error if I leave the parameter prompt blank. I keep hearing
that you have to install SP1 to make this go away. I have SP2 installed and
it still happens. Does SP2 not have the SP1 fixes in it also? If not, is it
okay to install SP1 even though I already have SP2 installed?

RE: hiding parameters Danny Bader
10/13/2005 6:12:03 AM
I have SP2 installed as well.
--
Thanks,

Danny Bader


[quoted text, click to view]
RE: hiding parameters Robert RVRK
10/13/2005 7:33:03 AM
Hi Danny,

I think I might have found the solution. Instead of blanking out the
parameter prompt, enter a space for the parameter prompt. Supposedly this
will work when you view the report in the report viewer (but it won't in the
IDE, so don't give up until you've tried it in the viewer). I am going to go
try myself now...

RE: hiding parameters F. Dwarf [MCP]
10/13/2005 11:33:02 AM

[quoted text, click to view]

Nope. Just clear the prompt string and DON'T uncheck the prompt user option.

--
Please mark the correct/helpful answers!

RE: hiding parameters derang song
12/3/2005 7:19:02 AM
you can do by following steps:
1. check "allow null"
2. Clear the prompt string
3. select "none" for default value
4. in report manager, check "prompt user", but clear the prompt string
so, this parameter will not appear in parameter panel
and you can pass value to this parameter through URL

[quoted text, click to view]
AddThis Social Bookmark Button