Jump to content
We've recently updated our Privacy Statement, available here ×

Multiple crosstabs overlap when adjacent to each other


kiranpvsr

Recommended Posts

I want to create a monthly summary report using crosstab for three categories. 


For example, say I want to view the Total Items Purchased in an year grouped by month. Total Items sold in an year grouped by month. Total Profit or Loss in the year grouped by month.


I've tried to use three crosstabs but they overlap with one another. Is there a workaround or can the crosstab's position be set such that it starts where the previous one ends ?


I've attached the screenshot that shows the overlap.


There is a table at the extreme left. Next to it are the two crosstabs. As can be seen from the first crosstab, the last two months are overridden..


Link to comment
Share on other sites

  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Don't both of them have got to do with the element's height. I know stretch type will elongate the field vertically if the textfield does not fit in the width specified. But as I have shown in the screenshot, there is no scope for them to be stretched vertically. I have attached the jrxml to the original post for your reference. I have already tried to implement your suggestion but it didnt work.
Link to comment
Share on other sites

  • 1 year later...

I hope you already found a solution for this. However I am posting my answer to help other future readers.

When I add multiples crosstabs in a report their data are overlapping in the report output file and I fixed it by adding each crosstab in a separated detail band.

 

<detail>

<band height="100" splitType="Stretch">

<crosstab>

<!-- Your first crosstab goes here -->

</crosstab>

</band>

<band height="100" splitType="Stretch">

<crosstab>

<!-- Next crosstab goes here -->

</crosstab>

</band>

</detail>

Link to comment
Share on other sites

  • 5 years later...
  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...