Dear Focateers: I've done my searching but to no joy.
Does anyone know if a custom output title can be created for a RC report? The request I have is to add today's date at the end of the output title of a PDF for a Report Library. If this is possible, how can I do it or is there documentation on this?
Thanks so much.This message has been edited. Last edited by: gregv,
Greg
current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11
That's certainly possible. Use the following method:
DEFINE FILE HOLD
DISPLAYDATE/A8YYMD = '&YYMD';
END
TABLE FILE HOLD
PRINT
VALUE AS 'Value'
-*[ BURST VALUE ---> IN ORDER TO SHOW DATE VALUE IN FILE NAME OUTPUT ]
BY DISPLAYDATE NOPRINT
BY FIELD_A AS 'Field A'
BY FIELD_B AS 'Field B'
BY FIELD_C AS 'Field C'
Here you make the first BY-field, DISPLAYDATE, the date you desire in the file name, e.g. today's date. After that, make sure you select the option 'Burst Report' in ReportCaster under the tab 'Task'.
Good luck, SWES
WebFOCUS 8105m Windows 7, All Outputs
Member of the Benelux Usergroup
September 28, 2016, 11:15 AM
gregv
Got it! Thanks SWES!
Greg
current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11
Hmmm, this technique creates a Report Library object with the burst value, then multiple versions inside it. If the burst value is an often-changing date, very soon you'll have a bunch of objects with one or more versions within. I don't think this really answers the question (even though it's marked "solved").
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
September 28, 2016, 11:57 AM
gregv
Always good to have multiple perspectives. Thanks Francis!
Greg
current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11
Here's an example report using an IBI supplied sample table that contains a date column. The report randomly chooses one date from the table and uses it in the burst value. Run it a few times via Report Caster to see what happens in Report Library.
Now, if someone can suggest how to name the report version differently than "Version NN", I'll buy them a doughnut.
DEFINE FILE IBISAMP/CASHFLOW
RANDOM_NUMBER/D12.2 WITH CASH_DATE = RDNORM(RANDOM_NUMBER);
CASH_DATEX/A8YYMD WITH CASH_DATE = CASH_DATE;
CASH_DATEY/A10 = EDIT(CASH_DATEX, '9999-99-99');
BURST_VALUE/A100 = 'My Report Library Object - ' | CASH_DATEY;
END
TABLE FILE IBISAMP/CASHFLOW
SUM
BURST_VALUE
LONG_TERM_DEBT
INTER_TERM_DEBT
SHRT_TERM_DEBT
BY HIGHEST 1 RANDOM_NUMBER NOPRINT
BY CASH_DATEY
ON TABLE HOLD AS HOLD_CASHFLOW
END
-RUN
TABLE FILE HOLD_CASHFLOW
SUM
LONG_TERM_DEBT AS 'Long Term Debt'
INTER_TERM_DEBT AS 'Inter Term Debt'
SHRT_TERM_DEBT AS 'Short Term Debt'
BY BURST_VALUE NOPRINT
BY CASH_DATEY AS 'Cash Date'
ON TABLE SET PAGE NOLEAD
END
-RUN
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
September 28, 2016, 04:59 PM
gregv
Wow, Francis, you have really looked into this. Thanks for your research. It was the version name that I was after which, from what I've learned, does NOT change. I change the status.
Greg
current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11