Passing "hidden parameter" to Report via URL

Hi,

We are trying to pass a parameter ("hidden from user") to our report which we
access via an URL. Has anyone done this successfully? If so please outline the steps
and we'll be greatful forever!

Note: We have the latest Reporting Services software SP2 installed.
We have MS SQL Server Standard Edition - and thus do not have Report Manager on our server.

Any parameters passed using the GET method (parameters over the URL) will be visible to the user. One option you have is encrypting the value before sending it.
HTH|||Thanks for your reply - however we are not concerned with the URL line itself. The problem is that the
value never gets to the report and we get an error message about the parameter being 'read-only'.
If anyone has successfully passed an URL parameter to a report please document and share the steps! Many Thanks!
We have latest version of Reporting Services SP2, and MS SQL Server 2000 standard version.|||OK. Found the answer:
1) Make sure Reporting Services SP2 is installed.
2) Set up the report as if the user will be selecting /entering the parameter value.
3) Make sure the Report runs correctly.
4) Go back into the Report Designer and change the prompt string to one blank.
5) Test in designer (the parameter name will be used as a default prompt).
6) Deploy
7) Run report - passing parameter in the URL. This works, and you will not see a prompt.|||

Hi, I am facing the same problem. Can any one please provide me 'real' solution(code example) how to do it.

jrokita has tried to ans the Q but not enough support. The main Q was how to do it with URL. Not steps the way it will be done.

Thanks in advance.

Pass ToggleState as parameter

Hi,

I've developed a matrix report with two row groups. The second is visible or hidden depending on the toggle status of the first. I have set the navigation properties of the detail field to display a report of the underlying detail. I want to pass the current toggle state of the first row group to the details report as a boolean parameter. I this possible? I don't seem to have access to this property within the expression or code editors.

I'd be happy, as an alternative that implies the same thing, to pass the hidden / visible state of the second group.

Thanks,

Ian.
Did you ever solve this problem. I also need to get hold of the togglestate property in passing a parameter to a drill through report. Any ideas

Pass ToggleState as parameter

Hi,

I've developed a matrix report with two row groups. The second is visible or hidden depending on the toggle status of the first. I have set the navigation properties of the detail field to display a report of the underlying detail. I want to pass the current toggle state of the first row group to the details report as a boolean parameter. I this possible? I don't seem to have access to this property within the expression or code editors.

I'd be happy, as an alternative that implies the same thing, to pass the hidden / visible state of the second group.

Thanks,

Ian.
Did you ever solve this problem. I also need to get hold of the togglestate property in passing a parameter to a drill through report. Any ideas

pass hidden parameter from one dataset to another

I have 2 datasets in my report and I want to pass a field from the 1st dataset as a parameter to the 2nd dataset.

How can I do this?

I tried to set the report parameter from a query using the 1st dataset but the parameter is always equal to the first record in the recordset-it never changes per row.

I used a subreport and passed it a parameter based on each row to get this to work.