<p>Hello,</p>
<p> </p>
<p>I'm new in the BIRT World, so I don't have much experience. I hope you can help me with my problem.</p>
<p> </p>
<p>I have created a JDBC DataSource on my Report (I'm using the drag and drop plug in by eclipse) and I have a Database connected with one table. It looks like that:</p>
<p> </p>
<p><strong>user</strong> <strong>function</strong> <strong>description</strong></p>
<p>Julia cooking very fine</p>
<p>Julia washing no good idea</p>
<p>Julia do the dishes ok</p>
<p>Peter cooking fine</p>
<p>Peter washing very fine</p>
<p>Peter do the dishes ok</p>
<p>Laura cooking the worst</p>
<p>Laura washing super</p>
<p>Laura do the dishes no good idea</p>
<p> </p>
<p>Now I want to create a table in BIRT which has to look like that:</p>
<p> </p>
<p><strong>user</strong> <strong>cooking</strong> <strong>washing</strong> <strong>do the dishes</strong></p>
<p><strong>Julia</strong> very fine no good idea ok</p>
<p><strong>Peter </strong> fine very fine ok</p>
<p><strong>Laura</strong> the worst super no good idea</p>
<p> </p>
<p> </p>
<p>So, that the names are on the left and the functions on the top, under which the descriptions are listed.</p>
<p> </p>
<p>I haven't any idea how to do that. When I create a DataSet in BIRT with</p>
<pre class="_prettyXprint">
Select user, function, description
from table;
</pre>
<p>I only get the listing in the first picture. When I drag an drop the DataSet into the white area, I get a table where the three attributes are listed. There are only "DetailRows", but the function should be a "DetailColumn", how can I do that? And how can I then list the descriptions below?</p>
<p> </p>
<p>Do I have to make two DataSets, or a JavaScript Function or something else? I'm perplexed.</p>
<p> </p>
<p>Thank you so much for your help!</p>
