How to?: Generate a detail report if the summary

Business Central/NAV User Forum
1

I am trying to generate a detail report that prints the detail of records only if the summary totals <> 0 based upon a two field key. I think I need to collect the detail in an array until the key values change (up to 20 records max). Summarize the totals and decide whether or not to print the detail and summary. Does this sound like the best solution? If it does, I don’t have the first clue as to how to collect the data into an array until the key values change. help? Edited by - swinsb on 2001 Jul 06 17:57:27

2

Hi, You can use the repeat until loop for collecting data in the array eg. repeat Arr[1] += SomeValue; until firstvalue <> secondvalue; And for printing the Details based on the Total collected in Arr[1], use the following on the OnPreSection() trigger of the reports section which displays the Summary. if arr[1] <> 0 then CurrReport.SHOWOUTPUT(True) else CurrReport.SHOWOUTPUT(False); hope this helps. Regards Vishal

3

A two level same record Indented report should work for this. Set a flag in the none printing first DataItem GroupHeader to False and to True in the footer if the Amount <> 0. Then either break or print the Indented records. David Cox MindSource (UK) Limited Navision Solutions Partner Email: david@mindsource.co.uk Web: www.mindsource.co.uk