0

Lookup filtering based on previous options selected.

Jet Reports Historic Posts

January 14, 2011 05:56

None

Follow

Hi,

Scenario: This is w.r.t. to Indian Localization -> Navision
I have 3 parameters (options) for my report generation. Company Name, Posting Date and State Code. The user will select the company and posting date. The State Code lookup filter should be based on the Company and the Postign Date selected.
Is there a way to do so ?

Regards,
Renu

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts January 18, 2011 22:30

  Hi Renu,
  
  Yes you can make an NL(Lookup) formula reference the other option values in the Value column and they will be based on the option values which the user selects.
  
  Regards,
  Hughes