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.
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. |
 |
|
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. |
 |
|
|
|
|