0

Creating multiple Excel files

Jet Reports Historic Posts

June 19, 2008 16:12

None

Follow

Hi there.

The NL function can create multiple sheets, but is there a way of creating multiple Excel files?

For example, I might want a seperate Excel file for each Salesperson, and a seperate sheet within that file for each of their Customers.

Any ideas would be appreciated.

thanks, Mark

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts June 26, 2008 19:04

  Short of running the report once for each salesperson, i don't think jet can create multiple files with multiple tabs in them from one single report.
  
  However, you could create a report that would run for any salesperson, using an options page to select the salesperson and have the salespeople run their own reports when they need them.

• 0
  
  Jet Reports Historic Posts June 26, 2008 19:38

  I just found this article on the support site
  
  http://support.jetreports.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=480
  
  That uses the Jet Scheduler to create batch files that does something very like what you want. Only thing is the article talks about sending each report in an email, but it doesn't look like it would be that hard to have it create each file with a different name instead. Take a look.

• 0
  
  Jet Reports Historic Posts June 26, 2008 19:49

  Hi there Chuck. I've had a look at the link - and I can see how it works. That would do the job nicely for what I have in mind.
  
  Thanks for your help!
  
  cheers, Mark

• 0
  
  Jet Reports Historic Posts June 27, 2008 13:08

  very good .. thanks for correcting my error and providing a very useful link.