daiwhyte
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.c sv
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
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.c
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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).
At least one of them allows you to use Crystal fields or formulas to name exported file names (and even folders).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for all your suggestions, a combination of all your suggestions has giiven me a way forward.