Export to Excel (Data Only)

[Former Member]

Hi,

This is about a bug in Crystal Reports (version 11.0.0.1282, CR Developer; Full; French version).

Symptom:

I loaded an RPT file with CR.

Then I try to export it to a file using: File>Export>Export Report.

If I select PDF, Word or Excel, the result is what expected: with all records at the correct format.

I can see as well the correct report in the preview tab.

But when I select Excel Data Only, the results contain only half of what is expected; I donu2019t get:

u2022 Page Header b

u2022 Details a

u2022 Page Footers a b c

[Click here for screenshot|http://imgur.com/oh05n]

Can you help us about that?

Best regards

Hassan Boutkhourst

Data Environnement

Edited by: hassan.b on Feb 7, 2011 2:35 PM

[Former Member · Accepted solution]

There is a clue in the title

Export to Excel (Data Only)

If you want page headers etc you must export to excel selecting the option

Export to Excel

Ian

[Former Member · Accepted solution]

Hi Ian

Iwant to export only data, but i get only the header, and not the details

Export to Excel work fine, but i don't need the formating,

please check the screenshot

[Former Member · Accepted solution]

In the screen shot most of the report is suppressed (grey hash lines). Any data in those areas will not appear on the report or be exported.

Ian

[Former Member · Accepted solution]

The hash supressed parts are condisioned

[Click here for screenshot|http://i.imgur.com/DXm7g.png]

the thing is when I export to Excel, Word or PDF everything is fine, i got all the details

even the Preview works

only exporting to Excel Data Only that dosn"t work

[former_member11696 · Accepted solution]

Try upgrading to CR Xi R2 for free and test again.

Also, both versions are past their fix cycle.

Install CR XI R2 Service Pack 4 full build and then apply SP 5 and SP 6.

Thank you

Don

[Former Member · Accepted solution]

Thanks i will try this

[Former Member · Accepted solution]

Unfortunatly this dosn't work

I instaled till SP6

now i'm in version 11.5.12.1838

here is my RPT:

[Click here to download|http://dl.free.fr/dWJ8W5bqS/Registre_Sortie.rpt]

[former_member292966 · Accepted solution]

Hi Hassan,

I took a look at your report and I can have it exported when I remove the supress formula in the Detail section.

Why are you using this formula?

To get around this, would moving the subreport to the Report Footer be a better place since it's printing at the end anyways?

Hope this helps,

Brian

Edited by: Brian Dong on Feb 10, 2011 12:39 AM