Crystal reports Export File Name

[former_member202170]

Hi All,

when I Export the Crystal report in to Excel as Data

it is exporting the file name as encrypted file

~crw1612_4172_{DA57F8B3-A8B6-4F97-ADE3-FE84A00D92B2}

How to Export the Crystal reports with File Name

Please Advise

Thanks

Krishna.

[DellSC · Accepted solution]

We need a little bit more information:

1.  What version of Crystal - go to Help>>About and get the exact number.

2.  Based on the structure of the file name, I'm going to assume that you are running it through either Crystal Reports Server or BusinessObjects.  If that's the case, which version are you using?

-Dell

[former_member202170 · Accepted solution]

We are using Business Objects Server

we currently seeking crystal reports 2013

SAP BO4.1 we are using

[DellSC · Accepted solution]

When you schedule the report, there are a couple of options at the bottom of the screen for setting the file name. I suspect that you have selected "Use Automatically Generated Name", which gives you the file name format that you're seeing.  Change this to "Use Specific Name".  I then usually use the place holders to set the name, something like this:

Title-DateTime and I make sure that "Add File Extension" is checked.

This will look like %SI_NAME%-%SI_STARTTIME% in the text box for the file name.

-Dell

[former_member202170 · Accepted solution]

Dell it Worked Out Thank you Very Much

Thank You

Krishna.

[former_member202170 · Accepted solution]

Dell is there any way that we can keep Only Date Place holder instead of Date Time Place holder

Please Advise

Thanks

Krishna.

[DellSC · Accepted solution]

Unfortunately, no.  However, there is an idea on IdeaPlace around this issue that you can vote up to try to get this:

Ability to add userdefined placeholders when scheduling reports in Crystal Reports Server Destinatio...

-Dell

[former_member191664 · Accepted solution]

You can use %SI_STARTDATE% to display date only.  Note that it will work in publication; but it is not listed in the default place holders in BI 4.x.

Regards,

Jin-Chong

[former_member202170 · Accepted solution]

when I used in Place holder it is Showing Like File name %SI_STARTDATE%

instead of Today's Date

Please Advise

Thanks

Krishna.