Summing a variable in Group Header band level shows as null. Works in Group Footer band

USA null ( should show sum of 500 + 300 but shows null) CA 500 CO 300 Canada null ON 100 Alberta 200
dprogrammer's picture
Joined: Jul 19 2006 - 7:37am
Last seen: 2 months 4 days ago
 

USA null ( should show sum of 500 + 300 but shows null)

CA 500

CO 300

Canada null

ON 100

Alberta 200

dprogrammer - 6 years 11 months ago

Applogize for the formating. I don't know what's happening with the forum site. It does not show a previw of the post and messes up the formating of the sample report that I put there. Basically USA is a GROUP and I need to sum totals for CA and CO and show it in a varialbe in the GROUP HEADER but it's coming up null. I am palying around with 'Evaluation Time' but still no luck. 

dprogrammer - 6 years 11 months ago

Was able to fix it. Let me know if anyone would like to know what needs to be done. 

dprogrammer - 6 years 11 months ago

1 Answer:

The Text field for the Variable should be evaluated at Group. 

Right click on the text field and show properties

On the properties tab, Click on Text Field options and change the Evaluation time from Now to Group level.

reportdev's picture
12998
Joined: Oct 12 2015 - 12:05pm
Last seen: 1 year 3 months ago
Feedback