Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ReportCaster Library output custom VERSION Title

Read-Only Read-Only Topic
Go
Search
Notify
Tools
ReportCaster Library output custom VERSION Title
 Login/Join
 
gregv
Guru
posted
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
 
Posts: 274 | Location: Boston/New England | Registered: February 12, 2006Report This Post
SWES
Platinum Member
posted Hide Post
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
 
Posts: 198 | Location: Amsterdam | Registered: August 24, 2011Report This Post
gregv
Guru
posted Hide Post
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
 
Posts: 274 | Location: Boston/New England | Registered: February 12, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
gregv
Guru
posted Hide Post
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
 
Posts: 274 | Location: Boston/New England | Registered: February 12, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
gregv
Guru
posted Hide Post
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
 
Posts: 274 | Location: Boston/New England | Registered: February 12, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ReportCaster Library output custom VERSION Title

Copyright © 1996-2020 Information Builders