Options

rEPORTS IN NAV 2009

sabzamsabzam Member Posts: 1,149
edited 2011-01-07 in NAV Three Tier
Is it possible to stop a report from printing if no record is available when printing a report in NAV 2009 RTC. At the moment I'm getting a blank page and I want to avoid it as well.

Comments

  • Options
    afarrafarr Member Posts: 287
    In NAV 2009 SP1, in report 205 Order Confirmation I put the following code, and the report still printed a blank page (with page number 1) when there no records to print. This happened both if the code was in Customer - OnPreDataItem and if it was in OnPreReport. So CurrReport.BREAK does not work as I expected it to.
    IF "Sales Header".ISEMPTY THEN
      CurrReport.BREAK;
    
    Alastair Farrugia
  • Options
    naviannavian Member Posts: 39
    You will need to use the Hidden property in the layout.
    Something like this:
    =(Fields!No_.Value = "")
    Where the No_ field is a non visible field in the classic report.
Sign In or Register to comment.