Alignment of crosstabs one below the other

[kalyan_y]

Hi all,
I have 3 crosstabs placed one below the other.
Report has a prompt on the week range.
When I select the week range to display 24 weeks data(Eg: 1-24, 10-33), crosstab alignment is proper. But when the week range exceeds 24 weeks, crosstabs are not aligned properly.
I have set the same size n overflow for each column in all the crosstabs.

[suhas_bhat]

Hi Kalyan_y,
   try setting the size and overflow for the entire crosstab. It should be the sum of all the cells within the crosstab. Also try horizontal pagination. I've faced formatting problems in HTML o/p but they usually get sorted out in PDF. Hope this works.

[blom0344]

When looking at your report example, why not generate 1 crosstab from unions to begin with?

[kalyan_y]

Thanks for your replies...

I have set the size n overflow for the entire crosstab which is sum of each column size n overflow. Alignment is still improper.. It is not in line for 24 weeks also....

I have attached report xml. I have two queries, one for Current Year and the other for Previous Year. I need to show the product values against the Weeks along with averages and totals.
This, I have done by selecting the Year, and clicking on the aggegation->Total. So, I have got two columns, one average and the other total.

Also I need to show the row with aggregation, This I have done by selecting Product Level 3 and clicking on the aggregation -> Total.  For the column Average, it displaying the total value (11575) instead of the sum of the averages(482.29).
This is the reason for which I have placed another crosstab.