Coding to so that my report does not show zero records

mikelacey

Hello - I am running Navision GB v4.0 on C/Side.

I have set up a report which uses the Ledger Entry Dimension Table, the Dimension Value Table and the G/L Entry Table. Users put in a Dimension Value Code filter on the Ledger Entry Dimension tab eg: Global Dimension Code 3...then a G/L Account No.

The report then displays every single Dimension Value that has been set up and shows an amount outstanding for each one for the G/L Account No. specified. This is fine, but how can I get the report to not display records where the amount will be 0? So if there is not a balance outstanding for a Dimension Value on the specified G/L account no. it is not dsiplayed on the report.

Many Thanks,
Mike

Albertvh

Hi

in the AfterGetRecord you could add code

IF Dimension.value = 0 THEN
  CurrReport.SKIP;

or in the PreSection

CurrReport.SHOWOUTPUT := Dimension.Value <> 0;

Hope this gets you going

mikelacey

Hi,

I'm glad I asked - thought it would be something simple...that has worked perfectly now.

Thank you for setting me on the right lines! Have saved me some time, I was starting to get annoyed I couldn't think of the coding required!

Mike