Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Data Not Displaying in Correct Row or Not Displaying at All
Migrateduser
<p>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.</p><p> </p><p>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.</p><p> </p><p>For example:</p><p><span class='bbc_underline'><strong>ACTUAL</strong></span></p><p><strong>TICKET CLASS CLASSIFICATION ORIGINATING RECORD</strong></p><p>1130 SR IT Issue </p><p>1135 INCIDENT IT Issue / Networks / Internet SR 1094</p><p> </p><p><span class='bbc_underline'><strong>REPORT PREVIEW</strong></span></p><p><strong>TICKET CLASS CLASSIFICATION ORIGINATING RECORD</strong></p><p>1130 INCIDENT IT Issue SR 1094</p><p>1135 SR IT Issue / Networks / Internet</p><p> </p><p>In this example CLASS and ORIGINATING RECORD have complex expressions.</p><p> </p><p>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.</p><p> </p><p><strong>TICKET CLASS CLASSIFICATION ORIGINATING RECORD</strong></p><p>1130 SR IT Issue </p><p>1135 IT Issue / Networks / Internet </p><p> </p><p> </p><p>Here are the expressions for the 3 fields I'm having issues with:</p><p> </p><p><strong>Class:</strong></p><p>if(dataSetRow["SR Has Related Incident"])<br />
{<br />
dataSetRow["class"] + " (INCIDENT)"<br />
}<br />
else if(dataSetRow["isglobal"])<br />
{<br />
dataSetRow["class"] + " (GLOBAL)"<br />
}else{<br />
dataSetRow["class"]<br />
}</p><p> </p><p><strong>Originating Record</strong>:</p><p>if(dataSetRow["Originating Record"]){<br />
dataSetRow["Originating Record Class"] + " " + dataSetRow["Originating Record"]<br />
}</p><p> </p><p><strong>Resolution:</strong></p><p>if(BirtStr.charLength(dataSetRow["Resolution"]) >150)<br />
{<br />
dataSetRow["Resolution"].substring(0,149) + ' ...'<br />
}<br />
else<br />
{<br />
dataSetRow["Resolution"]<br />
}</p><p> </p><p> </p><p>Can anyone help me with this issue? Is there anything I'm doing wrong with the expressions in those fields?</p>
Find more posts tagged with
Comments
There are no comments yet