Bugzilla – Full Text Bug Listing
| Summary: | Support for dynamic table's columns | ||
|---|---|---|---|
| Product: | z_Archived | Reporter: | Manuel Siggen <msi> |
| Component: | BIRT | Assignee: | Birt-Data-inbox <Birt-Data-inbox> |
| Status: | RESOLVED DUPLICATE | QA Contact: | |
| Severity: | enhancement | ||
| Priority: | P3 | CC: | msi |
| Version: | 2.0.0 | ||
| Target Milestone: | Future | ||
| Hardware: | PC | ||
| OS: | Linux | ||
| Whiteboard: | |||
First of all, I'm using Birt for a few days and I'm very impressed by the overall quality of it. Very nice work ! So, I'm trying to migrate existing custom-made excel reports that display financial data according to two dimensions : ¦ 0 ¦ 1 ¦ 2 ¦ 3 ¦ 4 ¦ ... ----+-----+-----+-----+-----+-----+----- A ¦ ... ¦ ... ¦ ----+-----+-- B ¦ ... ¦ ----+--- (you get the idea) ... ¦ The problem is that *both* columns (0, 1, 2, 3, ...) and rows (A, B, ...) dimensions are resulting from a SQL query. Basically, I would like to be able to setup a 'table' with the following pseudo-properties : o rows = select name from table; o columns = select distinct slot from table; o cell(x,y) = select value from table where name = x and slot = y; where 'table' is something like : id ¦ name ¦ slot ¦ value ¦ ----+------+------+-------+ 0 ¦ A ¦ 0 ¦ ... ¦ ----+------+------+-------+ 1 ¦ A ¦ 1 ¦ ... ¦ ----+------+------+-------+ 2 ¦ A ¦ 2 ¦ ... ¦ ----+------+------+-------+ 3 ¦ A ¦ 3 ¦ ... ¦ ----+------+------+-------+ 4 ¦ B ¦ 0 ¦ ... ¦ ----+------+------+-------+ 5 ¦ B ¦ 0 ¦ ... ¦ ----+------+------+-------+ .... I tried to find reference to such a problem in bugs and in newsgroup, but I couldn't find anyone. Would it be possible to add such dynamic table's columns feature ? Thanks !