Multilevel grouping

[gex]

Hi all!

Grouping by Vendor column and by Price column is common.

How add grouping by device column.

Example table below:

 

 

Code:

+-------+--------+-------+|Device | Vendor | Price |+-------+--------+-------+|       | nVidia |  30   || Video | Radeon |  20   ||       |  ATI   |  10   |+-------+--------+-------+|       | ESS    |  30   || Audio |Cristal |  20   ||       |Creative|  10   |+-------+--------+-------+|  CPU  | Intel  |  20   |+-------+--------+-------+|       | LG     |  30   ||       | VS     |  20   ||Monitor| Sams   |  10   ||       | Sony   |  20   ||       | DD     |  30   |+-------+--------+-------+

Post Edited by Constantine Ponomarev at 11/15/08 12:24

[gex]

Anyone? 

[mikij]

 What do you ask actually ? You just have to select device, vendor, sum (price) and to group by device, vendor. 

[gex]

I know how make that.... 

Code:

+----------------+|      Video     |+--------+-------+| nVidia |  30   || Radeon |  20   ||  ATI   |  10   |+--------+-------+|     Audio      |+--------+-------+| ESS    |  30   ||Cristal |  20   ||Creative|  10   |+--------+-------+|      CPU       |+--------+-------+| Intel  |  20   |+--------+-------+|     Monitor    |+--------+-------+| LG     |  30   || VS     |  20   || Sams   |  10   || Sony   |  20   || DD     |  30   |+--------+-------+

[gex]

I need make group header in left column

Code:

+----------------+|      Video     |+--------+-------+| nVidia |  30   || Radeon |  20   ||  ATI   |  10   |+--------+-------+         |         V+-------+--------+-------+|       | nVidia |  30   || Video | Radeon |  20   ||       |  ATI   |  10   |+-------+--------+-------+        

[jyotic]

You could also try crosstab with 2 row level group.

--Jyoti

[balap6]

You also do that in ordinary jrxml ( without Crosstab) , just disable the print repeated values in text box ( column: device),  and add grouping and sorting for device.

i hope it will helpful for you..

 

Thanks,

Balaji :)