List of matching string options as text in Cross Tab cells

amozharovskyi · 2015-05-27T15:52:12+00:00

Hi, I need to get cross tab like on Picture1

amozharovskyi

Hi,
I need to get cross tab like on Picture1

Find more posts tagged with

Comments

mwilliams

You could try something like this instead:
 
<a data-ipb='nomediaparse' href='http://blogs.actuate.com/creating-a-birt-report-as-a-calendar-view/'>http://blogs.actuate.com/creating-a-birt-report-as-a-calendar-view/</a>
 
For your crosstab, you could likely use the onFetch of your data set to store values in global variables named after the fields used for your crosstab groupings. Then, in your crosstab, you'd just delete the standard measure element and use a data element or dynamic text box to recall the global variable based on the crosstab dimensions.

amozharovskyi

Hi Michael,
 
thank you for reply,
but i still don't understand how to use "data element or dynamic text box" instead of standard measure in the crosstab. 
I can't put any BIRT element from palette into crosstab cell, it is just possible to use DATA Cube dimensions and measures there. 
 
Please, correct me if it is wrong. 
 
It is clear how to put needed data to global variables, But how to display prepared data in a table with 2 DIMENSIONS (in this case "date" and "employee name")?
 
Thank you so much for help,
Andrii

mwilliams

You would have to use the measure from your cube to builds the crosstab, then delete the data element from the layout and add your own element back in. If you don't add the initial measure, you're right, it won't allow you to add the palette item.

amozharovskyi

Thank you so much, Michael! It worked, but a little bit slow.

santy

Hi Michael,
 
could you please give an in detail tutorial how to achieve this?
 
I have the same problem and I'm new in BIRT and just can't follow your instructions. 
 
 
This would be awesome.