Crystal Cross tab excel export 1

[Johnny786]

Hi,
I have created a crosstab report which need to be exported into excel.
My crosstab results are :
T1 T2 T3
1-apr-2012 2-apr-2012 3-apr-2012
A1 B1 C1 10 10 10
C2 10 10 10
Total 20 20 20
A2 B2 C3 10 10 10
C4 10 10 10
Total 20 20 20
When i am trying to do the excel export, its coming like :
T1 T2 T3
1-apr-2012 2-apr-2012 3-apr-2012
C1 10 10 10
C2 10 10 10
A1 B1 Total 20 20 20
C3 10 10 10
C4 10 10 10
A2 B2 Total 20 20 20

I've already seen so many discussions about this in this forum and i came to know its hard to get exactly the same.
But i only want to know whether its possible to get the A1, B1 or A2,B2 right on the same line as C1 or C3 any chance.
Any suggestions please? Any help will be appreciated.
Thanks a lot.

 

[Madawc]

Which Crystal? On Crystal 8.5 and 10, it was a problem and I found the best answer was blank text to make the columns consistent.

From 11.5 (I think), you have the option to export as data or with the same look, and both seem to work.

It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 2008 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[hilfy]

If you are using an actual Cross-Tab component, it should export cleanly to Excel. Although it looks like your format is somewhat different than what's showing in your cross-tab. Unfortunately, there is no way to control this from Crystal. So what you're seeing is the way it is going to be.

Madawc's suggestion for blank text applies if you're not using a Cross-Tab component, and it also applies from 11.5 on (in addition to the earlier versions) if you are doing a data-only export.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[NickieP]

I have XI and if you export as Excel not Excel(Data Only), it does show the group name properly(at the top). I do this, then highlight all, unmerge all cells and then clean it up a bit.
Not smooth, but it works, and you could write a macro for the tidying up if it is a regular export.

 

[Johnny786]

Hi Madawc,
i am using the crystal 2008(version 12). I have tried both excel export data and data only options, but still its not exporting as it is in crosstab. When i use excel export data option, in excel its showing like merged cells. and the latter one messing up the whole format options. Any suggestions?

 

[Madawc]

Have you also tried blank text boxes?

If that's not it, then I have no more ideas.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[Johnny786]

Madawc,
Can you explain how to do that(blank test boxes) in clear,please?
Thanks for your time.

 

[Madawc]

At the top you should see an [Aa] icon, choose that. Place it, make it the right size but enter nothing.

Or you can use [Ctrl]C and [Ctrl]V to copy an exisitng field and then clear it of text.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[IdoMillet]

One of the 3rd-party Crystal Reports schedulers listed at

http://kenhamady.com/bookmarks.html

can automate the process of generating an Excel pivot table from a Crystal report. Besides avoiding the formatting issue of your CrossTab export, it allows the user to slice & dice the data.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[epmo]

I am a big fan of R-Tag Viewer, which can create a pivot table from a query. May be @IdoMillet is talking about this tool.
Export to excel is clean and with formatting which makes the data easy to read. They have a video demoing the same crosstabed data in crystal , SSRS and pivot table, which shows the advantages of each report type, although for simple crosstab reports it is a no brainer :

http://www.r-tag.com/Pages/Preview_Demo.aspx