Jet Express MS NAV - Limiting number of records in query

lizelleb

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

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'General Chat' forum]

aseigle

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?"