Saving report based on department

[catssolutions]

Hi All,

I have a DB that is used for sales. I have a report which is used to create an PDF invoice for a company which works fine.

The problem is that we are taking on a new customer that wants to have a individual invoice based on departments, as a sepearte pdf. I could do this manualy for each department but this is long winded. Is it posible to run the report and at each change of department field save the file.

Hope this makes sense?

regards

Darren

 

[ajetrumpet]

Yes, it's possible, but there is not enough information here to give a concrete answer.

 

[catssolutions]

hi Thanks for your reply, What additional infomation would you need? I have a query that returns all customers orders sorted by there department code. I produce a invoice based on this query. I can save a single pdf with all departments starting on a new page and totals for each department.

What I would like to do is run the report to generate the pdf but at each change of department save a new pdf in a default location. Naming convention for each pdf would be combination of department and date.

Thanks in advance

Darren

 

[ajetrumpet]

I doubt you can make multiple PDF documents from one single report, unless you had some sort of Add-in from Adobe Acrobat.

I would say just run the reports for all the different departments. If you have Adobe Acrobat 8 though, there is a function in there that can split one PDF into many, or the other way around. You might want to try that function if you have version 8.

Can't think of any other way off the top of my fingers...