Two REPORT.RUN commands in a row don't work?

alsol
Member Posts: 243
Hi there,
I came across a strange issue and I have no idea what the reason is. The following code is supposed to silently print two reports in a row for each shipment that has been released. It should print it automatically to the system printer without a request form or any user interaction:
Now it prints always the first report, but not the second one. If I disable the first one, it prints the second one without any problems. But I could not make it work to print both of them. Are there some kind of limitations (NAV 2009 R2 RTC) that prevent the system from executing the REPORT.RUN command twice in a row?
Any ideas?
I came across a strange issue and I have no idea what the reason is. The following code is supposed to silently print two reports in a row for each shipment that has been released. It should print it automatically to the system printer without a request form or any user interaction:
HandlingUnitHeader.RESET; HandlingUnitHeader.SETRANGE(Source,HandlingUnitHeader.Source::Sales); HandlingUnitHeader.SETRANGE(Type,HandlingUnitHeader.Type::Package); HandlingUnitHeader.SETRANGE(Status,HandlingUnitHeader.Status::Open); HandlingUnitHeader.SETRANGE("Packing List Printed",FALSE); HandlingUnitHeader.SETRANGE("Ext. Packing List Required",FALSE); IF HandlingUnitHeader.FINDSET THEN BEGIN REPEAT REPORT.RUN(REPORT::"Sales Packing List",FALSE,TRUE,HandlingUnitHeader); IF ShippingAgent.GET(HandlingUnitHeader."Shipping Agent Code") THEN BEGIN IF ShippingAgent."Bill of Lading Required" THEN BEGIN REPORT.RUN(REPORT::"Sales Bill of Lading",FALSE,TRUE,HandlingUnitHeader); END; END; UNTIL HandlingUnitHeader.NEXT = 0; END;
Now it prints always the first report, but not the second one. If I disable the first one, it prints the second one without any problems. But I could not make it work to print both of them. Are there some kind of limitations (NAV 2009 R2 RTC) that prevent the system from executing the REPORT.RUN command twice in a row?
Any ideas?
0
Comments
-
Hi alsol,
code in your first report probably changes some data in HandlingUnitHeader record (e.g. "Packing List Printed") and this can lead to fall printed record out of scope. Changing data included in filter in loop is hazardous ever.0 -
Hi lubost,
Hmm you are right, I did not think of that. Ok, that makes totally sense, thanks a lot!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions