Jet Express MS NAV - Limiting number of records in query

lizelleb
lizelleb Member Posts: 2
edited 2012-03-16 in General Chat
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

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV Tips & Tricks' forum to 'General Chat' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • aseigle
    aseigle Member Posts: 207
    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?"

Categories