Subtotals for 3 Groups - 3 Variables or 1 Variable?

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Lets's say that in my report, that I have detail records at the employee level.  Every employee is a member of one department.  Every department is a member of one division.  Every division is a member of one organization.  So my report is kind of like this:


Organization
     Division
          Department
               Employee
          Department totals
     Division totals
Organization totals

Normally for the totals, I would create 3 variables.
One for Department, with the Reset Type = [Group] Department
One for Division, with the Reset Type = [Group] Division
One for Organization, with the Reset Type = [Group] Organization.

That is how I normally do things.  It works.  The only drawback is creating a Variable for each group.

 

Is there a way to only use one variable in all three group band totals?

I ask because I notice that when I add a Variable to the report, in the Text Field property, there is an Evaluation Time field.
Maybe like I can set the Evaluation Time to Band (or something else), and then for the Variable I set the Reset Type to something like band (though that is not a choice), and then I can use the one variable in all 3 group bands and it knows how to properly calculate.

Fewer variables would be faster to create, and easier to maintain.

Thanks.

mwarner_2's picture
1750
Joined: Jul 10 2015 - 1:17pm
Last seen: 4 years 11 months ago

0 Answers:

No answers yet
Feedback