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
Not able to bind Data in BIRT report parameters
Migrateduser
Hi,
I am not able to bind report parameter property. actually i cannot see the option which is given in tutorial provided by eclipse.
my query is like
SELECT (CPD.INITIAL_AMOUNT_MANDA + CPD.FUNERAL_EXPENSES_LA), CD.EVENTDATE,
CD.CLAIMTNOTIFICATIONDATE, CD.DEATHCLASSIFICATION, CD.REMARKS,
CPD.INITIAL_AMOUNT_MANDA, CPD.FUNERAL_EXPENSES_LA, MNM.NGO_CUSTOMER_ID,
P.POLICY_START_DATE
FROM CLAIMDETAILS AS CD, CLAIM_PAYMENT_DETAILS AS CPD,
MBA_NGO_MAPPING AS MNM, POLICY AS P
WHERE CD.INITIALCLAIMPAYMENTSTATUS = 'Paid' AND CD.CUSTOMERID = CPD.CUSTOMER_ID
AND CD.CUSTOMERID = MNM.MBA_CUSTOMER_ID
AND CPD.CUSTOMER_ID = MNM.MBA_CUSTOMER_ID AND CD.CUSTOMERID = P.CUSTOMER_ID
AND P.CUSTOMER_ID = MNM.MBA_CUSTOMER_ID AND P.POLICY_TYPE = 'Mandatory'
AND P.POLICY_START_DATE > ?
please refer attached screenshot
Thanks
Rajat
Find more posts tagged with
Comments
There are no comments yet