Skip to Content

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


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!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 02, 2019 at 10:05 PM

    Hi Mona,

    I'd recommend posting separate issues as separate discussions. The first issue looks very similar to the one you posted here:

    For the second question, you need to make sure:

    1. The subreport where the shared variable is initialized and assigned a value is placed in a section "above" the section that holds the other subreport or formula

    2. The section that holds the subreport that initializes the shared variable should not be suppressed.

    3. The shared variable isn't being reset in another formula between the sections.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 23, 2019 at 02:31 PM

    Thank you Abhilash, it worked perfectly.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.