| Crosstab dataset refreshing [message #259710] |
Sun, 28 October 2007 12:07  |
Eclipse User |
|
|
|
Hi all,
I've problems with crosstab dataset refreshing.
My configuration:
Birt 2.2.1
Tomcat 5.5.25
For testing I made trivial report with one crosstab and one table, with
the same datasource.
After deploying report on server, data in report are correct,
but the changes in database (new values) aren't correct displayed in
crosstab (still old values), only in table.
I tried:
:__overwrite=true in the URL, __rptdocument= to new name
:disable cache preferred in data set property cache option - not
possible, because:
http://dev.eclipse.org/mhonarc/lists/birt-dev/msg08225.html
(As per latest discussion, we decide to remove cache preference setting
from Designer.)
:manual insert :<property name="cachedRowCount">-1</property> into
..rtpdesign
Only one is working: Reload BIRT Viewer with Tomcat Manager.
What do I wrong?
Thanks
Jan
|
|
|
|
| Re: Crosstab dataset refreshing [message #260168 is a reply to message #260162] |
Thu, 01 November 2007 08:11  |
| Eclipse User |
|
|
|
This is a multi-part message in MIME format.
--------------000506030102070306060101
Content-Type: text/plain; charset=windows-1250; format=flowed
Content-Transfer-Encoding: 7bit
Hi Rima,
- BIRT Designer, the data displayed in Preview are correct only after
some changes in Dataset definition (or after selecting Dataset - Preview
Results), otherwise the data in crosstab doesn't reflect the source
database changes.
In simple Table the data from the same dataset are displayed correctly
(each change in database is reflected at next Preview without Problems).
I've made simple report and table in the database for testing purposes :
On server I've tried rerunning with Page Refresh, on another PC, with
another browser - the result is the same - only reload the BIRT viewer
in Tomcat helped.
I've found on Bugzilla (Bug#: 202243) another Example, but with
different library is Problem cleared - by me not, I've tried BIRT 2.2.1
major release, night builds, - without any change.
Have you some idea?
Thanks
Jan
> Are you seeing this issue on BIRT designer
> How are you rerunning the report design?
>
> Thanks
> --Rima
>
> "Jan Prokop" <jprokop@porsche.sk> wrote in message
> news:fg2c4t$3q7$1@build.eclipse.org...
>> Hi all,
>> I've problems with crosstab dataset refreshing.
>> My configuration:
>> Birt 2.2.1
>> Tomcat 5.5.25
>>
>> For testing I made trivial report with one crosstab and one table, with
>> the same datasource.
>> After deploying report on server, data in report are correct,
>> but the changes in database (new values) aren't correct displayed in
>> crosstab (still old values), only in table.
>>
>> I tried:
>>
>> :__overwrite=true in the URL, __rptdocument= to new name
>>
>> :disable cache preferred in data set property cache option - not
>> possible, because:
>> http://dev.eclipse.org/mhonarc/lists/birt-dev/msg08225.html
>> (As per latest discussion, we decide to remove cache preference setting
>> from Designer.)
>>
>> :manual insert :<property name="cachedRowCount">-1</property> into
>> .rtpdesign
>>
>>
>> Only one is working: Reload BIRT Viewer with Tomcat Manager.
>>
>> What do I wrong?
>>
>> Thanks
>>
>> Jan
>
>
--------------000506030102070306060101
Content-Type: text/xml;
name="Cube_Test.rptdesign"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="Cube_Test.rptdesign"
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.3.0.v20071026-0800 Build <2.2.0.v20071026-0800></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 <<Your Company Name here>></property>
<html-property name="description">Creates a blank report with no predefined content.</html-property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<list-property name="libraries">
<structure>
<property name="fileName">R_INT_2007.rptlibrary</property>
<property name="namespace">R_INT_2007</property>
</structure>
</list-property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="6"
extends="R_INT_2007.Data Source"/>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Cube1" id="7">
<list-property name="columnHints">
<structure>
<property name="columnName">Parm1</property>
<property name="displayName">Parm1</property>
</structure>
<structure>
<property name="columnName">Parm2</property>
<property name="displayName">Parm2</property>
</structure>
<structure>
<property name="columnName">Datum</property>
<property name="displayName">Datum</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Parm1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Parm2</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Datum</property>
<property name="dataType">date-time</property>
</structure>
</list-property>
</structure>
<property name="rowFetchLimit">0</property>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Parm1</property>
<property name="nativeName">Parm1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Parm2</property>
<property name="nativeName">Parm2</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Datum</property>
<property name="nativeName">Datum</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
</list-property>
<property name="queryText">select Parm1, Parm2, Datum
from Test_BIRT</property>
</oda-data-set>
</data-sets>
<cubes>
<tabular-cube name="Data Cube_test1" id="8">
<property name="defaultMeasureGroup">Summary Field</property>
<property name="dimensions">
<tabular-dimension name="Group" id="9">
<property name="defaultHierarchy">NewTabularHierarchy</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy" id="10">
<property name="levels">
<tabular-level name="Parm1" id="11">
<property name="dataType">string</property>
<property name="columnName">Parm1</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
<tabular-dimension name="Group1" id="12">
<property name="isTimeType">true</property>
<property name="defaultHierarchy">NewTabularHierarchy1</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy1" id="13">
<property name="levels">
<tabular-level name="month" id="14">
<property name="dataType">integer</property>
<property name="dateTimeLevelType">month</property>
<list-property name="attributes">
<structure>
<property name="name">DateTime</property>
<property name="dataType">date-time</property>
</structure>
</list-property>
<property name="columnName">Datum</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
</property>
<property name="measureGroups">
<tabular-measure-group name="Summary Field" id="15">
<property name="measures">
<tabular-measure name="Parm2" id="16">
<expression name="measureExpression">dataSetRow["Parm2"]</expression >
<property name="dataType">integer</property>
</tabular-measure>
</property>
</tabular-measure-group>
</property>
<property name="dataSet">Cube1</property>
</tabular-cube>
</cubes>
<styles>
<style name="crosstab-cell" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<extended-item extensionName="Crosstab" id="17">
<property name="measures">
<extended-item extensionName="MeasureView" id="28">
<property name="measure">Parm2</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="29">
<property name="content">
<data name="Parm2" id="31">
<property name="resultSetColumn">Parm2</property>
</data>
</property>
</extended-item>
</property>
<property name="aggregations">
<extended-item extensionName="AggregationCell" id="34">
<property name="aggregationOnColumn">Group1/month</property>
<property name="content">
<data id="35">
<property name="resultSetColumn">Parm2_Group1/month</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="38">
<property name="aggregationOnRow">Group/Parm1</property>
<property name="content">
<data id="39">
<property name="resultSetColumn">Parm2_Group/Parm1</property>
</data>
</property>
</extended-item>
<extended-item extensionName="AggregationCell" id="40">
<property name="content">
<data id="41">
<property name="resultSetColumn">Parm2_1</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="30">
<property name="content">
<label id="32">
<text-property name="text">a1</text-property>
</label>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="rows">
<extended-item extensionName="CrosstabView" id="23">
<property name="grandTotal">
<extended-item extensionName="CrosstabCell" id="33">
<property name="content">
<label id="36">
<text-property name="text">Grand Total</text-property>
</label>
</property>
</extended-item>
</property>
<property name="views">
<extended-item extensionName="DimensionView" id="24">
<property name="dimension">Group</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View1" id="25">
<property name="level">Group/Parm1</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="26">
<property name="content">
<data name="Parm1" id="27">
<property name="resultSetColumn">Parm1</property>
</data>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="columns">
<extended-item extensionName="CrosstabView" id="18">
<property name="grandTotal">
<extended-item extensionName="CrosstabCell" id="37">
<property name="content">
<label id="42">
<text-property name="text">Grand Total</text-property>
</label>
</property>
</extended-item>
</property>
<property name="views">
<extended-item extensionName="DimensionView" id="19">
<property name="dimension">Group1</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View" id="20">
<property name="level">Group1/month</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="21">
<property name="content">
<data name="month" id="22">
<property name="resultSetColumn">month</property>
</data>
</property>
<property name="paddingTop">1pt</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="cube">Data Cube_test1</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">month</property>
<expression name="expression">dimension["Group1"]["month"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Parm1</property>
<expression name="expression">dimension["Group"]["Parm1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Parm2</property>
<expression name="expression">measure["Parm2"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Parm2_Group1/month</property>
<expression name="expression">measure["Parm2"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Group1/month</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">Parm2_Group/Parm1</property>
<expression name="expression">measure["Parm2"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>Group/Parm1</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">Parm2_1</property>
<expression name="expression">measure["Parm2"]</expression>
<property name="dataType">integer</property>
<property name="aggregateFunction">sum</property>
</structure>
</list-property>
</extended-item>
<table id="43">
<property name="width">100%</property>
<property name="dataSet">Cube1</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Parm1</property>
<expression name="expression">dataSetRow["Parm1"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Parm2</property>
<expression name="expression">dataSetRow["Parm2"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Datum</property>
<expression name="expression">dataSetRow["Datum"]</expression>
<property name="dataType">date-time</property>
</structure>
</list-property>
<column id="62"/>
<column id="63"/>
<column id="64"/>
<header>
<row id="44">
<cell id="45">
<label id="46">
<text-property name="text">Parm1</text-property>
</label>
</cell>
<cell id="47">
<label id="48">
<text-property name="text">Parm2</text-property>
</label>
</cell>
<cell id="49">
<label id="50">
<text-property name="text">Datum</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="51">
<cell id="52">
<data id="53">
<property name="resultSetColumn">Parm1</property>
</data>
</cell>
<cell id="54">
<data id="55">
<property name="resultSetColumn">Parm2</property>
</data>
</cell>
<cell id="56">
<data id="57">
<property name="resultSetColumn">Datum</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="58">
<cell id="59"/>
<cell id="60"/>
<cell id="61"/>
</row>
</footer>
</table>
</body>
</report>
--------------000506030102070306060101
Content-Type: text/plain;
name="exportdata.csv"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="exportdata.csv"
Parm1;Parm2;Datum
STRING;INT;TIMESTAMP
"A ";10;08/01/2007 12:00:00 AM
"A ";10;09/01/2007 12:00:00 AM
"A ";20;10/01/2007 12:00:00 AM
"A ";25;10/15/2007 12:00:00 AM
"B ";0;08/03/2007 12:00:00 AM
"B ";25;09/25/2007 12:00:00 AM
"B ";10;10/25/2007 12:00:00 AM
"C ";50;08/08/2007 12:00:00 AM
"C ";60;08/09/2007 12:00:00 AM
"C ";11;09/09/2007 12:00:00 AM
"A ";7;10/05/2007 12:00:00 AM
"B ";6;09/10/2007 12:00:00 AM
"C ";10;08/08/2007 12:00:00 AM
"C ";10;07/01/2007 12:00:00 AM
--------------000506030102070306060101--
|
|
|
|
|
| Re: Crosstab dataset refreshing [message #261131 is a reply to message #260433] |
Mon, 12 November 2007 01:04 |
| Eclipse User |
|
|
|
Originally posted by: msjackson1019.gmail.com
I am hoping there will be a solution to this problem soon as well. It
seems I am having a similar issue with the deploy environment. I have a
Cube based off of a Data Set that utilizes parameters in the beforeOpen
script. The first time I run the report, it will come back with the
correct data, but each subsequent time, no matter how I change the
parameters used by the data set, the Cube data does not change. The only
thing that will work is if I stop and start my report engine. I know that
the beforeOpen script is working and the data set is being changed because
I have a chart based off of that data set that will refresh with the
correct data.
If anyone has any ideas for work arounds until the problem is fixed, I'd
love to hear them.
Thanks,
Erica
|
|
|
Powered by
FUDForum. Page generated in 0.03441 seconds
Home