|
Re: BIRT 4.2 Default Value for Dataset Input parameter is not working [message #896234 is a reply to message #896081] |
Tue, 17 July 2012 16:28 |
|
Try changing this:
and SITE_CODE = '?'
to
and SITE_CODE = ?
Jason
On 7/17/2012 4:21 AM, Rama Krishna wrote:
> Im using the latest version of the BIRT All in one 4.2. The below query for the data set works fine with the value for SITE_CODE as '230'.
>
> select SITE_CODE, TRANSACTION_ID, SERIAL_NUMBER from status_header
> where STATUS = '120'
> and COMPLETE_DATE = '20120716'
> and SITE_CODE = '230'
>
> However when the query is modified as below to receive the SITE_CODE as Input by adding he Dataset Input parameter of String type with the same Default Value as 230, the Preview Results of the data set is not showing any results
>
> select SITE_CODE, TRANSACTION_ID, SERIAL_NUMBER from status_header
> where STATUS = '120'
> and COMPLETE_DATE = '20120716'
> and SITE_CODE = '?'
>
> I'm not linking the parameter to any Report Parameter as the basic feature of default value is not working.
>
> Please let me know the issue. Im not able to use Dynamic queries linking the Data Set parameters with Report Parameters as Default value for Data set parameter itself is not working.
>
> Appreciate your help.
>
|
|
|
|
Re: BIRT 4.2 Default Value for Dataset Input parameter is not working [message #896245 is a reply to message #896240] |
Tue, 17 July 2012 17:03 |
|
Yes they are supported. What data source are you using?
Jason
On 7/17/2012 12:55 PM, Rama Krishna wrote:
> I changed '?' to ? removing the quotes in the query but now it gives sql error (Cannot get parameter type, Unsupported feature) :
>
> org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
> Failed to prepare the query execution for the data set: Outbound Site Data Set
> Cannot get the type for parameter: 1.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get parameter type.
> SQL error #1:Unsupported feature ;
> java.sql.SQLException: Unsupported feature at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
>
> Please find the detailed error message attached.
>
> Are String types for dynamic parameters not supported by BIRT?
>
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.02824 seconds