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
Birt 2.3.2 Parameters Return Blank Result Set
Migrateduser
I am using BIRT 2.3.2 and am having an issue with getting Parameters to work. I have created report parameters, and added the ? after the where clause in my SQL, but in the Parameters section of the Data Set editor there are no parameters automatically added. When I add my own and bind them to the report parameters I get a blank data set with no errors.<br />
<br />
I have been Googling my brains out trying to figure this out but haven't found a solution. In one of the posts I read someone mentioned moving the where clause into the beforeOpen script, but while I do know where the beforeOpen script is I'm not sure what exactly to put in it.<br />
<br />
The query is such:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
SELECT *
FROM table_one
LEFT OUTER JOIN table_two
ON table_one.ITEMNUM = table_two.ITEMNUM
AND table_one.LOCATION = table_two.LOCATION
AND table_one.COUNTGROUP = table_two.YVR_COUNTGROUP
AND table_one.BINNUM = table_two.BINNUM
AND table_one.LOTNUM = table_two.LOTNUM
AND table_one.ORGID = table_two.ORGID
AND table_one.SITEID = table_two.SITEID
AND table_one.ITEMSETID = table_two.ITEMSETID
WHERE table_one.LOCATION = ?
AND table_one.COUNTGROUP = ?
</pre>
<br />
I replaced the table names with table_one and _two respectively as they are quite long names. I've been stuck on this for a while now. Any help would be greatly appreciated!
Find more posts tagged with
Comments
There are no comments yet