Avatar of daiwhyte
daiwhyte
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Saving Report with date in the filename

Hi,

Ive designed a report which runs each day via our Business Objects server. Ive been asked to name the file with the previous days daye in the title so it would ready like this

CustomerExtract_yyyymmdd.csv

Is there a way in Business Objects to do this?

Ive noticed in the box where i type the what I want the file name to be is adds %ext% at the end which deals with the extension of the file. Would it be possible to add the date using something like %dateyyyymmdd% or something like that, is this type of thing supported?

D
Crystal Reports

Avatar of undefined
Last Comment
daiwhyte

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Will

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
David11Norman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
David11Norman

You could also look at event-level scripting in windows. Schedule the file to a location and write an event based script that renames it as you want, saves it elsewhere, then deletes the original file.
Ido Millet

You can see a list of 3rd-party Crystal desktop schedulers at http://kenhamady.com/bookmarks.html
At least one of them allows you to use Crystal fields or formulas to name exported file names (and even folders).
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Mike McCracken

vasto -
Did you put the comment in the wrong question?
the OP is trying to name his output file from BOE to include the date of the run.

Since I don't think BOE supports that he has to either get a different scheduling tool that does that or come up with another method.  

He never even mentions ad hoc queries.  

mlmcc
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
daiwhyte

ASKER
Thank you for all your suggestions, a combination of all your suggestions has giiven me a way forward.