Multiple Master Data and Master Footer issue
Hi all,
I have the following band scenario:
Master Data
Master Footer
Master Data
Master Footer
On each of the Master Footer bands I have an expression which calculates the SUM of data field values for the specified Master Data band. The problem is that only the last Master Footer band seems to work, the first Master Footer expression calculates to 0 every time. If I remove the second Master Data band, the first Master Footer expression works 100%, so it seems to indicate that once the second Master Data band is added the first Master Footer expression either gets skipped or is unable to access the data fields.
Any idea how I can fix this, or possible work arounds ?
I have the following band scenario:
Master Data
Master Footer
Master Data
Master Footer
On each of the Master Footer bands I have an expression which calculates the SUM of data field values for the specified Master Data band. The problem is that only the last Master Footer band seems to work, the first Master Footer expression calculates to 0 every time. If I remove the second Master Data band, the first Master Footer expression works 100%, so it seems to indicate that once the second Master Data band is added the first Master Footer expression either gets skipped or is unable to access the data fields.
Any idea how I can fix this, or possible work arounds ?
Comments
Q: 1.8. The SUM function works incorrect.
(in the report with two masterdata bands can't get sum the second band)
A: FR can't determine which band to sum. Use the extended SUM syntax (also for MIN, MAX, AVG): SUM([CustNo], MasterData2)