nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Not able to bind Data in BIRT report parameters

RajatAgarw

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

RajatAgarw

Please reply me on rajat.agarwal@infrasofttech.com
I need urgent help..please somebody help..

Thanks
Rajat

kclark

Have you gone to the parameters page while editing your data set?<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>AND P.POLICY_START_DATE > ?</pre>
<br />
Should create an empty parameter there, you can select what parameter to check against.

RajatAgarw

Thanks for your reply.
Now i am able to do it.

Thanks
Rajat

RajatAgarw

Hi,

I have one more doubt.
See i am using Struts application with tiles.
In my main body of tiles i have written one jsp from where i am calling my BIRT report.
code below
<body>

<birt:viewer id="birtViewer" reportDesign="/reports/Test_Report.rptdesign"
showParameterPage="true"
pattern="frameset"
height="200"
width="300"
format="html"
isHostPage="true"
showTitle="true">
</birt:viewer>
</body>

Now the problem is when i am clicking on my sub menu it is opening BIRT viewer in NEW window but i want it to be displayed in main body of my tiles of my jsp.

please help me.
also plz mark a reply on my mail rajat.agarwal@infrasofttech.com

Thanks
Rajat Agarwal