dching

I'm using Jasper IReport builder 5.6. I have a report with a query of below where I just return record. select 1 from dual; On my detail band I aded a table componenet with query below and grouping of deptno select * from emp On the dept no group header I added a table component with query of select * from dept where deptno >= $F{deptno} Basically for the group heading I need to print 1 or many rows (this is a unique requirements of mine). This works ok but I need to pass a parameter from the detail dataset to the dept dataset (dept group heading with table). If I add the parameter below to my data set I get an error. Please Note Dataset ServiceMeter = Dept in my example above. Error filling print... net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $P{pSID} net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $P{pSID} at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:809) I did verify that the pSID parameter is on the dataset and all the queries including the main has parameter of pSID. Thanks

I'm using JR Sutdio 6.2 community and basically I need a report with a master(dept) -> detail (emp) -> sub-detail (emp_job_history). I'm hoping I can do this with just datasets so I do not need to create 3 reports( 1 master and 2 sub reports). I know how to create a master and detail using sub dataset. Is this possible create a 3rd dataset but link it to the sub-dataset instead of the master dataset? Thanks in advance!

Hi, I'm using JR studio 6.2 community and JR server 6.2 community. I created a new report that uses the PL/SQL sys_refcursor and it works fine on the studion. When I try to add this report to the server I get the error below Caused by: net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the "plsql" language. at net.sf.jasperreports.engine.util.JRQueryExecuterUtils.getExecuterFactory(JRQueryExecuterUtils.java:115) at net.sf.jasperreports.engine.design.JRDesignDataset.queryLanguageChanged(JRDesignDataset.java:1231) at net.sf.jasperreports.engine.design.JRDesignDataset.setQuery(JRDesignDataset.java:686) at net.sf.jasperreports.engine.design.JasperDesign.setQuery(JasperDesign.java:837)

I have a simple master detail report where i'm using data set for the detail.. This report works ok then I added a new parameter with a default value of Y. i want to add a print expression for the data set to say if this new parameter = n then do not print the details. EQUALS($p(pPrintDetails),"N") The expression above is resulting to "Error evaluating expression for source text: Y Thanks

Hi, I have a simple report based on emp table. On the page header I want to print a heading example "XYZ Company". My issue is this heading is based on a stored function in Oracle DB example CREATE OR REPLACE FUNCTION get_company name RETURN varchar2 IS BEGIN RETURN 'XYZ Company' END; User defined epxression in IReport but it seems to be based on java class Adding this function to the main query seems overkill not to mention I have to create a view or table type to include it. Is there a simple straightforward way to do this? Thanks in advance