Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 how can i protect my parameters

Author  Topic 

roy mm
Yak Posting Veteran

62 Posts

Posted - 2007-10-25 : 12:55:29
Hello.
I have a report with parameter called "parm1", that gets a value of "true" or "false" depanding on another parameter.

When the report is runnig the parm1 value is "false".
How can I protect this parameter from a change by the user?
I mean - the user can run the report and then add to the url "¶m1 = true".

Can I do anything against that?
I tried marking it as "internal" and I thought that now it can get his value only from inside the report but it didn't worked.

Any ideas?

Thanks.

tm
Posting Yak Master

160 Posts

Posted - 2007-10-25 : 13:45:46
I don't know of a way to disable the parameter but if you are only setting the parameter based on another parameter, a work around would be to use a hidden textbox to hold your true/false value based on the other parameter?

You can then reference the hidden textbox.
Go to Top of Page

roy mm
Yak Posting Veteran

62 Posts

Posted - 2007-10-25 : 14:29:18
Hi.
There is a problem.
I won't to get a value from the report itself (like the user running the report) and use this value in a dataset.
To use it in a dataset, I need the value in a report and not in a textBox.
Now, even if I set the textBox to get the value I need and then tell the parameter to get his value from the textBox (and I don't even know if I can do it) - Still, if there isn't any way to protect the parameter, after the report will run and get his value from the textbox, the user can add to the url something like "¶m1=newvalue" and then run it again and I think that the default value will be over run by the new value.

Thats the problem.
Thanks.
Go to Top of Page
   

- Advertisement -