Excel export issue 1

[northw]

Hi All,

I have a cross tab report, which runs for a month data, day 1 to day 30 which is fed by a oracle(10g) stored proc. when I export it as Excel it works, but there are lot of empty spaces and merged columns, but when I try to export it to Excel data only it just throws me an error, cannot export to excel.

we have crystal reports server 2008, Oracle 10g(ODBC) and Microsoft office 2010, and export format Excel export Data only 1999-2003.
Please suggest.

Thanks in advance!

 

[northw]

Add to it:
Crystal FP 5.3, SP 5.

 

[Charliy]

When you export to Excel try fixed column width of 100, I've found thru a lot of trial and error that combination works pretty well.

 

[northw]

Thanks alot Charliy, It worked like a charm. perfect export.

And how can I suppress the row headers in the excel export where they are showing for the second time for page break in crystal reports.

Thanks again!

 

[Charliy]

There is an export option for the headers that defaults to Once per Report, check to be sure it wasn't changed to Once per Page

 

[northw]

Charliy,
I have tried that, even if I select none to export, still I can see the headers in the excel.

Thanks!

 

[MCuthill]

northw:

Couple ideas:
1) Try moving your headings to "Report Header" and see how that works (if able).
2) Suppress headings unconditionally, and key them into your extra after. In subsequent runs, you could copy the headings from a template file. Not ideal, but I had one report a few years back where for whatever reason, this ended up being my only solution. I *think* it was due to subreports in that case, but I couldn't say for certain at this time - though I seem to remember that I was unable to suppress subrpt headers...

I know nothing earth shatteringly helpful, but hopefully helps a bit.

Cheers!


Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[northw]

Thanks for the reply MCutHill!

Couple ideas:
1) Try moving your headings to "Report Header" and see how that works (if able). As this is a Crosstab not sure If I can do that?
2) Suppress headings unconditionally, and key them into your extra after. In subsequent runs, you could copy the headings from a template file. Not ideal, but I had one report a few years back where for whatever reason, this ended up being my only solution. I *think* it was due to subreports in that case, but I couldn't say for certain at this time - though I seem to remember that I was unable to suppress subrpt headers. I don't have a subreport here, and the headers are dates eh: APR 01, based on the report parameter.

Thanks!

 

[MCuthill]

Oooo. Crosstab... yes, that does change things. I will have to ponder on that a bit and see what I can come up with.

Is your Row Heading "structure" something that could be resorted or required to be in a certain order? Again, a bit mundane, but sort the results to get "all" the Headers together, delete all but 1 row of headers, Cut-Paste to top of report and (re)sort Rows 2 through "x".

I'll see if there is a cleaner approach though, as that is a bit tedious for my liking.

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[northw]

I will try that.
Thanks Mike!