Reporting Services passing values from Subreport to Main report

I am just starting to create all new reports using Reporting Services. I will have many instances where I will have to pass values from a subreport to the main report. How can this be done?

I hope the following link will help you solve your problem.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_1ed0.asp

--Amde

Reporting services passing parameters

I have a report that is link from another report, I've created this link in the report designer by using the rightclick textbox>select properties>Navigation tab > jump to report.

Now I have passed 4 parameters over to the new report, these are hidden and shouldn't be seen by the user. There is however a fifth parameter that should be set by the user at run time, as this controls what the report shows. This works perfectly when I'm in the designer using the preview tab. However once I upload the report to the server, I get an error message saying that the fifth parameter is missing a value! Even though in report manager the fifth parameter is set to prompt User, it will not display a prompt and allow a user to input the data, it just says that the parameter is missing a value and that's as far as it gets.

I think this must have something to do with how report manager renders the parameters of a report but I can't seem to find any information on it anywhere. Can anyone help at all?

Hi James,
Two days ago I encountered the same issue with one of my reports. On the local designer studio everything worked fine and as soon as I uploaded it to Report Manager the parameter was not prompting for value but kept on complaining.
All I had to do was, save the report locally, reboot the machine and upload it again. I know its a crazy answer but it worked for me. On a hindsight, I guess it was caused by RDL file not getting updated or getting corrupt for some reason.
HTH
Uday
|||

Cheers hedgeu

I tried that though and it's still not working, i'm not sure if it's the way that i'm passing the parameters or weather it's a rendering problem all i know is i can't seem to get it to work.

James

|||

I'm not sure if this will fix your problem, but I have an idea you can try if you are still stuck.

Go to: http://localhost/Reports (keep in mind this is a different location from ReportServer)

Find the report which is accepting the parameters (ie, the one in which the user should enter a value for the parameter) and open the report.

Now, at the top of the page, click "Properties". Then select "Parameters"

Verify that your fifth parameter has a check for the prompt user option and that the hidden checkbox is not selected.

Once that is fixed, you should be good to go. Try to link to that report now.

Reporting Services Data Extension - Passing Report Parameters

I have created a custom data extension.

I am using this custom data extension from BI Studio.

Que1: I want to create report parameters from BI studio and capture them in my Data Extension.

Que2: Every report parameter has so many properties, like hidden, internal, default value etc, how do capture that information in my data extension, the parameters only give me name and value.

Que3: I know I can capture command Text. So My command can be Select * From tablename where fieldname= @.myFieldname. Once I get this commandText in my data extension, How do extract parameters of the command?

Que4: If I have any custom attributes in my RDL file, Can I capture them in my Data Extension ?

Any help is appreciated...

Anybody, Any suggestions, please.....