Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 323 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Jet Express MS NAV - Limiting number of records in query
lizelleb
Member Posts: 2
I have found the following formula in the Jet Reports Help files but when trying to use it in Jet Express 2011 to limit the number of records returned in my query, it gives me a #VALUE error:
=NL("Rows","Customer","Name","-Sales($)","*","Limit=",10)
Now my query / formula in Excel after extracting the required information from my NAV Database looks like this:
=NL("FlowField","Vendor","Balance",)
I have tried to modify it according to the help file formula in the following 2 ways but both return a #VALUE error in Excel:
=NL("FlowField","Vendor","Balance","*","Limit=",10)
and
=NL("FlowField","Vendor","Balance","Limit=",10)
Can anyone advise if these formulaes can be used in Jet Express or only in Jet Essentials? This has done my head in so if anyone can help me get this to work i will be greatful.
Lizelle
=NL("Rows","Customer","Name","-Sales($)","*","Limit=",10)
Now my query / formula in Excel after extracting the required information from my NAV Database looks like this:
=NL("FlowField","Vendor","Balance",)
I have tried to modify it according to the help file formula in the following 2 ways but both return a #VALUE error in Excel:
=NL("FlowField","Vendor","Balance","*","Limit=",10)
and
=NL("FlowField","Vendor","Balance","Limit=",10)
Can anyone advise if these formulaes can be used in Jet Express or only in Jet Essentials? This has done my head in so if anyone can help me get this to work i will be greatful.
Lizelle
0
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
=NL("FlowField","Vendor","Balance","*","Limit=",10)
Where did you come up with "Flowfield?"