Skip to Content
author's profile photo Former Member
Former Member

Summarise Value in Main Report which links to Shared Variable in SubReport

I have a Main Report and a linked Sub Report with a Shared Boolean Variable. The Shared Variable is returning the correct values and I have been able to use the result in a formula calculation (@Management Fee). I am then trying to summarise the value returned in the @Management Fee formula at Group Header 1 level, and the system won't allow it due to the reset formula I have in the subreport of the shared value.

The sub report is set up as follows:

Details A

@Reset VAR

whileprintingrecords;

shared booleanvar Deduction:=false

Details B

@Shared VAR

whileprintingrecords;

shared booleanvar Deduction;

Deduction:={@Deduction}

Details C

@Deduction

if {DeductDetail.Deduction}="Management Fee" then true

In the main report I have the linked SubReport in Details A and the Shared Variable in Details B as follows:

@DeductionVAR

whileprintingrecords;

Shared BooleanVar Deduction;

Deduction;

How can I summarise the value of @Management Fee and formulas using this value given the reset issue and also the fact that the other figures used in the formula are not contained within the SubReport?

Any assistance you can provide would be appreciated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 01, 2010 at 03:51 AM

    Resets are not usually in the same part of the report as the formula doing the calculating. If you do not have a group header, try putting the reset in the report header of the subreport.

    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.