mibuso.com

Microsoft Business Solutions online community
It is currently Thu Nov 27, 2014 4:52 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Jet Express MS NAV - Limiting number of records in query
PostPosted: Thu Mar 15, 2012 9:55 am 
Offline

Joined: Fri Jan 08, 2010 10:39 am
Posts: 1
Country: South Africa (za)
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


Top
 Profile E-mail  
 
 Post subject: Re: Jet Express MS NAV - Limiting number of records in query
PostPosted: Thu Mar 15, 2012 6:48 pm 
Online
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 9:13 am
Posts: 7705
Location: Milan
Country: Italy (it)
[Topic moved from 'NAV Tips & Tricks' forum to 'General Chat' forum]

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: Jet Express MS NAV - Limiting number of records in query
PostPosted: Fri Mar 16, 2012 1:52 pm 
Offline

Joined: Mon Jun 08, 2009 1:24 pm
Posts: 166
Location: Connecticut
Country: United States (us)
I'm certainly not a Jet Report expert, but I've never seen an NL Function with a "What" of 'Flowfield.' (The "What" comes from the wizard)

=NL("FlowField","Vendor","Balance","*","Limit=",10)

Where did you come up with "Flowfield?"


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: