I have a cross-tab that contains 2 groups on the left and one group on the top.

The outer group on the left can contain multiple subgroups, and so it is spanned across multiple rows.

However when I export to excel (data only), the group name shows up at the bottom (beside its last subgroup) rather than at the beginning.

So in crystal it looks like this:

A     B1

     B2

     B3

But when I export with data only, I get this

     B1

     B2

A     B3

Which looks bad. Any way to get that A at the top rather than the bottom?

I want to export with data only because otherwise crystal formatting gets in the way and it doesn't look like a clean data dump.



Edited by Keikoku - 30 Aug 2011 at 9:33am

Hi,

I'm sitting with the same problem. I don't have something that is unique on the report (but it is unique within a group)

Can someone please explain to me what I can do.

Hi,

tx for the response but I'm not looking to repeat the value. I am looking to "print" the field name on the top level cell in excel (when I export as data only)

Here's my Crystal View:





And here's how it shows up in a excel export (data only):




So you can see that the "heading" is located in the last cell of excel and I need it on the first.

Ok I'll look around but don't know if it is possible.