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 ?

Comments

  • edited 2:25AM
    Ok, a quick squiz through the FAQ I found the answer:

    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)

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.