Focal Point
Pass variable to Report Caster filename

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2101010342

August 21, 2007, 09:32 AM
mark66
Pass variable to Report Caster filename
Hi all,

I am wanting to use a live date in my Excel file that is generated via the Report Caster. I was hoping I could just reference it in the "Save Report As" section, for example:

Save Report As = "Orders &V_ORDER_DATE"

&V_ORDER_DATE is populated in my report fex, but the Excel file I receive is called "Orders &V_ORDER_DATE.xls"

We are running version 5.35.

I found this old thread that was asking pretty much the same thing, but thought I would create a new one as the original query was from January 2005:

https://forums.informationbuilders.com/eve/forums/a/tpc/...1028331?r=7101038331

Many thanks

Mark


WebFocus 765. iSeries v5r4
August 21, 2007, 12:15 PM
Darin Lee
There have been a few more recent threads liek this as well, but still not a way to do it like you describe. You could, however, build a dynamic distribution list which would only have the burst values in it (could have one or many) and include a high-level BY (for order date) in the report. Then when RC runs the report and bursts it, it would include the burst value in the name of the file.


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