[SOLVED] Loop in ReportCaster

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,

WebFocus 7.6.6 Win 2K

Posts: 29 | Registered: June 19, 2006

jcs1226

Member

posted

Hide Post

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

WebFocus 7.6.6 Win 2K

Posts: 29 | Registered: June 19, 2006

Ignored post by jcs1226 posted

Show Post

Francis Mariani

Expert

posted

Hide Post

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.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Darin Lee

Virtuoso

posted

Hide Post

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.

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Show Post

Gerry

Silver Member

posted

Hide Post

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

WebFOCUS All Releases

Posts: 45 | Location: NYC | Registered: September 21, 2007

Ignored post by Gerry posted

Show Post