Is there a way (in the actual Crystal Report) to dynamically set the filename when it runs? I have several extract files that I’ve developed in Crystal Reports, and will schedule through BOE. There seems to be no real flexibility in BOE Webi with setting/changing the filename. I need to be able to append the begin date and the end date to the file, each month that it is generated, i.e.
ENC_12345_06012012_06302012
Unfortunately, there is no way to do this as part of the schedule for either Crystal or Webi reports in BOE. You can append the run date to the file name, but not any other dynamic date information.
One solution would be to have the extracts run to an intermediate folder and then have some process (that could be scheduled using either the Windows Schedule or BOE) that would change the name of the file to the format that you need and move it to the appropriate folder.
Thanks for this info. After further digging, I found a recommendation for a dll called u2lwin32 that contains several functions.
One function provides a way to bypass the limitations of the u2fText.dll that varies depending on the version of Crystal Reports you use, when exporting a text file. The function is called FileAppendLine, which uses a filepath and string parameter. By creating a formula for my file name, I can pass it to the function, and solve two issues at one time.
The recommendation came from Ken Hamady’s website, and best of all, it’s free. I have it installed and its working great.