BusinessObjects Board

Is there any way to add Scheduled date in report name

scheduling XI Scheduler
#1

Hi Experts,

I have a requirment that the schedule instance when it save as a excel or pdf the schedule date will be added at the end of the report name.

Now Excel and PDF saved as

Daily MIS Report

I want to save the instance like

Daily MIS Report_YYYMMDD

this YYYYMMDD is the schedule date

Any help is greatly appreciated.

Regards,
resarav

resarav (BOB member since 2008-07-23)

#2

Have you tried using Add placeholder… when you select destination? It has an option for DateTime.

Rachid

rachidb :morocco: (BOB member since 2006-07-06)

#3

yes… while scheduling you can define the target name as specific name.
and from “Add placeholder” drop down list we can select various place holders.
In this case , combination of Title and DateTime as %SI_NAME% and %SI_STARTTIME%

Vills :india: (BOB member since 2007-10-24)

#4

%SI_STARTTIME% gives the entire date & time

Is there a way to truncate the “time” part out?

Otherwise I read we can use the SDK to schedule the report which allows me to customise the filename. Where can I find some beginners tutorial to do this?

Thanks

munlee :australia: (BOB member since 2007-02-28)

#5

yes, you are right . %SI_STARTTIME% gives the entire date & time.

Also we can use the SDK to schedule the report which allows us to customize the file name.
However I am also in search of some beginners tutorial to do this :mrgreen: . If anybody having, please share; this would be great help.

Vills :india: (BOB member since 2007-10-24)

#6

you can use RefreshDate() in your reports.

Rakesh_K :india: (BOB member since 2007-12-11)

#7

It seem confusion here. :mrgreen:
We are finding solution to adding DATE in report title itself (in targeted report while scheduling); not in report. :mrsbob:

Vills :india: (BOB member since 2007-10-24)

#8

Anyone found a way (without using the SDK) to truncate the time out of the exported filename (when using the %SI_STARTTIME%)??

Captspeed :us: (BOB member since 2006-10-03)

#9

Instead of using the placeholders, maybe a macro in the After_Refresh() which does the trick for you?

Thanks,
Kon

konquistador :us: (BOB member since 2006-01-04)

#10

That would indeed work quite well in a Deski report, but this is a Webi Report. Webi Reports cannot use Macros, nor can they utilize VBA code/logic (which is yet another example of why to use Deski over Webi, and the current shortcomings of Webi).

Captspeed :us: (BOB member since 2006-10-03)

#11

https://bobj-board.org/t/137801

This post claims that %SI_STARTDATE% works.

weaver (BOB member since 2008-10-17)

#12

Tried using %SI_STARTDATE%.xls as a destination Filename (using BO XI 3.1, Windows).
It doesn’t work, the exported file name was “%SI_STARTDATE%.xls”.
When trying the same thing using %SI_STARTTIME%.xls, the exported filename was “01/09/2010 2:50:31 pm.xls”.

I believe BO must have removed that reserved keyword (%SI_Startdate%) from its dictionary in BOXI 3.1.

Captspeed :us: (BOB member since 2006-10-03)

#13

Publication/Schdule/History/Destinations

Enable “Specific Name per document”

and give the Specific name of your wish as below.

Report_name%SI_STARTDATE%.%EXT%

See the attachment for more the print screen and it worked for me
13.jpg

siddu0206 (BOB member since 2010-01-25)