Post reply

Pass parameter from main report to subreport

  • April 30, 2015 at 4:21 am

    #296537

    I have a main report with a parameter called @Group. This allows me to choose which group, from the dropdown, from the data that I want to report on. The report will print invoice data for individual patients. The subreport contains invoice data; invoice number, the patient's unique medical record number(MRN), and the amount of the invoice. I need to filter/link the subreport to the main report based on the patient's MRN. Any thoughts? Do I need an MRN parameter in the subreport and main report?

  • April 30, 2015 at 7:52 am

    #1794681

    Hi you can create a data set which returns the medical record number based on the group and then pass this value to the subreport.

    When you run the report based on the parameter @group does it return one patient record or do you have multiple patient values?

  • May 1, 2015 at 6:41 am

    #1794956

    I added the parameter for MRN into the query for the subreport then, added a parameter called @MRN into the main report. This seems to work.

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

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