Crosstab Header on every row

Hi.

Is it possible to show the crosstab group headers on every row? The default behaviour is to show a group header on only the first row of a grouping. I've tried changing suppressDuplicates and repeatRowHeaders, but no luck so far.

Does anyone know how to do this?

Best regards

EB

Find more posts tagged with

Comments

mwilliams

Hi EB,

If you put a grid in the inner-most row header and move all of your headers into the grid in their appropriate spots, you'll see the headers for every row. For the other cells, you'll just have to set the advanced -> section -> display property in the property editor to "no display" and then hide the cell lines by making the border the background color.

Hope this helps.

ebirkenes

Hi Michael.

Thank you for your reply.

Yes, I've tried that approach and it was the best solution I could find, but it's not a very good one.

It means that you loose alignment of the headers across the report and even across the group itself. It looks like a mess unless you know how long every header is and can set fixed column widths?in the grid.

I think it should be possible to repeat headers on every row/column if you want to, not just for page breaks.

In this case I need group things in the report, but I also need to be able to export to Excel with all the row information intact. The way this is working many rows will miss important group information in Excel. And if I use the 'grid in the last header'-method, it will really mess up the Excel export..

mwilliams

ebirkenes,

If you'd like, log an enhancement request at http://www.birt-exchange.org/org/resources/bug-reporting/. If you post the enhancement information in here, those searching for a solution to this same issue will be able to click on your request and vote for it. I have another idea, but it'd be a bit of a hack. It involves creating a computed column to make the same values different, then fixing the changes you made in script in the crosstab. This would make them not group together, so they'd have their own lines where the corrected value will then be repeated for each row. Let me know if you have questions.