nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Strings in Crosstab Summary Field

sbanaszak

Hello everyone, 
 
I am doing a report and I think I have to use a crosstab. 
<blockquote class='ipsBlockquote' >
The result should be something like this: 
_________________|Type1|Type2|Type3|Type4|........ 
SECTION1__________UN_____AP____AP____UN__..... 
SECTION2__________AS_____UN____UN____UN__..... 
. 
. 
. </blockquote>
 
On the left side should be the list of road sections and in the columns there should be the assessment codes listed by type. 
 
I understand that I can't use strings in summary fields so I made a computed column that would convert the codes to numbers like this: 
 
<blockquote class='ipsBlockquote' >
UN -> 1 
AP -> 2 
... </blockquote>
 
Then in the expression builder for the summary field I put in this script: 
<blockquote class='ipsBlockquote' >
if (dataSetRow["****_number"] == "1" ) 
{UN} 
else if (dataSetRow["****_number"] == "2") 
{AS} 
else if (dataSetRow["****_number"] == "3") 
{AP} 
else if (dataSetRow["****_number"] == "4") 
{DE} 
else if (dataSetRow["****_number"] == "5") 
{HL} 
else if (dataSetRow["****_number"] == "0") 
{0}; </blockquote>
 
to convert it back to strings. 
 
This doesn't work

Anyone got any ideas? 
 
Thanks a lot!

Find more posts tagged with

Comments

mwilliams

Hi sbanaszak,

What version of BIRT are you using?

sbanaszak

I'm using 2.2.1 but I can't get it to work in 2.3.1 either

sbanaszak

*bump*

I'm desparate

mwilliams

sbanaszak, 
 
If you already have the integer values correct in your crosstab. In BIRT 2.3 and higher, you can change the value in the measure item's OnCreate script with an if/else statement like the following: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (this.getValue() == 1){
this.setDisplayValue("UN");
}
else if (this.getValue() == 2){
this.setDisplayValue("AS");
}
...
...
etc.
</pre>
 
I have not found a way to do this with older versions. I'm pretty sure that the upgrades to crosstabs in 2.3 made this possible. 
 
Let me know if you have any other questions.

sbanaszak

Thanks a lot Michael, it now works great in 2.3.1.. So there's probably no way of avoiding the upgrade to 2.3.1..

Do you know of any way to disable the window that pops up everytime I preview the report and says "This report contains errors do you really want to run blablabla"? Or is there a way to actually find out what the error is?

Regards,
Stan

mwilliams

Stan,

I would assume it would just be a problem with some script you have somewhere in your report. You may just want to look over all your bindings and scripts closely to see if you see any problems. I'd have to look at the report to see if I see anything. I won't be able to run it though. Would just be able to look it over.

smb

I appreciate if some BIRT expert can help me on similar topic. (I'm a newbie to BIRT)
I tried several searches but not able to land on best solution. This topic took my attention as it sounded similar and may define the way ahead for the issue I need to resolve.

I would like to display string data in the crosstab for the summary field. However these strings are dynamic and stored in database against a crosstab intersection. Hence above solution doesn't help to resolve in the case I have.

Example my table is like as below....

ID TYPE STATUS
================
1 A Pass
1 B Fail
2 A Pass
2 B Pass
2 C Fail

Resulting report I am interested in as follows : (I tried cross tab...)

A B C
=================
1 | Pass Fail
2 | Pass Pass Fail

Number of rows and columns in above report are dynamic and can be determinde only at runtime and bound to changes too. (i.e "TYPE" values are dynamic)

I was trying crosstab but stuck with unable to display string (crosstab expects double in summary field) as per the column "STATUS".

Please someone guide me if I can achieve this using crosstab , may be some rendering or event handling after crosstab generation.

Also suggest alternate solution if crosstab isn't the right way.

Thanks in advance
-smb

HPP

hi smb,

I guess u have to change the data type of the summary filed to string and funtion to first.

with regards,

hpp

mwilliams

Yep. Just like HPP said. Take a look at this example. I use your data in a scripted dataSet, so don't worry about the script in the dataSet. That's just to get data exactly like your example. What you need to look at is the dataCube. Double click on the dataCube in the Data Explorer, then double click on the measure field, you'll see that the FIRST aggregation is selected and the field type is String. This report was designed in BIRT 3.7.2.

gowtham

Hi William, 
 
 I have created similar report and data source is csv file. When i change "String" and "First" for Summary i am getting 17070 error code. i am using Actuate designer pro trial version.

pricher

Hi,
 
The 17070 error code is a generic error code. To get more details about the error, look into the Error Log view. You may have to go to Window --> Show View --> Error Log to make the view available in Eclipse.
 
P.