Break Crosstab columns

[Former Member]

Hi All

I am looking for a way to break a crosstab columns and let it grow vertically rather than horizontally.

For an example:

1. Create a crosstab with a field "Country" in the Columns section, a field "Year" in Rows section and a field "Shop_Name" in Summerized fields section.

2. Suppress the subtotals and the grand totals.

3. This will create a cross tab as below:

USA Canada Germany

2001 2 7 6

2002 3 8 6

2003 4 9 6

2004 5 10 6

2005 6 11 6

4. We are in need to break this cross tab in order to show it as below, if it crosses N-number of columns(In this case N=1):

USA

2001 2

2002 3

2003 4

2004 5

2005 6

Canada

2001 7

2002 8

2003 9

2004 10

2005 11

Germany

2001 6

2002 6

2003 6

2004 6

2005 6

I know of a way to break the cross tab in horizontally and looking for a way to break it vertically (after N-number of columns).

Thank you for the help in advance.

Regards

Nikhil Sabnis

[former_member292966 · Accepted solution]

Hi Nikhil,

If you insert a Group on Country and put your crosstab in the Group Header or Footer, this will give you your break. For the report to list horizontally, right-click the crosstab and go to the Cross-tab Expert. In the Customize Style tab, set the Summarized Fields to Horizontal. You can turn off the totals here as well.

Good luck,

Brian

[Former Member · Accepted solution]

Hi Brian

Thank you for the insight.

If I create a group on Country and place my crosstab in the group then I will get the data related to the respective group.

Your suggestion gets me a crosstab for each country, showing only one column for the respective country.

My requirement was to show the crosstab for N-number of coulmns and wrap it if it goes beyond a page Horizontally (Simply do not allow the crosstab to span horizontal pages).

I have this cross tab in a subreport. So the part of cross tab (spanning horizontal pages) which is shown in the 2nd page of the subreport, will not be visible in the main report since it is spanning pages horizontally.

We implemented a solution as below:

Get another field from the database which gives me a running count of countries which resets after N-number of countries (Let's say 6). If I insert a group on this field in the subreport and place the crosstab in this group then I will get N-number of coulmns in a particular group (6 as said before). If the value of the group changes (which indeed means that I have shown 6 columns in the crosstab), the crosstab will show next columns in the subsequent group and so on.

Now I am getting a cross tab in the subreport which grows vertically!!

Regards

Nikhil Sabnis