Conditionally Hide Report Header

kirtangor

Hello All,

I am using NAV 2009, and I am customizing the report "329 - Vendor - Trial Balance" for the classic client.

The requirement is such that I have to hide the groups which have the totals as 0. The totals are being calculated in the groupfooter, so I am able to hide the groupfooter based on this condition, but I also have to hide the header (Vendor, GroupHeader(6) to be exact) when the total is 0. How should I achieve it?

Slawek_Guzek

Hi,

It is not possible without some programming. In general NAV client process and prints the header, then process and prints lines, line by line, and then process and prints the footer, so once header is printed/shown there is no way to hide it in footer.

Header will be hidden automatically only if you set PrintOnlyIfDetail to TRUE, and only if there will be no lines printed, but if you print any single line the header will be printed as well.

Workaround is to calculate summary in group header (using some function that you need to write, called in OnPreSection trigger in GroupHeader section), and then hide the group header and lines until you encounter next group header.

Regards,
Slawek

kirtangor

Thanks Slawek. That's what I too had in mind. But, I thought there might be another way, so I posted this question here. But, anyways, I'll go ahead with implementing this using the programmatic approach.

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]