[CASE-OPENED] changing the output filename dynamically with InfoAssist, ReportCaster

Hello Forum,

I've created a report within infoassist and change the filename
with following changes within the Report1.fex.
>
>-SET &FileName='My_selfdefinedname_' ||&DMYY; // set a selfdefined filename and add the date
> ON TABLE PCHOLD AS &FileName FORMAT EXL07 // use of the selfdefined filename
>

That works well, but there are disadvantages:
1. I can't go on work on this report with infoassist, only with the text-editor.
So I ask you, if there any other possibilities to change
the filename in a better way, than with the .fex-change?

2. This don't work whith the ReportCaster(output: E-Mail, FTP).
For the ReportCaster I've tried to use a distribution list, but that don't fulfil the
requirement.
So, I ask for an other solution.

Thank you

Bernd

WebFOCUS Business Intelligence
Edition: WebFOCUS
Product Release: 8.0
Service Pack: 09
Build Version: branch8009
Build/GEN Number: 79
Build/GEN Date: Thu Oct 09 21:34:42 CEST 2014
Application Server: Apache Tomcat/7.0.33

This message has been edited. Last edited by: Tamra,

Posts: 16 | Location: Hamburg | Registered: January 19, 2015

Tamra

Guru

posted

Hide Post

Hello btiedmann,

This is a friendly follow-up regarding your post changing the output filename dynamically with InfoAssist.

While we wait to see if other members will reply please be aware that coding changes to an InfoAssist created report may not allow you to re-open within InfoAssist (depending on what you do). You may receive the message:

'By saving you will not be able to open this report with its original tool'

Can you create an HTML page that would prompt for the name of the file to be supplied and pass it into the report?

For Report Caster: After some searching in Focal Point the following might be of assistance.

Report Caster - Passing Global Variable to Save Report As File Name

[CLOSED] Dyanmic file name in Report caster http://forums.informationbuild...1057331/m/8377008926

I see that you have also opened a case with TechSupport. Please share your resolution with Focal Point so that others will benefit too.

Thank you for participating in Focal Point.

Tamra Colangelo
Focal Point Moderator
Information Builders Inc.

WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5

Posts: 487 | Location: Toronto | Registered: June 23, 2009

btiedemann

Member

posted

Hide Post

Hello Tamra,

thank you for your reply.

I've just found a workaround, to add the current date to the filename of the e-mail-attachement:

Few steps are necessary within InfoAssist and Report Caster.
Within InfoAssist:
I've added a
Detail field (DEFINE) like this Name: Current_Date Format: DMYY
as content: HDATE ( HGETC ( 8 , 'HYYMDm' ) , 'DMYY' )
I've put this field at the first place in the "BY" box and set "visible" to "hide"
(because this field is unnecessary for the report content)

Within Report Caster:
I,ve checked within TASK/Report Proberties/ the checkbox "Burst Report"
That's all. The value of field "Current_Date"
has been added to filename automatically.

Thank you again for help and have a nice day

Bernd

This message has been edited. Last edited by: btiedemann,

WebFOCUS 8.1
Build Version: 8105m
Build/GEN Number: 187 Application Server: Apache Tomcat/7.0.33
Windows, All Outputs

Posts: 16 | Location: Hamburg | Registered: January 19, 2015

Ignored post by btiedemann posted

Show Post

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[CASE-OPENED] changing the output filename dynamically with InfoAssist, ReportCaster

Focal Point | Privacy Statement | Terms of Service