Displaying Text as Measure in Crosstab

my_Master

Hey there,

I tried to create a report using a Crosstab.
So, in my Dataset has a Textcolumn, witch I want to display in the Crosstabs columns. BIRT told me when i tested my solution: ...Cannot convert "comment" to double type...
How do i put a text in the measures?

The report should look like this example (Systems-Data for a view months):

System | Jan 10 | Feb 10 | Mar 10 |

---

sys1 availability=80% availability=90% availability=95%
anotherNmbr=1 anotherNmbr=3 anotherNmbr=2
Comment: Comment: Comment:
"System runs Well" "Less Problems" "Nothing bad happend"

---

sys2 availability=85% availability=92% availability=91%
anotherNmbr=1 anotherNmbr=3 anotherNmbr=2
Comment: Comment: Comment:
"System runs Well" "Less Problems" "Nothing bad happend"

---

sys3 availability=89% availability=90% availability=94%
anotherNmbr=1 anotherNmbr=3 anotherNmbr=2
Comment: Comment: Comment:
"System runs Well" "Less Problems" "Nothing bad happend"

---

Hope somebody can help...

mwilliams

Hi my_Master,

The default aggregation on a measure in a cube is "SUM". This will not work for a string. You should be able to solve this by opening your cube, editing the string measure and choosing the aggregation "FIRST" instead of "SUM". Then, in your crosstab, double click on the measure if you've already put it in the crosstab and change the aggregation there as well.

Hope this helps. Let me know if you have questions.