Having Problems With My Report

matseke
Member Posts: 11
hi there
I am new to navision and i have manage to write good reports so far...
my bproblem is, i have no idea how to create a dummy field which will only appear when lets say:
if say inventory balance is1000 and quantity delivered can only total to 800(not enough shipment to cover the inventory balance). So i want the report to to fill in the remaining 200.This scenario must remain in the report. However if this is the case the new boolean field should be flagged as "yes".
Pls HELP...
I am new to navision and i have manage to write good reports so far...
my bproblem is, i have no idea how to create a dummy field which will only appear when lets say:
if say inventory balance is1000 and quantity delivered can only total to 800(not enough shipment to cover the inventory balance). So i want the report to to fill in the remaining 200.This scenario must remain in the report. However if this is the case the new boolean field should be flagged as "yes".
Pls HELP...

0
Comments
-
You could create a new global variable.
Then in the OnAfterGetRecord trigger of the dataitem you can set the value of your new variable.
On the section designer you can add a new textbox and set the source expression to your new variable.
Hope this helps you a bit.This isn't a signature, I type this at the bottom of every message0
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