Saving report by groups

[doctorswamp]

Hi

I'm outputting data on customer orders to a report and want to save it for emailing. This is okay as I can save as rtf.

There may be several items in an order, and the items may come from different suppliers. The report groups by supplier, with separate sections for each.

I'd like to be able to create separate saved copies of items by supplier. This would avoid having to open the composite report in say Word, and manually splitting it and saving by supplier.

Any hope?

 

[mhartman1]

Hello:

One way would be to base each report on a query by the supplier. You would have a file for each supplier

Another way would be to start each new group on a separate page. You would have one file but it would be easier to separate the data into distinct reports.

Regards
Mark

 

[doctorswamp]

Hiya Mark

I already create the output report with separate pages per supplier, and can save it as one rtf file. But I then need to dissect it manually to create individual emailable sections.

Running a further set of queries by supplier would work but has a maintenance overhead eg if suppliers change.

Since reports have the grouping function that automatically create separate pages for suppliers, whoever they are, I wondered if a similar function exists not just to preview the separate pages but to make them available for saving programmatically.