Focal Point
ReportCaster Library output custom VERSION Title

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

September 27, 2016, 02:11 PM
gregv
ReportCaster Library output custom VERSION Title
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

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
September 28, 2016, 09:49 AM
SWES
Hi Greg,

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

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
September 28, 2016, 11:49 AM
Francis Mariani
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

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
September 28, 2016, 02:00 PM
Francis Mariani
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

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8