Home » Archived » BIRT » Property Binding (Home folder field) doen't work with crosstabs
|
Re: Property Binding (Home folder field) doen't work with crosstabs [message #367084 is a reply to message #367072] |
Tue, 17 February 2009 20:06 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Chris,
Are you saying if the datasource is used in a crosstab the property
binding doesnt work? What happens if you use a table? then a table and
a crosstab (table first). Also what version of BIRT are you using?
Jason
Chris wrote:
> Hi guys,
>
> I am sure you are the best of the best BIRT experts...
>
> Do you know why Property Binding doen't work with crosstabs? It's ok
> with another report items.
>
> In fact I try to use the field "Home Folder" in a Flat file datasource.
>
> If the field "Home Folder" has the value 'C:\test', so it's working.
> But if the field "Home Folder" has a dynamic value like
> 'params["DataSourcePath"].value' , so it's ko !!!
>
> PS : DataSourcePath is a Report Parameters.
>
> The selected folder that contains the flat files is always "C:\test" :-(
>
> Thanks in advance.
>
|
|
|
Re: Property Binding (Home folder field) doen't work with crosstabs [message #367096 is a reply to message #367084] |
Wed, 18 February 2009 10:09 |
Christophe Messages: 15 Registered: July 2009 |
Junior Member |
|
|
This is a multi-part message in MIME format.
--------------000204090002080801060306
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Yeah Jason,
When I use a table, it's ok.
When I use a table and a crosstab (or only a crosstab), it's ko.
Version of BIRT : 2.3.1
Eclipse : 3.4.0
The fisrt error occured is the following :
org.eclipse.birt.report.engine.api.EngineException: An exception
occurred during processing. Please see the following message for details:
exception.error
Failed to prepare the following query for the data set type
org.eclipse.datatools.connectivity.oda.flatfile.dataSet.
[select "code", "label", "pourcent" from data.csv :
{"code","code",STRING;"label","label",STRING;"pourcent ","pourcent",INT}]
Invalid table name:data.csv
Failed to prepare the following query for the data set type
org.eclipse.datatools.connectivity.oda.flatfile.dataSet.
[select "code", "label", "pourcent" from data.csv :
{"code","code",STRING;"label","label",STRING;"pourcent ","pourcent",INT}]
Invalid table name:data.csv
at
org.eclipse.birt.report.engine.executor.ExecutionContext.add Exception(ExecutionContext.java:1109)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.d oPrepareQuery(AbstractDataEngine.java:210)
....
You can have a look to my attached report if you want.
Thanks.
Jason Weathersby a
|
|
|
Re: Property Binding (Home folder field) doen't work with crosstabs [message #367104 is a reply to message #367096] |
Wed, 18 February 2009 17:25 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Chris,
Can you log a bug for this?
Also as a work around try to move the property binding to the before
Open script for the data set.
Jason
Chris wrote:
> Yeah Jason,
>
> When I use a table, it's ok.
> When I use a table and a crosstab (or only a crosstab), it's ko.
>
> Version of BIRT : 2.3.1
> Eclipse : 3.4.0
>
> The fisrt error occured is the following :
>
> org.eclipse.birt.report.engine.api.EngineException: An exception
> occurred during processing. Please see the following message for details:
> exception.error
> Failed to prepare the following query for the data set type
> org.eclipse.datatools.connectivity.oda.flatfile.dataSet.
> [select "code", "label", "pourcent" from data.csv :
> {"code","code",STRING;"label","label",STRING;"pourcent ","pourcent",INT}]
> Invalid table name:data.csv
> Failed to prepare the following query for the data set type
> org.eclipse.datatools.connectivity.oda.flatfile.dataSet.
> [select "code", "label", "pourcent" from data.csv :
> {"code","code",STRING;"label","label",STRING;"pourcent ","pourcent",INT}]
> Invalid table name:data.csv
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.add Exception(ExecutionContext.java:1109)
>
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.d oPrepareQuery(AbstractDataEngine.java:210)
>
> ...
>
>
>
> You can have a look to my attached report if you want.
>
> Thanks.
>
>
> Jason Weathersby a écrit :
>> Chris,
>>
>> Are you saying if the datasource is used in a crosstab the property
>> binding doesnt work? What happens if you use a table? then a table
>> and a crosstab (table first). Also what version of BIRT are you using?
>>
>> Jason
>>
>> Chris wrote:
>>> Hi guys,
>>>
>>> I am sure you are the best of the best BIRT experts...
>>>
>>> Do you know why Property Binding doen't work with crosstabs? It's ok
>>> with another report items.
>>>
>>> In fact I try to use the field "Home Folder" in a Flat file datasource.
>>>
>>> If the field "Home Folder" has the value 'C:\test', so it's working.
>>> But if the field "Home Folder" has a dynamic value like
>>> 'params["DataSourcePath"].value' , so it's ko !!!
>>>
>>> PS : DataSourcePath is a Report Parameters.
>>>
>>> The selected folder that contains the flat files is always "C:\test" :-(
>>>
>>> Thanks in advance.
>>>
>
|
|
|
Re: Property Binding (Home folder field) doen't work with crosstabs [message #367133 is a reply to message #367104] |
Fri, 20 February 2009 09:40 |
Christophe Messages: 15 Registered: July 2009 |
Junior Member |
|
|
The bug 265475 has been logged.
Jason Weathersby a écrit :
> Chris,
>
> Can you log a bug for this?
> Also as a work around try to move the property binding to the before
> Open script for the data set.
>
> Jason
>
> Chris wrote:
>> Yeah Jason,
>>
>> When I use a table, it's ok.
>> When I use a table and a crosstab (or only a crosstab), it's ko.
>>
>> Version of BIRT : 2.3.1
>> Eclipse : 3.4.0
>>
>> The fisrt error occured is the following :
>>
>> org.eclipse.birt.report.engine.api.EngineException: An exception
>> occurred during processing. Please see the following message for details:
>> exception.error
>> Failed to prepare the following query for the data set type
>> org.eclipse.datatools.connectivity.oda.flatfile.dataSet.
>> [select "code", "label", "pourcent" from data.csv :
>> {"code","code",STRING;"label","label",STRING;"pourcent ","pourcent",INT}]
>> Invalid table name:data.csv
>> Failed to prepare the following query for the data set type
>> org.eclipse.datatools.connectivity.oda.flatfile.dataSet.
>> [select "code", "label", "pourcent" from data.csv :
>> {"code","code",STRING;"label","label",STRING;"pourcent ","pourcent",INT}]
>> Invalid table name:data.csv
>> at
>> org.eclipse.birt.report.engine.executor.ExecutionContext.add Exception(ExecutionContext.java:1109)
>>
>> at
>> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.d oPrepareQuery(AbstractDataEngine.java:210)
>>
>> ...
>>
>>
>>
>> You can have a look to my attached report if you want.
>>
>> Thanks.
>>
>>
>> Jason Weathersby a écrit :
>>> Chris,
>>>
>>> Are you saying if the datasource is used in a crosstab the property
>>> binding doesnt work? What happens if you use a table? then a table
>>> and a crosstab (table first). Also what version of BIRT are you using?
>>>
>>> Jason
>>>
>>> Chris wrote:
>>>> Hi guys,
>>>>
>>>> I am sure you are the best of the best BIRT experts...
>>>>
>>>> Do you know why Property Binding doen't work with crosstabs? It's ok
>>>> with another report items.
>>>>
>>>> In fact I try to use the field "Home Folder" in a Flat file datasource.
>>>>
>>>> If the field "Home Folder" has the value 'C:\test', so it's working.
>>>> But if the field "Home Folder" has a dynamic value like
>>>> 'params["DataSourcePath"].value' , so it's ko !!!
>>>>
>>>> PS : DataSourcePath is a Report Parameters.
>>>>
>>>> The selected folder that contains the flat files is always "C:\test"
>>>> :-(
>>>>
>>>> Thanks in advance.
>>>>
>>
|
|
|
Goto Forum:
Current Time: Thu Sep 19 21:28:55 GMT 2024
Powered by FUDForum. Page generated in 0.03739 seconds
|