report: showing if not present

dakingdaking Member Posts: 4
edited 2007-03-26 in Navision Financials
Hallo,

I want to make a report with the following functionality:

2 tables

1 with car numbers, and specifications
1 with driving hours of those cars.

The report has to show me all the cars that do not have driving hours.

I though with a find and than a curr. rep. skip but i am stuck...

Thx in advance,

daking

Comments

  • WaldoWaldo Member Posts: 3,412
    Cars without driving hours ... :-k

    What if you create one dataitem (cars).
    some pseudo-code:
    OnAfterGetRecord:
    
    recDrivingHours.RESET;
    recDrivingHours.SETRANGE("Car No.", recDrivingHours."Car No.");
    IF NOT recDrivingHours.ISEMPTY THEN
      CurrReport.SKIP;
    

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
Sign In or Register to comment.