Problem exporting report into Excel 2007 from InfoView as Excel 97-2003

[Former Member]

Hi,

I am trying to export a report from InfoView into Excel 2007. When I do this I export it as 97-2003 Data Only as there is no option for 2007. However, when I open it using Excel 2007 it states that "the file is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file".

Has anyone come across this before?

[Former Member · Accepted solution]

What is the file extention?

Any problems when you open it?

Debi

[Former Member · Accepted solution]

Hi Debi,

The file extension is xls. Whe I open the spreadsheet it is full of rubbish.

Thanks

Aled

[Former Member · Accepted solution]

What version of Crystal Reports are you using? Any service packs or hot fixes installed?

Can you open other xls files with 2007?

Have you ever exported to excel before?

I export to -excel (97-2003) data only- and open the files with Excel 2007 with no problems. Excel 2007 complains about the old format (xls) and wants to convert it to the new excel format. I alsways ignor it.

Maybe the 'garbage' you are seeing is because the layout of your crystal report is not working for the export. Is all the data there but you have extra cells and/or lines, or the data is pushed to the left? I find that I must have the fields packed tightly with no space between them and no space above or below the fields, or I get extra cells between and lines above or below them.

Most of my exports are detail lines with a single line header and columns are set to match the detail line. When exporting multiple lines where the fields do not line up exactly with the ones above them, I may use one or more empty text fields that matches the size of the fields above them to fill the empty space. Sort of like:

line 1:{field1.}{field2...}{field 3}

line 2:(text...}{text.....}{field 4)

And you may need to turn off 'can grow' on all fields as they may cause miss-alignment. All the data will be there when you export it, even what you can not see in Crystal. You will just need to format the cells in Excel to see it.

Debi (hi Don)

[Former Member · Accepted solution]

Hi Debi,

We are using Crystal 2008 Version 12.2.0.290

I have not been prompted to install any hot fixes or service packs. Where would I get these from?

I can open other xls spreadsheets using 2007.

I could export spreadsheets in 97-2003 before but I can't now.

Thanks

Aled

[former_member11696 · Accepted solution]

Hi Aled,

Couple of ways to update, uninstall and install the full build:

https://smpdl.sap-ag.de/~sapidp/012002523100009989492010E/cr2008_sp3_fullbuild.zip

Or download SP 3 incremental:

https://smpdl.sap-ag.de/~sapidp/012002523100007123572010E/cr2008_sp3.exe

You'll find the patches by clicking on the Business Analytics tab above and then on the left click on SAP Crystal Solutions Support then Downloads.

If others work then it's likely something in this report causing the problem. You can try to debug it by removing subreports, then whole sections until it starts working again and then start again from the original and add in the part causing the issue.

Thanks again

Don ( hi Debi )

[Former Member · Accepted solution]

>

> Hi Debi,
> I could export spreadsheets in 97-2003 before but I can't now.
> 
> Thanks
> Aled

I am curious. What changed?

Debi

[former_member11696]

Couple of possible issues.

First, the only version of CR and BOE that supports Excel 2007 and above format is CR for VS 2010 and BOE 4.0. So your only option is 97-2003.

Second, the message suggests either the application or InfoView ( scheduling etc. ) has either exported the report into some other format but changed the file extension to xls so Excel can't open it because it's not the correct file type. Or it's simply a security warning.

What happens if you ignore the message and open the file?

Thank you

Don

[Former Member]

Hi Don,

When I ignore the message and open the spreadsheet ti contains rubbish.

What I can't understand is that Excel 2007 should be able to open files saved as 97-2003 as it is backward compatible. Is there something on the server that might be causing this or is there a download that would be able to sort this out? I am not sure if it makes a difference but there is no Office on the server.

Thanks

Aled