Bug 202330 - [Crosstab improvements] Ability to put headers for dimensions on crosstabs
Summary: [Crosstab improvements] Ability to put headers for dimensions on crosstabs
Status: REOPENED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.2.0   Edit
Hardware: PC Windows XP
: P3 enhancement with 6 votes (vote)
Target Milestone: Future   Edit
Assignee: Zhiqiang Qian CLA
QA Contact: Tianli Zhang CLA
URL:
Whiteboard:
Keywords: plan
Depends on:
Blocks:
 
Reported: 2007-09-05 16:51 EDT by erlich CLA
Modified: 2013-05-01 04:44 EDT (History)
9 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description erlich CLA 2007-09-05 16:51:45 EDT
It would be good to have the ability to put headers in the upper left corner of the cross tab...

so if i can have something like

          
Name Ticket  Product 1  Product 2             
John
     1
     2
     3
Jack
     1
     3
     5

Please tell me if i'm not very clear..


Thanks
Comment 1 Zhiqiang Qian CLA 2007-12-09 23:43:00 EST
Fixed. You can put any report item in Crosstab corner header now.
Comment 2 Rafal CLA 2007-12-12 04:58:29 EST
(In reply to comment #1)
> Fixed. You can put any report item in Crosstab corner header now.
> 

I just had the same problem in my report and I'm not sure if your fix will be satisfying. What about crosstabs which have more than one row dimension? 


Name  Surname    ID   | Ticket  Product 1  Product 2             
John  Johnson    1    |
                      |   1
                      |   2
                      |   3
Jack  Black      2    |
                      |   1
                      |   3
                      |   5


When report will have auto-layout option enabled won't there be any offset between header fields and values field below? I think it would be more efficient if those headers were actual column headers, exactly like this header field above details section of a crosstab (which can't be removed from report by the way :(
Comment 3 Michal Tkacz CLA 2008-04-04 17:57:30 EDT
I have the same doubts as those expressed in comment #2. The ability to put anything in the corner header is great but doesn't properly address this enhancement request. Here's an even more complex example than this presented in comment #2:

+-------------------+-------+-----------+-----------+
|     products      | name  | product A | product B |
|         x         +-------+-----------+-----------+
|      orders       | price |   12.34   |   56.78   |
+--------+----------+-------+-----------+-----------+
| number | date     |
+--------+----------+       +-----------+-----------+
|  123   | 01/01/08 |       |   3 pcs   |           |
+--------+----------+       +-----------+-----------+
|  456   | 04/04/08 |       |   2 pcs   |   5 pcs   |
+--------+----------+       +-----------+-----------+
Comment 4 erlich CLA 2008-08-20 16:15:59 EDT
As it's said the fix doesn't solve the issue.. we need at least the ability to have a header per column on the row side
Comment 5 Zhiqiang Qian CLA 2008-08-20 21:21:03 EDT
(In reply to comment #4)
> As it's said the fix doesn't solve the issue.. we need at least the ability to
> have a header per column on the row side
> 
As the header cell can contain any report item, you can use a grid in this case.
Comment 6 Michal Tkacz CLA 2008-08-21 04:26:37 EDT
(In reply to comment #5)
> As the header cell can contain any report item, you can use a grid in this case.

But can you align the columns/rows of that grid with the columns/rows of dimensions reliably without hardcoding the widths/heights for both?
Comment 7 Rima Kanguri CLA 2009-05-29 17:51:04 EDT
(In reply to comment #6)
> (In reply to comment #5)
> > As the header cell can contain any report item, you can use a grid in this case.
> 
> But can you align the columns/rows of that grid with the columns/rows of
> dimensions reliably without hardcoding the widths/heights for both?
> 

No, you have to align the columns of grid and the cross tab cells by hard coding the width/height. This is our agreed solution for this use case.
Comment 8 Thomas Thym CLA 2011-06-15 04:26:24 EDT
It would be really useful to have that "column names grid" for the dimensions auto-filed like the names of the measurement section.
That would save me a lot of time. Please think about it.
Comment 9 ebirkenes CLA 2011-10-06 06:20:27 EDT
(In reply to comment #7)
> No, you have to align the columns of grid and the cross tab cells by hard
> coding the width/height. This is our agreed solution for this use case.

This is really not a solution at all. The whole point of a crosstab is that it is dynamic and this kind of ruins that. You can do it on the column dimensions if you disable line breaking, because you know how many rows there are, but there is often no way to know the with of the columns in advance. You have to guess and then you will get issues with text breaking or cut off and what not. Horizontal dimensions really need headers that automatically align to the column. 

And this is not a special "use case" like you make it sound. I have NEVER created a report where I didn't need to have headers for the dimensions. Why would someone think that the dimensions are self-explanatory? Only for the most trivial examples is this the case. In most cases it is just a number, a name or even a code, but there is no way to know what it means. This really should be built-in functionality.

The BIRT crosstab functionality is awesome, but this simple detail really ruins it.
Comment 10 Thomas Thym CLA 2013-05-01 04:44:58 EDT
I seems that this bug/feature request is solved in 4.2.2.

A very big THANK YOU to the person who fixed that. YOU ROCK!