Hi everyone,

I have a program in reportcaster with a list of identifiers at the top that I define so I can add to that list anytime with no issues. The program reads that list and counts how many identifiers are present. It then loops through the .fex for each value from the identifier list. I can't seem to get the program to deliver more than one file in Reportcaster. I am using Excel output and am OK outside reportcaster b/c I FILEDEF to a spot with different naming convention for each output/loop. Just can't seem to get the reportcaster verbage for all reports to end up in one e-mail.

Thinking I need to run through all with PCHOLD FORMAT EXL2K OPEN and then on the last loop/iteration change to PCHOLD FORMAT EXL2K CLOSE. Does that sound correct?

Thanks for any suggestions!

This message has been edited. Last edited by: Kerry,

This may also help. This is a very shortened version of the code.

---------------------------

TABLE FILE GETIDENTIFIER
PRINT
IDENTIFIER
WHERE (IDENTIFIER EQ '06017' OR '06965' OR '07920'......);
ON TABLE HOLD AS IDENTIFIERS FORMAT ALPHA
END
-RUN
-*
-SET &LOOPS=&LINES;
-REPEAT ENDREPEAT &LOOPS TIMES
-READ IDENTIFIERS NOCLOSE &P_PCDOCNUM.A6.

........Do a bunch of stuff to create report


ON TABLE PCHOLD FORMAT EXL2K
END
-ENDREPEAT

Yes, it has to be a Compound report (using the OPEN and CLOSE statements).

In your -REPEAT, you could compute a Dialogue Manager amper variable that would contain the 'OPEN', blank or 'CLOSE' value depending on if you're in the first, middle or last iteration of the REPEAT loop.

In the RC manual, it states that reportCaster is only able to distribute a single report(including bursting a single report into mutiple sections). What you are try to do is distribute multiple reports with a single job, which will not work.

Follow Francis' suggestion a create a compound document and you'll be able to get what you need. Otherwise, your only option is to set up multiple jobs, but then you also get multiple emails.

You could also set up 1 job with multiple tasks generating 1 email with multiple attachments.