This discussion has been locked.
You can no longer post new replies to this discussion. Posts are automatically locked, when no new replies have been made for a long time. If you have a question you can start a new discussion.

How to?: Generate a detail report if the summary

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.


Edited by - swinsb on 2001 Jul 06 17:57:27
  • Hi,
    You can use the repeat until loop for collecting data in the array

    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

    hope this helps.

  • 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