Home » Archived » BIRT » Use of DataCube and this.queryText fails (BUG?)
| Use of DataCube and this.queryText fails (BUG?) [message #257282] |
Fri, 05 October 2007 03:30  |
Eclipse User |
|
|
|
Hi,
I am building a query based on a queryparameter. The query is set in the
"beforeOpen" of the DataSet using:
this.queryText = "select a, b, c from data where c in (1,2,3)"
The query runs fine and the table of data is correct.
When I include a DataCube based on the DataSet defined above, it takes the
original queryText and it seems that it doesn't invoke the "beforeOpen".
The resulting crosstab only shows the data that is in the "dummy query".
How to workaround this issue?
Klaasjan
|
|
| |
| Re: Use of DataCube and this.queryText fails (BUG?) [message #257400 is a reply to message #257396] |
Sat, 06 October 2007 03:21  |
| Eclipse User |
|
|
|
Hi,
Do mind! It seems that this bug occurs when the params are taken as input.
It looks like the crosstab data is received once even tough the input
changes.
Attached is a sample.
Usecase:
* run report with states CA,NSW
* run report with states CA,NSW,BC,NY
Look if the data in the regular table matches the data in the crosstab.
* Remove comment for one line in the beforeOpen script of the Sample DS and
run the report
* Remove comment for one line in the beforeOpen script of the Sample DS,
comment the previous line and run the report
Notice the differences. In the last two cases, the data is being
refreshed...
Klaasjan
"Klaasjan Tukker" <klaasjan@tukker.org> wrote in message
news:fe7bnp$ccg$1@build.eclipse.org...
> Hi,
>
> Nevermind.... When I started to creaete a CM sample for a bug report,
> Everything worked fine again...strange....
>
> Klaasjan
>
> "Klaasjan Tukker" <klaasjan@tukker.org> wrote in message
> news:fe4p2i$bj6$1@build.eclipse.org...
>> Hi,
>>
>> I am building a query based on a queryparameter. The query is set in the
>> "beforeOpen" of the DataSet using:
>>
>> this.queryText = "select a, b, c from data where c in (1,2,3)"
>>
>> The query runs fine and the table of data is correct.
>>
>> When I include a DataCube based on the DataSet defined above, it takes
>> the
>> original queryText and it seems that it doesn't invoke the "beforeOpen".
>> The resulting crosstab only shows the data that is in the "dummy query".
>>
>> How to workaround this issue?
>>
>> Klaasjan
>>
>
>
|
|
|
| Re: Use of DataCube and this.queryText fails (BUG?) [message #257531 is a reply to message #257400] |
Mon, 08 October 2007 12:08 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Klaasjan,
This looks like a bug. Can you log a bugzilla entry for this?
Jason
Klaasjan Tukker wrote:
> Hi,
>
> Do mind! It seems that this bug occurs when the params are taken as input.
> It looks like the crosstab data is received once even tough the input
> changes.
>
> Attached is a sample.
>
> Usecase:
> * run report with states CA,NSW
> * run report with states CA,NSW,BC,NY
>
> Look if the data in the regular table matches the data in the crosstab.
>
> * Remove comment for one line in the beforeOpen script of the Sample DS and
> run the report
> * Remove comment for one line in the beforeOpen script of the Sample DS,
> comment the previous line and run the report
>
> Notice the differences. In the last two cases, the data is being
> refreshed...
>
> Klaasjan
>
> "Klaasjan Tukker" <klaasjan@tukker.org> wrote in message
> news:fe7bnp$ccg$1@build.eclipse.org...
>> Hi,
>>
>> Nevermind.... When I started to creaete a CM sample for a bug report,
>> Everything worked fine again...strange....
>>
>> Klaasjan
>>
>> "Klaasjan Tukker" <klaasjan@tukker.org> wrote in message
>> news:fe4p2i$bj6$1@build.eclipse.org...
>>> Hi,
>>>
>>> I am building a query based on a queryparameter. The query is set in the
>>> "beforeOpen" of the DataSet using:
>>>
>>> this.queryText = "select a, b, c from data where c in (1,2,3)"
>>>
>>> The query runs fine and the table of data is correct.
>>>
>>> When I include a DataCube based on the DataSet defined above, it takes
>>> the
>>> original queryText and it seems that it doesn't invoke the "beforeOpen".
>>> The resulting crosstab only shows the data that is in the "dummy query".
>>>
>>> How to workaround this issue?
>>>
>>> Klaasjan
>>>
>>
>
>
|
|
|
| Re: Use of DataCube and this.queryText fails (BUG?) [message #257553 is a reply to message #257531] |
Mon, 08 October 2007 12:48 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Klaasjan,
You may want to use the multiselect parameter as a work around for this
issue. See attached example.
Jason
<?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.2.1.r221_v20070924 Build <2.2.0.v20070924-1550></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>
<list-property name="userProperties">
<structure>
<property name="name">Sample Cub.Sample DS.x</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
<structure>
<property name="name">Sample Cub.Sample DS.y</property>
<property name="type">integer</property>
<property name="isVisible">false</property>
</structure>
</list-property>
<property name="Sample Cub.Sample DS.x">135</property>
<property name="Sample Cub.Sample DS.y">80</property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<parameters>
<scalar-parameter name="NewParameter" id="66">
<property name="valueType">dynamic</property>
<property name="dataType">string</property>
<property name="paramType">multi-value</property>
<property name="controlType">list-box</property>
<property name="dataSetName">Data Set</property>
<expression name="valueExpr">dataSetRow["STATE"]</expression>
<expression name="labelExpr">dataSetRow["STATE"]</expression>
<property name="mustMatch">true</property>
<property name="fixedOrder">true</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
name="CM" id="6">
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Sample DS" id="7">
<list-property name="columnHints">
<structure>
<property name="columnName">CUSTOMERNUMBER</property>
<property name="displayName">CUSTOMERNUMBER</property>
</structure>
<structure>
<property name="columnName">CUSTOMERNAME</property>
<property name="displayName">CUSTOMERNAME</property>
</structure>
<structure>
<property name="columnName">CONTACTLASTNAME</property>
<property name="displayName">CONTACTLASTNAME</property>
</structure>
<structure>
<property name="columnName">CONTACTFIRSTNAME</property>
<property name="displayName">CONTACTFIRSTNAME</property>
</structure>
<structure>
<property name="columnName">PHONE</property>
<property name="displayName">PHONE</property>
</structure>
<structure>
<property name="columnName">ADDRESSLINE1</property>
<property name="displayName">ADDRESSLINE1</property>
</structure>
<structure>
<property name="columnName">ADDRESSLINE2</property>
<property name="displayName">ADDRESSLINE2</property>
</structure>
<structure>
<property name="columnName">CITY</property>
<property name="displayName">CITY</property>
</structure>
<structure>
<property name="columnName">STATE</property>
<property name="displayName">STATE</property>
</structure>
<structure>
<property name="columnName">POSTALCODE</property>
<property name="displayName">POSTALCODE</property>
</structure>
<structure>
<property name="columnName">COUNTRY</property>
<property name="displayName">COUNTRY</property>
</structure>
<structure>
<property name="columnName">SALESREPEMPLOYEENUMBER</property>
<property name="displayName">SALESREPEMPLOYEENUMBER</property>
</structure>
<structure>
<property name="columnName">CREDITLIMIT</property>
<property name="displayName">CREDITLIMIT</property>
</structure>
</list-property>
<list-property name="filter">
<structure>
<property name="operator">in</property>
<expression name="expr">row["STATE"]</expression>
<simple-property-list name="value1">
<value>params["NewParameter"]</value>
</simple-property-list>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">CM</property>
<method name="beforeOpen"><![CDATA[//var input = params["states"];
//var input = "CA,NSW";
//var input = "CA,NSW,BC,NY";
//var clause = input.replace(/ /g,"");
//clause = clause.replace(/\,/g,"','");
//clause = "('"+clause+"')";
//myquery = this.queryText.replace("('CA')",clause);
//this.queryText = myquery;]]></method>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="nativeName">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="nativeName">CUSTOMERNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="nativeName">CONTACTLASTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="nativeName">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="nativeName">PHONE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="nativeName">ADDRESSLINE1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="nativeName">ADDRESSLINE2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="nativeName">CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="nativeName">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="nativeName">POSTALCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="nativeName">COUNTRY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<property name="nativeName">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="nativeName">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<property name="queryText">select *
from customers
</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="67">
<list-property name="columnHints">
<structure>
<property name="columnName">STATE</property>
<property name="displayName">STATE</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">CM</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STATE</property>
<property name="nativeName">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select Distinct CLASSICMODELS.CUSTOMERS.STATE
from CLASSICMODELS.CUSTOMERS</property>
</oda-data-set>
</data-sets>
<cubes>
<tabular-cube name="Sample Cub" id="40">
<property name="defaultMeasureGroup">Summary Field</property>
<property name="dimensions">
<tabular-dimension name="Group" id="41">
<property name="defaultHierarchy">NewTabularHierarchy</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy" id="42">
<property name="levels">
<tabular-level name="STATE" id="43">
<property name="dataType">string</property>
<property name="columnName">STATE</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
<tabular-dimension name="Group1" id="46">
<property name="defaultHierarchy">NewTabularHierarchy1</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy1" id="47">
<property name="levels">
<tabular-level name="COUNTRY" id="48">
<property name="dataType">string</property>
<property name="columnName">COUNTRY</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
</property>
<property name="measureGroups">
<tabular-measure-group name="Summary Field" id="44">
<property name="measures">
<tabular-measure name="COUNT" id="45">
<property name="function">count</property>
<property name="dataType">integer</property>
</tabular-measure>
</property>
</tabular-measure-group>
</property>
<property name="dataSet">Sample DS</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>
<table id="8">
<property name="width">100%</property>
<property name="dataSet">Sample DS</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CUSTOMERNUMBER</property>
<expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CUSTOMERNAME</property>
<expression name="expression">dataSetRow["CUSTOMERNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CONTACTLASTNAME</property>
<expression name="expression">dataSetRow["CONTACTLASTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CONTACTFIRSTNAME</property>
<expression name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PHONE</property>
<expression name="expression">dataSetRow["PHONE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE1</property>
<expression name="expression">dataSetRow["ADDRESSLINE1"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ADDRESSLINE2</property>
<expression name="expression">dataSetRow["ADDRESSLINE2"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CITY</property>
<expression name="expression">dataSetRow["CITY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression name="expression">dataSetRow["STATE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">POSTALCODE</property>
<expression name="expression">dataSetRow["POSTALCODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COUNTRY</property>
<expression name="expression">dataSetRow["COUNTRY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CREDITLIMIT</property>
<expression name="expression">dataSetRow["CREDITLIMIT"]</expression >
<property name="dataType">float</property>
</structure>
</list-property>
<column id="21"/>
<column id="22"/>
<column id="23"/>
<header>
<row id="9">
<cell id="10">
<label id="34">
<text-property name="text">CUSTOMERNAME</text-property>
</label>
</cell>
<cell id="11">
<label id="38">
<text-property name="text">CREDITLIMIT</text-property>
</label>
</cell>
<cell id="12">
<label id="36">
<text-property name="text">COUNTRY</text-property>
</label>
</cell>
</row>
</header>
<group id="24">
<property name="groupName">State</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["STATE"]</expression>
<structure name="toc">
<expression name="expressionValue">row["STATE"]</expression>
</structure>
<property name="repeatHeader">true</property>
<property name="hideDetail">false</property>
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<header>
<row id="25">
<cell id="26">
<data id="33">
<property name="resultSetColumn">STATE</property>
</data>
</cell>
<cell id="27"/>
<cell id="28"/>
</row>
</header>
<footer>
<row id="29">
<cell id="30"/>
<cell id="31"/>
<cell id="32"/>
</row>
</footer>
</group>
<detail>
<row id="13">
<cell id="14">
<data id="35">
<property name="resultSetColumn">CUSTOMERNAME</property>
</data>
</cell>
<cell id="15">
<data id="39">
<property name="resultSetColumn">CREDITLIMIT</property>
</data>
</cell>
<cell id="16">
<data id="37">
<property name="resultSetColumn">COUNTRY</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="17">
<cell id="18"/>
<cell id="19"/>
<cell id="20"/>
</row>
</footer>
</table>
<extended-item extensionName="Crosstab" id="49">
<property name="measures">
<extended-item extensionName="MeasureView" id="60">
<property name="measure">COUNT</property>
<property name="detail">
<extended-item extensionName="CrosstabCell" id="61">
<property name="content">
<data name="COUNT" id="63">
<property name="resultSetColumn">COUNT</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="62">
<property name="content">
<label id="64">
<text-property name="text">COUNT</text-property>
</label>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="rows">
<extended-item extensionName="CrosstabView" id="50">
<property name="views">
<extended-item extensionName="DimensionView" id="51">
<property name="dimension">Group1</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View" id="52">
<property name="level">Group1/COUNTRY</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="53">
<property name="content">
<data name="COUNTRY" id="54">
<property name="resultSetColumn">COUNTRY</property>
</data>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="columns">
<extended-item extensionName="CrosstabView" id="55">
<property name="views">
<extended-item extensionName="DimensionView" id="56">
<property name="dimension">Group</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View1" id="57">
<property name="level">Group/STATE</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="58">
<property name="content">
<data name="STATE" id="59">
<property name="resultSetColumn">STATE</property>
</data>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="cube">Sample Cub</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">COUNTRY</property>
<expression name="expression">dimension["Group1"]["COUNTRY"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression name="expression">dimension["Group"]["STATE"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">COUNT</property>
<expression name="expression">measure["COUNT"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
</extended-item>
</body>
</report>
Jason Weathersby wrote:
> Klaasjan,
>
> This looks like a bug. Can you log a bugzilla entry for this?
>
> Jason
>
> Klaasjan Tukker wrote:
>> Hi,
>>
>> Do mind! It seems that this bug occurs when the params are taken as
>> input. It looks like the crosstab data is received once even tough the
>> input changes.
>>
>> Attached is a sample.
>>
>> Usecase:
>> * run report with states CA,NSW
>> * run report with states CA,NSW,BC,NY
>>
>> Look if the data in the regular table matches the data in the crosstab.
>>
>> * Remove comment for one line in the beforeOpen script of the Sample
>> DS and run the report
>> * Remove comment for one line in the beforeOpen script of the Sample
>> DS, comment the previous line and run the report
>>
>> Notice the differences. In the last two cases, the data is being
>> refreshed...
>>
>> Klaasjan
>>
>> "Klaasjan Tukker" <klaasjan@tukker.org> wrote in message
>> news:fe7bnp$ccg$1@build.eclipse.org...
>>> Hi,
>>>
>>> Nevermind.... When I started to creaete a CM sample for a bug report,
>>> Everything worked fine again...strange....
>>>
>>> Klaasjan
>>>
>>> "Klaasjan Tukker" <klaasjan@tukker.org> wrote in message
>>> news:fe4p2i$bj6$1@build.eclipse.org...
>>>> Hi,
>>>>
>>>> I am building a query based on a queryparameter. The query is set in
>>>> the
>>>> "beforeOpen" of the DataSet using:
>>>>
>>>> this.queryText = "select a, b, c from data where c in (1,2,3)"
>>>>
>>>> The query runs fine and the table of data is correct.
>>>>
>>>> When I include a DataCube based on the DataSet defined above, it
>>>> takes the
>>>> original queryText and it seems that it doesn't invoke the
>>>> "beforeOpen".
>>>> The resulting crosstab only shows the data that is in the "dummy
>>>> query".
>>>>
>>>> How to workaround this issue?
>>>>
>>>> Klaasjan
>>>>
>>>
>>
>>
|
|
|
Goto Forum:
Current Time: Sat May 10 05:34:53 EDT 2025
Powered by FUDForum. Page generated in 0.05322 seconds |
Home