Get Value of Selected Drill Down item to Display a Sub Report
Hi Yawl, I am fairly new to SSRS, I'm using SSRS 2005. I am creating a report listing all say Correspondences of a certain Type say Letters. So the report is showing all Correspondences of Type 'Letter', what I want is a drilldown base on each Correspondence selected. I want to get the Id of the Correspondence and run a sub report . How is this possible? I want to get the Id of the Correspondence that the user selected in the drill down and to display a sub report there. Please help me. any assistance would be greatly apprepicated. Thanks
February 10th, 2011 9:33am

Ok So in the ID textbox in the properties in the Nav tab i selected 'Jump to Report' and selected the report I want to display. However I would like this report to show up directly under the ID I selected. I added a row under this and dragged a Sub Report linking it to the report the 'Jump to Report'. I sent visibility to be hidden with expression =iif(Fields!CorrID.Value,True,False). However the Sub report does not display when i select the Id, it still goes to the jump to report. I want it to display right under it. Help pleasee
Free Windows Admin Tool Kit Click here and download it now
February 10th, 2011 11:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics