geethapriya1987

Closing this question as the parameters are working fine. What I had was a data issue. Thanks!

Hi Sanbez, The order is as you said, the where clause is defined before the From and To docno in the subreport as below. <parameter name="P_WHERECLAUSE1" class="java.lang.String"/> <parameter name="P_FROMDOCNO" class="java.lang.String"/> <parameter name="P_TODOCNO" class="java.lang.String"/>

Hi, I have a parent report with a dynamic where clause, which is passed as $P!{WHERE_CLAUSE}, and the where clause in turn contains $P{} parameters Eg: $P!{WHERE_CLAUSE}=> where docno between $P{P_FROMDOCNO} and $P{P_TODOCNO} Values for $P{P_FROMDOCNO} and $P{P_TODOCNO} are also passed in the same execution The parent report has a subreport, that summarizes based on certain category, whose query is based on the parent's where clause. select vat,sum(amt) from tablename $P!{WHERECLAUSE} order by vat So the where clause is passed to the sub-report using parameter mapping. But the subreport fails to read $P{P_FROMDOCNO} and $P{P_TODOCNO} values from the parent, resulting in empty document. All the above parameters have been mapped to the subreport parameters. The main goal is to fire the query in the database with bind parameters, even for the sub reports. Kindly let me know if any solution for the above. Thanks in advance, Geetha

Got it! in the master report.. Thanks so much :)

Hi, Where should I set the parameter? in the master report, detail report or the text field that has the hyperlink? Thanks

Hi, I have a drill down report of list of order details with a hyperlink on the order_id. And on clicking the hyperlink, I display another report with few more additional details. But I want the second report to open in a new tab/window so that the user can choose to close it and continue to read the first report. How to accomplish this? Is there any parameter that has to be set for the same? Thanks in advance

Hi @hozawa, I dont think we are using the commercial version. Just the community edition. So there is no other way to implement it in non-commercial ones? Thanks

Hi, I have a requirement in Jasper Reports. The user wants to dynamically select a set of columns, or a set of rows in the published report in the browser to calculate any aggregate like sum, count, etc(similar to Excel). I am currently using Jaspersoft Studio and Jasper Reports Server v6.0.1. I cant find much help in my internet research and not sure if this is doable.Is this possible to achieve, If so can you please guide me through. Thanks

Hi, Can someone help me understand when to use CSS for Jasper reports and when to use JRTX? Which is more recommended and is it possible to convert a CSS file to JRTX format? Is CSS strictly for browser mode of the reports, if not, will it be properly applied to report,when we export to PDF or excel format. Also if you have any useful links for the same, kindly let me know. Thanks in advance