Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » BIRT Data Engine(Get Dataset Query)
BIRT Data Engine [message #1753430] Mon, 06 February 2017 11:32
David Good is currently offline David GoodFriend
Messages: 41
Registered: September 2012
Member
Hi,

I am attempting to gather a .rptdesign query using the data engine.

I am referencing the design and data set. I can get the query text using the following:

	private String getDSQuery(IReportRunnable runnable) throws BirtException {

		ReportDesignHandle designHandle = (ReportDesignHandle) runnable.getDesignHandle();
		DataSetHandle dset = designHandle.findDataSet(DATA_SET);
		return (String) dset.getProperty("queryText");
	}


This is fine but when the query is more dynamic and uses either the data set's beforeOpen method or data set's property binding to create SQL on the fly the getProperty("queryText") does not execute the scripts first.

I am guessing that I need to use a run task or similar first??

Can someone who has handled this task before please point me in the right direction?

Many thanks,
David
Previous Topic:Can't SUM the Measures in a cross tab
Next Topic:labels on x axis depending on time range not data points
Goto Forum:
  


Current Time: Fri Apr 19 20:37:45 GMT 2024

Powered by FUDForum. Page generated in 0.02255 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top