Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Multiple columns of detail data
Migrateduser
Here is my situation.<br />
<br />
I am working on a report where the SQL data is like this:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
Col1 Col2 Col3 Col4 Costs Stuff
Tool Pencil CategoryA 50.00
Tool Pencil CategoryB 60.00
Tool Crayon CategoryA 20.00
Tool Crayon CategoryB 30.00
Piece Plywood CategoryA 40.00
...</pre>
<br />
The idea is that in BIRT I will group on Col1, but then I need to show the data of CategoryA and CategoryB for each one, but I need to show it horizontally.<br />
<br />
Example:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
Type Name CatA CatB
Tool
Pencil
Costs 50.00 60.00
Stuff 16.00 22.00
...
Crayon 20.00 30.00
Costs 80.00 90.00
Stuff 96.00 20.00
...
Piece
...</pre>
<br />
What would be the best way to do this with BIRT? Ideally with 1 dataset.<br />
<br />
<br />
I looked into crosstabs, it looks like this is the right way, but I'm not sure how.<br />
<br />
Thanks
Find more posts tagged with
Comments
There are no comments yet