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; } } }

Strange bug with BIRT 2,1,1

LeinadJan

Hello everybody, 
 
we got a really strange display bug with BIRT 2.1.1 . And we got it on multiple report from the same source. I've never seen that same kind of bug with any other reports I made with that version. I'll try to explain it the best I can. 
 
Somebody developped many small reports and one big reports that is the sums of every type of small reports. We had to change the data source for a new database. On most small reports, it had a strange effect if I changed the default parameters and saved the file before going into the preview screen, I lost all the values in a dataset for that specific value. All values are working except the new default value. When that happen, all the fields are empty but the row has values. If I do the same but I go to the preview before saving the changes, it works correctly. I've never had those problems before. 
 
It's easy to bypass that problem on the small reports, I don't save before going into the preview. But the real prblem is in the general report where the same dataset is displaying nothing at all for every case. And I know there are data for the specific parameters. I try to recreate the dataset, but it'S evn worse, this time it doesn't even show the empty row. Only the fields header. 
 
Do you know if there is a limit of dataset per reports, because that report has so many datasets ? It has 28 datasets, 29 counting the new one. The dataset's query is really simple too. 
 
I don't understand : do you see anything wrong in the XML definition ? 
 
<blockquote class='ipsBlockquote' ><oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="ExternalService" id="804"> 
<structure name="cachedMetaData"> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">CLD_ROW_ID</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">2</property> 
<property name="name">YEA_YEAR</property> 
<property name="dataType">decimal</property> 
</structure> 
<structure> 
<property name="position">3</property> 
<property name="name">SER_SERVICE_TYPE</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">4</property> 
<property name="name">SER_CLIENT</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">5</property> 
<property name="name">SER_ROW_ID</property> 
<property name="dataType">decimal</property> 
</structure> 
</list-property> 
</structure> 
<property name="dataSource">CLD</property> 
<list-property name="parameters"> 
<structure> 
<property name="name">param1</property> 
<property name="paramName">cld_row_id</property> 
<property name="nativeName"></property> 
<property name="dataType">any</property> 
<property name="nativeDataType">0</property> 
<property name="position">1</property> 
<property name="isOptional">false</property> 
<property name="isInput">true</property> 
<property name="isOutput">false</property> 
</structure> 
<structure> 
<property name="name">param2</property> 
<property name="paramName">year</property> 
<property name="nativeName"></property> 
<property name="dataType">any</property> 
<property name="nativeDataType">0</property> 
<property name="position">2</property> 
<property name="isOptional">true</property> 
<property name="isInput">true</property> 
<property name="isOutput">false</property> 
</structure> 
</list-property> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">CLD_ROW_ID</property> 
<property name="nativeName">CLD_ROW_ID</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">2</property> 
<property name="name">YEA_YEAR</property> 
<property name="nativeName">YEA_YEAR</property> 
<property name="dataType">decimal</property> 
</structure> 
<structure> 
<property name="position">3</property> 
<property name="name">SER_SERVICE_TYPE</property> 
<property name="nativeName">SER_SERVICE_TYPE</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">4</property> 
<property name="name">SER_CLIENT</property> 
<property name="nativeName">SER_CLIENT</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">5</property> 
<property name="name">SER_ROW_ID</property> 
<property name="nativeName">SER_ROW_ID</property> 
<property name="dataType">decimal</property> 
</structure> 
</list-property> 
<property name="queryText">SELECT SER.cld_row_id, SER.yea_year, 
SER.ser_service_type, SER.ser_client, 
SER.ser_row_id 
FROM cld_servi_ext SER 
WHERE SER.cld_row_id = ? 
AND SER.yea_year = ? 
</property> 
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?> 
<model:DesignValues xmlns:design="<a class='bbc_url' href='http://www.eclipse.org/datatools/connectivity/oda/design'>http://www.eclipse.org/datatools/connectivity/oda/design"</a> xmlns:model="<a class='bbc_url' href='http://www.eclipse.org/birt/report/model/adapter/odaModel">'>http://www.eclipse.org/birt/report/model/adapter/odaModel"></a> 
<Version>1.0</Version> 
<design:DataSetParameters> 
<design:parameterDefinitions> 
<design:inOutMode>In</design:inOutMode> 
<design:attributes> 
<design:name></design:name> 
<design:position>1</design:position> 
<design:nullability>Unknown</design:nullability> 
<design:uiHints> 
<design:displayName>CLD ID</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:inputAttributes> 
<design:elementAttributes> 
<design:defaultScalarValue>001</design:defaultScalarValue> 
<design:optional>false</design:optional> 
<design:masksValue>false</design:masksValue> 
<design:uiHints> 
<design:promptStyle>TextField</design:promptStyle> 
</design:uiHints> 
</design:elementAttributes> 
</design:inputAttributes> 
</design:parameterDefinitions> 
<design:parameterDefinitions> 
<design:inOutMode>In</design:inOutMode> 
<design:attributes> 
<design:name></design:name> 
<design:position>2</design:position> 
<design:nullability>Unknown</design:nullability> 
<design:uiHints> 
<design:displayName>Year</design:displayName> 
</design:uiHints> 
</design:attributes> 
<design:inputAttributes> 
<design:elementAttributes> 
<design:defaultScalarValue>2007</design:defaultScalarValue> 
<design:optional>true</design:optional> 
<design:masksValue>false</design:masksValue> 
<design:uiHints> 
<design:promptStyle>TextField</design:promptStyle> 
</design:uiHints> 
</design:elementAttributes> 
</design:inputAttributes> 
</design:parameterDefinitions> 
</design:DataSetParameters> 
</model:DesignValues>]]></xml-property> 
</oda-data-set></blockquote>
 
It looks ok...

Find more posts tagged with

Comments

LeinadJan

<blockquote class='ipsBlockquote' data-author="'LeinadJan'" data-cid="84763" data-time="1320176856" data-date="01 November 2011 - 12:47 PM">
It looks ok... </blockquote>
 
It was ok, I don't know why, but it's working now. 
 
Now it seems I got an object copy paste bug. When I'm copying a a grid with a table inside with some formatting. The copy seems to have maintain the format on the screen, but when I'm doing a preview, I lost all the formattings. 
 
That is so annoying.