How can I have column of data and a crosstab export to same rows in xlsx format?

[former_member560462]

CRVS2010, SP7.  I have report that contains a single column of data and to its right, a crosstab.  I know at report design time how may rows the cross tab will produce, the number of columns is variable.  Sort of like this:

My Column	CrossTab Col 1	CrossTab Col 2	CrossTab Col n
My Row 1	CrossTab Row1 Col1	CrossTab Row1 Col2	CrossTab Row1 Col n
My Row 2	CrossTab Row2 Col1	CrossTab Row2 Col2	CrossTab Row2 Col n

When I export to PDF, it looks as it does above.

When I export to xlxs, I get the cross tab, then below it I get my column.  I want all the rows (my row 1, crosstab row 1) in the same Excel row.  Is this possible and if so, how do I accomplish it?

If I set MaintainRelativeObjectPosition = true in my export options, My column actually appears as a column, but below the cross tab data.

If I set MaintainRelativeObjectPosition= false in my export options, My column ends up in a single excel row, again below the cross tab data.

Neither of these is what I have in mind.

I have experimented with spacing of My Column and the crosstab, butting them up next to each other (although this is difficult to determine with the crosstab) as well as spacing them apart.  I believe I have the heights of all the rows the same.

-nld

[DellSC · Accepted solution]

Unfortunately, this is probably not something you're going to be able to do.  There is not much you can do to control the Excel output of a report which is based on the objects in the report - the crosstab is considered to be a single object and each of the rows in your additional column are separate objects.

Have you tried using the Excel (data only) export to see whether that is any better?  You'll lose any formatting (font, colors, etc.), but it may work better (no guarantees....).

-Dell

[former_member560462]

Thanks for both of the responses.  I am generating the data-only format (that's the xlsx).  FWIW if I generate to Excel (xls) it is both better and worse.  I get my column and the cross-tab side by side, but my rows to not always match up with the crosstab rows.  Blank rows appear sporadically.

[former_member183750]

Only thing I have to ad to Dell's answer is a pointer to this document:

How to WYSIWYG SAP Crystal Reports Export to XLS

I am not sure that the doc will help, but at least it will explain how CR works as far as exports to XLS are concerned.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter