Data Not Displaying in Correct Row or Not Displaying at All

I am attempting to create a simple report that has a single table where some of the Data Bindings use if statements or concatination of multiple fields. I am using version 3.7.1 of BIRT and Eclipse from the IBM All in One package for use with Maximo 7.5. The problem I'm having is that any time I create a Data Binding with complicated expressions (anything more complex than dataSetRow["statusdate"]) the field displays the value of the next row. The other fields display correctly and I don't see any errors thrown when running the report. For example:ACTUALTICKET CLASS CLASSIFICATION ORIGINATING RECORD1130 SR IT Issue 1135 INCIDENT IT Issue / Networks / Internet SR 1094 REPORT PREVIEWTICKET CLASS CLASSIFICATION ORIGINATING RECORD1130 INCIDENT IT Issue SR 10941135 SR IT Issue / Networks / Internet In this example CLASS and ORIGINATING RECORD have complex expressions. Also if I add an aggregate Binding to that tabel and create a Data Binding of "Total Tickets: " + row["TotalTickets"] in the footer, I then only get data for the first row for one of the columns using complex expressions and then they ar eblank or null for the rest of the report. Something like what is shown below. TICKET CLASS CLASSIFICATION ORIGINATING RECORD1130 SR IT Issue 1135 IT Issue / Networks / Internet Here are the expressions for the 3 fields I'm having issues with: Class:if(dataSetRow["SR Has Related Incident"]) 
{ 
dataSetRow["class"] + " (INCIDENT)" 
} 
else if(dataSetRow["isglobal"]) 
{ 
dataSetRow["class"] + " (GLOBAL)" 
}else{ 
dataSetRow["class"] 
} Originating Record:if(dataSetRow["Originating Record"]){ 
dataSetRow["Originating Record Class"] + " " + dataSetRow["Originating Record"] 
} Resolution:if(BirtStr.charLength(dataSetRow["Resolution"]) >150) 
{ 
dataSetRow["Resolution"].substring(0,149) + ' ...' 
} 
else 
{ 
dataSetRow["Resolution"] 
} Can anyone help me with this issue? Is there anything I'm doing wrong with the expressions in those fields?

Find more posts tagged with

Comments

mwilliams

Any way you can recreate the issue in a sample report that I can run? Have you tried creating these expression fields as computed columns in the dataSet or tried building the expression in a dynamic text box instead of a data element? Let me know.

mscuoco

Attached is a simple report that demonstrates the issue and PDF of the results I'm seeing. All this report does is query the ticket table for ticketid and class. Then I created a table to display 3 columns. The Ticket ID, Class, and Class concatenated to another number. I then added an aggregate function to the footer.

The Class column has the expression:
dataSetRow["class"]

The Class + "X" column has the expression:
dataSetRow["class"] + "X"

Notice that they display different values even though they should be the same except for the X on the end. The column with concatenation has the correct value for the first row and then is off by +1 row for the rest of report with the last row having a value of null. Again the report displays correctly if the aggregation is removed. I can try using a dynamic text element. I'm still new to BIRT and didn't think you could use if statements in them. Edit: I just tried using Dynamic Text. If I use it for concatenation it displays correctly, but if I use if statements it always shows up blank. Edit2: Actually I just noticed that when selecting the column in the Dynamic Text Field you select from the bindings. I was using dataSetRow["class"] instead of row["class"]. Changing all of the fields I was having problems with to use row instead of dataSetRow fixed my problem. Thanks! Can you tell me the difference is between dataSetRow[] and row[]?

mwilliams

Glad you got it working. Take a look at this blog post: <a data-ipb='nomediaparse' href='http://birtworld.blogspot.com/2010/07/whats-difference-between.html'>http://birtworld.blogspot.com/2010/07/whats-difference-between.html</a>

anthonyo60

Hello Williams
I'm still confused.
And the picture on your link are not displaying.
I have the same problem than mscuoco , I'm executing a report , I have 2 date columns (nextdate and extdate) . When extdate is null, I want to display nextdate.
I used Items "Data" and my expression is:

if (dataSetRow["extdate"]==null)
dataSetRow["nextdate"]
else dataSetRow["extdate"]

Sometimes, when date field are empty, we have not the good date for the good row !
Thanks

Chad Montgomery

Have you tried creating a computed column in the data set that achieves what you're looking for? You could then just reference that computed column without having to use any conditional statements in the data element.

anthonyo60

No
How we can do that?

Chad Montgomery

Here's a quick sample that has a computed column called "StateOrCountry" that shows the state column value, and uses the country value if state is null. Note that there are multiple types of "no values" and it depends on your data type and the data coming back from the database. Overall, you'll want to check for nulls, empty strings, and potentially undefined (though I think the third is unlikely).

ComputedColumn.rptdesign

wwilliams

If this is Maximo, you'd do it in the fetch method (version 3.7.1)
if(row["STATE"]==null) {
row["COUNTRY"];
} else {
row["STATE"];
}

anthonyo60

They working well with your code WWilliams. I don't really understand why because it's the same code of mine, but with { } (I tried with datesetrow() and row() )
Thanks