How to add Crosstab Group info without loosing performance

[EarthDog]

The following report shows info per Company,Customer and Item.

I want to repeat the customer name and customer code next  to item info.

When i add the 2 fields in the crosstab my performance takes a big hit and slows the report very much.

I tried unlocking item cell and putting there the additional fileds and that was ok from performance point of view, BUT i couldn't export the info in different EXCEL columns.

Any proposals?

[bdbits]

I am going to venture a guess this has to do with the relationships among the nested row items. In my experience, particularly for dimensional data, crosstabs seem to work best when the nested items go from least to more specific (fewer rows included) as you move to the right. I do not know a way to fix it, only that I have seen it, too.

[Lynn]

What type of data source do you have? Relational? Dimensional OLAP or DMR?

In the true dimensional realm, nesting things from different hierarchies is going to put every member from one hierarchy next to every member of the other hierarchy. Then there is filtering or suppressing typically needed to remove the intersections that have not metrics. This is hugely inefficient when you are dealing with very large hierarchies. Even with relational sources there is a little cube-type creation going on behind the scenes.

You didn't show the column side of your crosstab, but if you have a relational source it is possible to use a list rather than a crosstab and derive the necessary query items to simulate your columns as a cross tab would do it. I can't really say if this is a good option in your case because you didn't mention the type of source you have and you didn't show the entire layout.

[EarthDog]

Thanks guys for your replies.

If you take a look at the jpg file that i have attached in the first post.

See the blue arrows. I want to repeat 2 attributes of the group to each crosstab line.

The groupis Customer Name - Customer Number

For every customer i have the item.

What i need is to repeat for every item some customer attributes. And i want to do this in such way that i can export to excel without needing to split into columns.

So i just added the customer attributes where the blue arrows show.

BUT i get a degrade in performance.

I cant rewrite the whole report , i have to work on this.

[Lynn]

You repeated the main ideas in your original post without answering or addressing anything raised in the two previous responses you got. You didn't really add much new information except that you don't want to rework very much and that it needs to export to excel in a particular way.

Can you the questions I raised in my earlier response? Can you explain how your data is structured to see if bdbits suppositions are at the root of your problem? Can you do an alternate layout for excel output?