I'm using the exportwithformating macro action to export a report to a pdf file. The report data source is a query that reads a table of 100 brokers. The macro is repeated 100 times so that 100 unique reports are generated for each broker.
How can I code the output filename so that it varies with each broker ? For example report 1 would have output filename BROKER 1 and report 2 would have output filename BROKER 2. The output filename would need to vary with each report and read in the broker id, which is BROKER 1, BROKER 2, etc.
How can I code the output filename so that it varies with each broker ? For example report 1 would have output filename BROKER 1 and report 2 would have output filename BROKER 2. The output filename would need to vary with each report and read in the broker id, which is BROKER 1, BROKER 2, etc.
