Export one report per group in a specific folder

E

Elaine

Hi,

I have a report based on a query and have a variable that I am grouping the
report. I would like to be able to export a report individually for each
group and in PDF format and be exported in a specificied folder for each
group. The name of the folders will be the same name of the group.

Example:

the variable for which I am grouping is AMP_ID.
AMP_ID: 1234
AMP_ID:2165
AMP_ID:9889 and son on

I need to create the same report for each AMP_ID and saved it in the folder
C:\AMP_ID\rpt_AMP_ID.pdf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export report by group to a specific folder 0
Report Group Footer DLookUp 0
Outlook 2021 export question 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Use a variable in a ShapeRange.Increment 0
Solved Disk Full error message when exporting PDF 0
Folder structure in teams channel. 0
Export by group to a specific folder and name 30

Top