Eclipse Community Forums: BIRT

Home » Archived » BIRT » Parameters(Parameters)

Tue, 09 August 2011 14:13

Eclipse User

I have created a Web project that uses Java to build a Birt Report. I am using the OdaDataSourceHandle and OdaDataSetHandle to retrieve my data. I have placed a prepared statement in the setQueryText(sql) of my OdaDataSetHandle. When I run my report I get a Parameter 1 could not be found error. For the life of me I am unable to get the Parameter 1 populated with a value. Does anyone know how I can populate the Parameter 1 in Java Code?

Thanks for the help and your time in advance,

Marc

Re: Parameters [message #714073 is a reply to message #714067]

Tue, 09 August 2011 14:33

Eclipse User

I forgot to say that the odaDataSetHandle is then placed in a ReportDesignHandle object.

Thanks again,

Marc

Re: Parameters [message #714121 is a reply to message #714067]

Tue, 09 August 2011 16:34

Eclipse User

Is this a dataset parameter or a report parameter?
For a report parameter set it like:
task.setParameterValue("Top Count", (new Integer(5)));

If you are using the DE API to add a dataset parameter you could do:

OdaDataSetHandle dsHandle = designFactory.newOdaDataSet( "ds2",
"org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" );
dsHandle.setDataSource( "Data Source" );
String qry = "Select * from orderdetails where ordernumber = ?";

dsHandle.setQueryText( qry );
designHandle.getDataSets( ).add( dsHandle );
OdaDataSetParameter parameter =
StructureFactory.createOdaDataSetParameter();
parameter.setName( "param1" );
parameter.setPosition(1);
parameter.setDataType("integer");
parameter.setAllowNull(true);
parameter.setDefaultValue("10105");
parameter.setIsOptional(false);
parameter.setIsOutput(false);
parameter.setIsInput(true);

PropertyHandle parameterHandle = dsHandle.getPropertyHandle(
DataSetHandle.PARAMETERS_PROP );
parameterHandle.addItem( parameter );

If you have the dataset handle you can set the first ds parameter like"

PropertyHandle parameterHandle = dsHandle.getPropertyHandle(
DataSetHandle.PARAMETERS_PROP );
OdaDataSetParameterHandle dsp =
(OdaDataSetParameterHandle)parameterHandle.get(0);
dsp.setDefaultValue("10101");

If the dataset parameter is linked to a report parameter, just set the
report parameter.

Jason

On 8/9/2011 2:13 PM, marc.marshall wrote:
> I have created a Web project that uses Java to build a Birt Report. I am
> using the OdaDataSourceHandle and OdaDataSetHandle to retrieve my data.
> I have placed a prepared statement in the setQueryText(sql) of my
> OdaDataSetHandle. When I run my report I get a Parameter 1 could not be
> found error. For the life of me I am unable to get the Parameter 1
> populated with a value. Does anyone know how I can populate the
> Parameter 1 in Java Code?
>
> Thanks for the help and your time in advance,
>
> Marc

Re: Parameters [message #714412 is a reply to message #714121]

Wed, 10 August 2011 09:49

Eclipse User

Jason,

Thanks for the help, that code worked!

Thanks again,

Marc

Previous Topic:	AxisFault for Web Service data source
Next Topic:	Re: Enabling study layout in JavaScript generated axes

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 12:44:18 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter