I have a main report pulling two Benefit Plan IDs (ID #1 and #2). I have a subreport that also pulls the same Benefit Plan IDs. I need it to display like this:
Main Report: Benefit Plan ID 1
SubReport: Benefit Plan ID 1
Main Report: Benefit Plan ID 2
SubReport: Benefit Plan ID 2
BUT, it is showing both Benefit Plan IDs in the subreport for each ID in the main report. It is displaying the results like this:
Main Report: Benefit Plan ID 1
SubReport: Benefit Plan ID 1
SubReport: Benefit Plan ID 2
Main Report: Benefit Plan ID 2
SubReport: Benefit Plan ID 1
SubReport: Benefit Plan ID 2
How do I fix this I have a report parameter created in the subreport called "BenefitPlanID" and it is linked to the "BenefitPlanID" column in the main report.
Thanks for any help!
jenr

subreport parameters not pulling data right
marla
I am pulling the "BenefitPlanID" column in both queries for my main and subreports. I am filtering on "BenefitPlanID" in both queries as well.
In my subreport, I have a report parameter created. In the main report, I set this report parameter to be equal to the BenefitPlanID column from the main report.
Thanks for your help.
jenr
AratiR