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 Parameters - Named
Migrateduser
<p>Hello</p><p>i am creating a BIRT report where i want to use 2 parameters for 3 union select statements.</p><p>EX:</p><p>select * ......... where office_id=? and loan_officer_id=?</p><p>union</p><p>select * ......... where office_id=? and loan_officer_id=?</p><p>union</p><p>select * ......... where office_id=? and loan_officer_id=?</p><p> </p><p>usually i used to create 6 params to map these parameters even though they are only 2 parameters the office_ID and loan_officer_id</p><p>i am new to the scripting part of BIRT, is there a way to use the beforeopen in BIRT and have the same query written but with named parameters? like officeID and loanofficerID as parameters?</p><p>and how to map them?</p><p> </p><p>thanks</p><p> </p>
Find more posts tagged with
Comments
There are no comments yet