Skip to Content
Oct 02, 2019 at 05:26 PM

Shared variables passing in two subreports...not to main report

59 Views Last edit Oct 03, 2019 at 09:44 PM 2 rev


I have three subreports ( overdue items, owing fines, misc fines) which are posted in details sections like detail a,b,c,. Main section is empty as I donot want my reports to be filtered at all. The main report has all students#. The whole idea is if any student has one or more items like overdue or fine or misc, it will show on my report. I have a hard time grouping by homeroom followed by student # and suppressing data those who do not have either overdue fine, misc fines or overdue items as my detail section has only student#. If I run without grouping, it works perfect, no issue at all.

How can I achieve the result?

My second issue is, I have added bill payment report in detail section as 4th report as subreport, but I have a hard time using shared variable as I am unable to pass shared variable from one sub report to another sub report. But, if I put my bill payment sub report in the detail section, shared variable works great, but it filters my other report (overdue report). Is there any way I can achieve both results?

Please help!