0

Scheduler

Jet Reports Historic Posts

February 02, 2011 08:18

None

Follow

Hi,

I try to work with the scheduler. Actually I have the question, how I could change the default financial client with the scheduler automatically. I must change the client, because we have different tables (for each client one) for our cost units.

Thank you in advance for your support and your sugggestions.

Rudi

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Jet Reports Historic Posts February 02, 2011 23:25 Official comment

  So in an NL formula, you can select which Nav or GP company to use with a "Company=" filter something like this:
  
  Cell B3: default financial client
  Cell C4: =NL("Rows";"Table";"Field";"FilterField1";"Filter1";"Company=";B3)
  
  So then you can set filters for all your NL (and GL) functions to use the company in cell B3. Then you can make cell B3 an Excel named range and in the Scheduler you can tell it to change that named range to a specific company name. Does that make sense?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts February 02, 2011 16:11

  Hi Rudi,
  
  What do you mean by "default financial client"? Do you mean default data source? You can't change the default data source from the scheduler but you can put a filter on your report for the data source name and then use "DataSource=" filters in your functions to make them use that specific data source. Then you can set the data source filter using the Scheduler. Does that make sense?
  
  Regard,
  Hughes

• 0
  
  Jet Reports Historic Posts February 02, 2011 16:55

  Hi Hughes,
  
  thank you for your answer.
  The "default financial client" is one of our companies.
  I think you are right. But i didn't now, what I have to do.
  How can I use "DataSource=" filters in my functions?
  Did you mean for example "=NL("Rows";"DataSource";"Company1"…)"?
  
  Best regards,
  Rudi

• 0
  
  Jet Reports Historic Posts February 03, 2011 07:59

  Hi Hughes,
  
  thank you very much!!!
  
  Regards
  Rudi