Hello Community,
I have been trying to display the values of a subreport in a newly designed report. The subreport, when run individually, displays the correct results, but when added in a report it doesn’t display the values.
The main report:
The parameter that I have added:
Subreport:
Attaching the report for reference:
Best answer by Harshita
View originalIf you believe the subreport is correct, can you try moving the fields on the subreport from the PageHeader section to one of the group sections or the detail section and run a quick test to see if the results are visible?
It’s been awhile but I thought you are not able to bring in report/page headers and footer sections on a subreport into the main report - I typically use the group header/footer sections to bring information into the main report.
If that doesn’t solve your issue, I would view the Trace after printing the main report to see if there are any background errors when executing. At a glance, your parameters look good but sometimes there are issues when passing to a subreport, especially with Project ID field. I’ve found including a join to the PMProject DAC and then filtering by PMProject.ContractID or CD in the subreport usually resolves any issues there.
If you believe the subreport is correct, can you try moving the fields on the subreport from the PageHeader section to one of the group sections or the detail section and run a quick test to see if the results are visible?
It’s been awhile but I thought you are not able to bring in report/page headers and footer sections on a subreport into the main report - I typically use the group header/footer sections to bring information into the main report.
If that doesn’t solve your issue, I would view the Trace after printing the main report to see if there are any background errors when executing. At a glance, your parameters look good but sometimes there are issues when passing to a subreport, especially with Project ID field. I’ve found including a join to the PMProject DAC and then filtering by PMProject.ContractID or CD in the subreport usually resolves any issues there.
Hello
I have established the following join in the subreport:
And the result of the subreport is displayed correct:
Now coming to the part of the main report,
I added the same subreport, with the same parameter :
Upon running the main report,
It only displays the text from the subreport, but not the values of a data field:
Also to mention here, the parameters being used for the main report, the external parameter and the one used in subreport are all same.
I assume if the issue is related to the parameters part?
Attaching the trace after generating the main report:
Also attaching the XML file for both main & sub reports:
Hello
The issue has been resolved. The point where I had made mistake what in the External Parameter part where I has to use the name of the parameter same as that of the subreport one.
& now the report displays the correct value:
Thank you for sharing your solution with the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
