|
Re: Manipulating Flat File Query [message #534288 is a reply to message #534126] |
Tue, 18 May 2010 15:00 |
|
Tobias,
The flat file datasource does not support where clauses. You have to
use a filter on the dataset. Take a look at this example:
http://www.birt-exchange.org/devshare/designing-birt-reports /1214-flat-file-filter-with-hidden-parameter/#description
Jason
On 5/18/2010 3:44 AM, tobias.koehler1987@googlemail.com wrote:
> Hi,
> I have a Data Set, which uses a .ssv File. Using the beforeOpen script I
> want to add a where clause. However, I cannot change the query further
> than:
> this.queryText = "SELECT * FROM ERP_RM_SALES.ssv"
>
> Even the simplest change leads to the following Error:
> this.queryText = "SELECT * FROM ERP_RM_SALES.ssv where id = '1'"
>
> Chart barChart: + An exception occurred during processing. Please see
> the following message for details:
> Failed to prepare the query execution for the data set: SalesCust
> Failed to prepare the following query for the data set type
> (org.eclipse.datatools.connectivity.oda.flatfile.dataSet). [SELECT *
> FROM ERP_RM_SALES.ssv where id = '1']
> Invalid table
> name:C:\Projects\ReportMgmt\jboss-5.1.0.GA\server\default\co
> nf\REPORTS\data\ERP_RM_SALES.ssv where id = '1'
> What am I doing wrong?
|
|
|
|
Re: Manipulating Flat File Query [message #534571 is a reply to message #534452] |
Wed, 19 May 2010 14:42 |
|
Take a look at
http://www.birt-exchange.org/devshare/designing-birt-reports /1216-adding-filter-to-table-dataset-dynamically/#descriptio n
Jason
On 5/19/2010 5:20 AM, tobias.koehler1987@googlemail.com wrote:
> Thank you!
> The Filter is a nice Feature. Is it also possible to add Filters to a
> Data Set via Script?
> I want to filter the Data Set depending on which Report Parameters are
> filled.
|
|
|
Powered by
FUDForum. Page generated in 0.02490 seconds