Complex header in Cross Tab

I've tried to create a complex header with column span in report designer, but I couldn't. I've found it possible only in grid and table but not with Cross Tab, but I really need to create something like:

| Header for 2 columns |

| Column 1 | Column 2 |

Find more posts tagged with

Comments

mwilliams

Hi vhusainov,

Do you have a column in your data that will be the "header for 2 columns"? If so, you should be able to set that up as a dimension and set the other columns as sub dimensions I believe. Haven't tested. I'll set something up with the sample database and attach it if it works.

mwilliams

vhusainov,

I'll attach the sample report I made if you'd like, but I can tell you that it does work to use one column as a sub column of another in a dataCube. When creating the cube, you drop the sub column on the main column rather than on the new dimension area. Then, in the crosstab, you drag the main dimension out and click on the drop down next to it in the crosstab and show the group level for the sub column.

Hope this helps.

vhusainov

mwilliams,

I'm doing the following thing: first of all I define Dimension field for my DataCube (it will be my rows in cross tab), after it I define summary field, which contains couple of columns (Column 1, Column 2) from my Data Set. And in cross tab I want to see those two columns (as summary) with their own header ("Header for 2 columns"). That's because after it I want to add another 2 or 3 columns with their own header and so on. So it will be pretty complex cross tab.
As I understand, you suggest to add another dimension for the field which defines rows, but it can't be added as a data field of cross tab. Or may be I'm missing something...

mwilliams

vhusainov,

I may have been unclear on exactly what you were wanting. What I was assuming would have been something like the following:

data:

Company | Rep | Product Line | Sales
Company1 | Rep1 | PL1 | 100
Company1 | Rep1 | PL2 | 50
Company1 | Rep2 | PL1 | 50
Company1 | Rep2 | PL2 | 25
Company2 | Rep1 | PL1 | 25
Company2 | Rep1 | PL2 | 50
Company2 | Rep2 | PL1 | 75
Company2 | Rep2 | PL2 | 100

crosstab:

Company 1 | Company 2
Rep1 | Rep2 | Rep1 | Rep2
PL1 | 100 50 25 75
PL2 | 50 25 50 100

This is the kind of header for 2 columns I was imagining. Let me know if I completely misunderstood.