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.
