Passing Parameter Value to sub-report

  • I have created a report within the solution that needs a  Customer_ID as a variable to populate item info regarding that paticular customer.

    On the main report I have a list of the customers and other information grouped by customer. I want to have an "items" sub-report (not sure if a sub-report is the way to do it) list appear when a user selects the link "items" within a paticular customer from the main report.

    How can I pass that paticular Customer_ID to the subreport(if a sub-report is the correct choice)  only when that link is selected?

  • OK I added the sub-report to the data row and choose the parameter value that I wanted to supply it and it worked. Only thing is it takes a lot longer to run the report. Is there a way to link to another report suppling the paticular customer_id so RS doesn't have to run the sub-report if the user doesn't want to see this additional info??? TIA!!

  • I have done something that sounds similar to this. I placed a text box with the text 'Detail'. The navigation properties on this box where set to run the report and pass the parameter. The user clicks on the text box and it runs the report. The connection strings and user profile has to be stored to have this work.

     

    Stuart Johnson

  • how about using the "jump to report" option 

    in the navagation TAB from the properties window ?

     

    RUud

    Ruud

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply