Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Crosstab in a subreport
Migrateduser
I'm having issues passing parameters to a cross tab that's in a sub report. In my sub report I try the following in the open method:
subDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
subDataSet.open();
var sqlText = new String();
sqlText = "select siteid, location, worktype, status, wonum, workorderid from workorder"
+ " where istask = 0 and rownum < 10 and historyflag = 0 and siteid = '" + rows[0]["siteid"] + "'"
;
subDataSet.setQuery(sqlText);
The rows[0]["siteid"] should get the siteid from the parent query but it doesn't seem to be working properly. Has anyone had this issue?
Find more posts tagged with
Comments
There are no comments yet