Eclipse Community Forums: BIRT » obtaining of data set parameters from report

Home » Archived » BIRT » obtaining of data set parameters from report

obtaining of data set parameters from report [message #261629]

Mon, 19 November 2007 05:28

Eclipse User

Originally posted by: gr1m.post.cz

Hi
i got in troubles when trying to obtain data set parameters from report
file (.rptdesign).

piece of .rptdesign file:
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.14"
id="1">

<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="MyDataSet" id="17">
<structure name="cachedMetaData">
<list-property name="resultSet">

</list-property>
</structure>
<property name="dataSource">MyDataSource</property>
<list-property name="parameters">
<structure>
<property name="name">ParamNo1</property>
<property name="paramName">Parm_1</property>
<property name="dataType">any</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>

</oda-data-set>
</data-sets>
</report>

I found parameters can be obtained via interface
org.eclipse.datatools.connectivity.oda.design.DataSetParamet ers but im not
able to get pointer to this interface.
Note that i prefer to get parameters NOT using ui components (like
DataSetWizardPage).
Thanks for any advice.

Re: obtaining of data set parameters from report [message #261651 is a reply to message #261629]

Mon, 19 November 2007 07:42

Eclipse User

Originally posted by: gr1m.post.cz

In case someone will fight with the same problem, here is the code i was
looking for:

import java.util.List;
import java.util.logging.Level;

import org.eclipse.birt.core.framework.Platform;
import org.eclipse.birt.report.engine.api.EngineConfig;
import org.eclipse.birt.report.engine.api.IReportEngine;
import org.eclipse.birt.report.engine.api.IReportEngineFactory;
import org.eclipse.birt.report.engine.api.IReportRunnable;
import org.eclipse.birt.report.model.api.OdaDataSetHandle;
import org.eclipse.birt.report.model.api.ReportDesignHandle;

//...

EngineConfig config;
config = new EngineConfig( );
config.setEngineHome("d:\\birt\\runtime\\ReportEngine");
config.setLogConfig("d:\\temp", Level.FINE);

try
{
Platform.startup(config);
}
catch(Exception e)
{
return;
}
IReportEngineFactory factory;
IReportEngine engine;
IReportRunnable report;
factory = (IReportEngineFactory) Platform.createFactoryObject(
IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY );
engine = factory.createReportEngine(config);
report = null;
try
{
report =
engine.openReportDesign("d:\\birt\\reports\\test_report.rptdesign ");
}
catch(Exception e)
{
return;
}

ReportDesignHandle hReport;
hReport = (ReportDesignHandle)report.getDesignHandle();

List<OdaDataSetHandle> dataSets;
dataSets = hReport.getAllDataSets();
for(OdaDataSetHandle ds : dataSets){
System.out.println(String.format("Data set name: %s", ds.getName()));
}

regards
grim

Previous Topic:	createFactoryObject returns null
Next Topic:	IResultMetaData.getColumnLabel(int index) does not return display name

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Sep 13 05:44:27 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter