R
RoryD
I have a macro that runs the same report 30 times, and uses a "Where
Condition" ([County_Name]="Cork", [County_Name]="Dublin", etc.) to specify a
differenty county filter for each report. The report is set to print to
PDF, and I want to print each report to a different report caption/pdf file
name that includes the county from the "Where Condition". Currently every
report prompts with just "Monthly Sales.pdf" because that is what the Report
Format Caption specifies. I want to append the county name to each Caption,
e.g.
"Monthly Sales - Cork.pdf"
"Monthly Sales - Dublin.pdf"
etc...
Any ideas how I can achieve this?
TIA,
RoryD.
Condition" ([County_Name]="Cork", [County_Name]="Dublin", etc.) to specify a
differenty county filter for each report. The report is set to print to
PDF, and I want to print each report to a different report caption/pdf file
name that includes the county from the "Where Condition". Currently every
report prompts with just "Monthly Sales.pdf" because that is what the Report
Format Caption specifies. I want to append the county name to each Caption,
e.g.
"Monthly Sales - Cork.pdf"
"Monthly Sales - Dublin.pdf"
etc...
Any ideas how I can achieve this?
TIA,
RoryD.