[Signature Field(s) Detected - what is that]

Upon further research I have found an answer.  It seems that the geniuses at Adobe put in a "feature" into version 10.0.3 in which it "intelligently" tries to detect if a signature is required.  One of the ways it seems to "intelligently" do this is look for words or fields that contain the string "sign" or "signature".    There is a way to disable this "feature", that involves the registry, but that means I won't see the signature field garbage, but my users will.

I will put this on the list of "if you document a bug, you can call it a feature"

[Signature Field(s) Detected - what is that]

I've created a report that produces a .pdf output.  For for some unknown reason a banner appears which says "Signature field(s) detected".  I did not intentionally add, nor do I want, any signature fields.  In addition, I can't find anything in the jrxml or in iReport Designer that would infer a signature field.  

Can anybody offer any help on this?

Thanks,

Mike

[Javaflow problem with splitted subreport]

And where do we get this jasperreports-javaflow-x.y.z.jar ? I Google, Bing, and Yahoo the name, and I just get this page.

[Show report name in title]

Maybe pass the title as a parameter

[Eliminate page break after subreport]

Not sure if this will help, but I had problems with subreports rendering in a main report and this helped.

In the main report, uncheck "Print when data overflows" for the subreport.  

Also, is it at the beginning or end of a group section?  Check to see if you have the group (or the next group) start on a new page.

[How to use a Comparator - not in a crosstab]

I want to use a Comparator class to sort my report.  I can write the Comparator class with no problem.  My problem (and I have searched and searched this forum and the internet) is how to tell my report to use the Comparator. 

How does the report know to use the comparator?  That is all I want to know.

Thank you in advance.

[Access is denied]

 I have a report with sub reports.  Now, all of a sudden when I run the reports in iReports, I get the following IOException with the explanation of "Access is denied".

If I remove the subreport, the report works fine.  I set and unset the readonly status of the subreport, and I still get the error.  I've closed out iReports and reopened it, and I've rebooted my pc, but I still get this problem.  

Any help would be appreciated.

Thanks,

Mike

Code:

Error filling print... java.io.IOException: Access is denied net.sf.jasperreports.engine.JRRuntimeException: java.io.IOException: Access is denied      at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.virtualizeData(JRAbstractLRUVirtualizer.java:535)      at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer$Cache$LRUScanMap.processRemovedLRU(JRAbstractLRUVirtualizer.java:134)      at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer$Cache$LRUScanMap.removeLRU(JRAbstractLRUVirtualizer.java:120)      at org.apache.commons.collections.LRUMap.put(LRUMap.java:122)      at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer$Cache.put(JRAbstractLRUVirtualizer.java:195)      at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.registerObject(JRAbstractLRUVirtualizer.java:420)      at net.sf.jasperreports.engine.base.JRVirtualPrintPage.<init>(JRVirtualPrintPage.java:176)      at net.sf.jasperreports.engine.fill.JRBaseFiller.newPage(JRBaseFiller.java:1543)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.addPage(JRVerticalFiller.java:1847)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:357)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:263)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:129)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:903)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:813)      at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)      at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:878)      at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)      at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)  Caused by: java.io.IOException: Access is denied      at java.io.WinNTFileSystem.createFileExclusively(Native Method)      at java.io.File.createNewFile(Unknown Source)      at net.sf.jasperreports.engine.fill.JRFileVirtualizer.pageOut(JRFileVirtualizer.java:113)      at net.sf.jasperreports.engine.fill.JRAbstractLRUVirtualizer.virtualizeData(JRAbstractLRUVirtualizer.java:530)      ... 19 more 

[Creating dynamic xls report]

 Will it be the same number of columns for every user?  If so, maybe if you pass your user information to your database, and then have a function call the appropriate table.  Have the values, no matter what the query used, labled as col1, col2, etc.  Then have a function to dynamically generate your column headers.

[Application locks if report is canceled]

I'm currently implementing JasperReports into a J2EE Web Application.  But I've run into a problem. 

I use a servlet to run reports, but if I call a report and close it (close the new window it is appearing in), before the report completes, I can't run any new reports, they just hang, and I have to restart my server.  Annoying and time comsuming while developing, and will be unacceptable in production.  Below is the code I use to call the report. 

Any help will be greatly appreciated.

Code:

 public synchronized void createReport(JasperReportCreatorData jrcd)          throws IOException {      HttpSession session = jrcd.getRequest().getSession();      JRSwapFileVirtualizer virtualizer = null;      Connection conn = null;      JasperReport jasperReport = null;      JasperPrint jasperPrint = null;      boolean isPdf = false;      boolean isXL = false;      boolean isCSV = false;      jrcd.getParameters().get(Reports.STD_REPORT_NAME);      String formatType = (String) jrcd.getParameters().get(Reports.OUTPUT_FORMAT);        if (formatType != null) {            if (formatType.equals(Reports.OUTPUT_FORMAT_STANDARD)) {              isPdf = true;            }             else if (formatType.equals(Reports.OUTPUT_FORMAT_EXPORT)) {              isXL = true;            }             else if (formatType.equals("csv")) {              isCSV = true;            }             else {               System.out.println("bad file type");            }         }         int growthSize = 1024;         int maxSize = growthSize * 2;         long startTime = System.currentTimeMillis();         long readyToExport = 0L;         ServletOutputStream sos = null;         try {            sos = jrcd.getResponse().getOutputStream();            // Put in this code to handle memory problems            JRSwapFile swapfile = new JRSwapFile("tmp/", maxSize, growthSize);            virtualizer = new JRSwapFileVirtualizer(50, swapfile, true);            jrcd.getParameters().put(JRParameter.REPORT_VIRTUALIZER, virtualizer);            // end of new code            conn = OracleDAOFactory.getConnection();            jasperReport = JasperCompileManager.compileReport(jrcd.getInputFile());            jasperPrint = JasperFillManager.fillReport(jasperReport,                  jrcd.getParameters(), conn);            System.gc();            if (isPdf) {               JRPdfExporter exporter = new JRPdfExporter();               jrcd.getResponse().setContentType("application/pdf");               exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, sos);               exporter.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);               exporter.exportReport();             }             else if (isXL) {               JRXlsExporter exporter = new JRXlsExporter();               jrcd.getResponse().setContentType("application/vnd.ms-excel");               String time = Long.toString(System.currentTimeMillis());               String disposition = "attachment; fileName=CDRSSReport" + time               + ".xls";               jrcd.getResponse().setHeader("Content-Disposition", disposition);               exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, sos);               exporter.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);               exporter.exportReport();            }             else if (isCSV) {               JRCsvExporter exporter = new JRCsvExporter();               jrcd.getResponse().setContentType("text/csv");               String disposition = "attachment; fileName=CDRSSReport" + time                     + ".csv";               jrcd.getResponse().setHeader("Content-Disposition", disposition);               exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, sos);               exporter.setParameter(JRExporterParameter.JASPER_PRINT,                     jasperPrint);               exporter.exportReport();            }         }          catch (JRException e) {            System.out.println(e.getClass().getName()                  + " Exception in JasperReportServlet 1");            printHeaderData(jrcd.getRequest());            e.printStackTrace();            session.setAttribute("ErrorInfo", new ReportErrorWrapper(e,                  jrcd.getParameters()));            jrcd.getResponse().sendRedirect("/cdrss/reports/reportError.jsp");         }          catch (OutOfMemoryError e) {            System.out.println(e.getClass().getName()                  + " Exception in JasperReportServlet 2");            printHeaderData(jrcd.getRequest());            e.printStackTrace();            session.setAttribute("ErrorInfo", new ReportErrorWrapper(                  new CDRSException(CDRSErrorCodes.DEFAULT, e.toString()),                  jrcd.getParameters()));            jrcd.getResponse().sendRedirect("/cdrss/reports/reportError.jsp");         }          catch (IllegalStateException e) {            System.out.println(e.getClass().getName()                  + " Exception in JasperReportServlet 3");            printHeaderData(jrcd.getRequest());            e.printStackTrace();            session.setAttribute("ErrorInfo", new ReportErrorWrapper(e,                  jrcd.getParameters()));            jrcd.getResponse().sendRedirect("/cdrss/reports/reportError.jsp");         }          catch (CDRSException e) {            System.out.println(e.getClass().getName()                  + " Exception in JasperReportServlet 4");            printHeaderData(jrcd.getRequest());            e.printStackTrace();            session.setAttribute("ErrorInfo", new ReportErrorWrapper(e,                  jrcd.getParameters()));            jrcd.getResponse().sendRedirect("/cdrss/reports/reportError.jsp");         }          catch (ExceptionConverter e) {            System.out.println(e.getClass().getName()                  + " Exception in JasperReportServlet 5");            printHeaderData(jrcd.getRequest());            e.printStackTrace();            session.setAttribute("ErrorInfo", new ReportErrorWrapper(e,                  jrcd.getParameters()));            // res.sendRedirect("/cdrss/reports/reportError.jsp");         }          catch (Exception e) {            System.out.println(e.getClass().getName()                  + " Exception in JasperReportServlet 6");            printHeaderData(jrcd.getRequest());            if (!e.getClass().isInstance(new IOException())) {               e.printStackTrace();               session.setAttribute("ErrorInfo", new ReportErrorWrapper(e,                     jrcd.getParameters()));               jrcd.getResponse().sendRedirect("/cdrss/reports/reportError.jsp");            }             else {               System.out.println("throwing IOException");                           }         }          finally {            // virtualization.cleanup();            OracleDAOFactory.closeConnection(conn);            try {               sos.close();            }             catch (IOException e) {               System.out.println(e.getClass().getName()                           + " Exception in JasperReportServlet"                           + e.toString());              e.printStackTrace();            }            if (virtualizer != null) {               virtualizer.cleanup();            }        }    }

[Getting Error while calling a report in servlet of java.]

Post the code from the servlet.

[How to display "No records found" message]

Have you tried adding a No Data Section - which includes a message saying "No records found"?

Code:

<noData>  <band height="276">    <textField>      <reportElement positionType="Float" x="0" y="40" width="842" height="20"/>	<textElement textAlignment="Center">	  <font size="12" isBold="true"/>	</textElement>	<textFieldExpression><![CDATA["NO DATA RETURNED"]]></textFieldExpression>    </textField>  </band></noData>

[First record not calculating variable]

Turned out to be a problem with the JDBC Driver (only happened when using a Java Connection object) and using "deterministic" in the function call. 

Weird.

[First record not calculating variable]

 I am sorting my results by a variable, but for some reason,  the variable is not being calculated for  the first record returned. 

Any ideas why this may be happening?

[Problem with Oracle Function and order by]

 Found the cause.  It is due to a bug in Oracle, which limits rows returned when "deterministic" is used.  It has been corrected by Oracle, but we're haven't updated to the newest version in all environments yet.

[Problem with Oracle Function and order by]

 I have a report that gets its data from an Oracle function.  Here is the problem: when I don't  add an Order by after the function call, I get only 10 records.  When I do, I get all the records.

Thanks in advance for any help.

Mike

 

Code:

SELECT   *    from TABLE(cdrss_reports_jasper.getCaseStats(          //all my paramters         )  ) ORDER BY 2,3,4   // works with this in there

[Using Comparator in iReport]

I'm creating a report which the values may need to be sorted by numbers that are returned as text.  For example, the values are

Age 0 to 4
Age 5 to 9
Age 10 to 20

Just letting Jasper sort these as text would mean the last two would be switched, so I need to create a class that implements Comparator .  

No problem with that, but how do I get Jasper to call this class?

I assume this is very basic, but I'm new to using Jasper, having recently escaped from the evil clutches of Crustal Reports.

Thanks in advance for any help.

Mike

[Passing List as a parameter to an Oracle function]

 I'm banging my head on this one.  I'm trying to pass a java.util.List obect to an Oracle function.

I try creating a list like this:

java.util.Arrays.asList({  9502,   9498,   9499,   9501,   9503  }) 

and when I try to run it, I get "Parameter type not supported in query : dis_id java.util.List"

I also have tried to use a oracle.sql.ARRAY, and that doesn't work either.

I can get $X() working if I use a traditional query, but I need it to work with an Oracle function.

Thanks in advance for any help.

 

Mike

[JasperFillManager.fillReport in 4.1.1]

 I see that Jasper Report 4.1.1 is out (downloaded it when I downloaded the new iReport) - does anybody know where the API documentation can be found.  

Was JasperFillManager.fillReport() changed.  With the new version, I'm getting not applicable for arguments (JasperReport, map, Connection).  

Thanks in advance for any help.

[Error in Jasper Compiler 4.1.1? Any one else notice this?]

 I'm having lots of problems since I downloaded iReport 4.1.1.  

In my reports, whereever I was printing an integer, I had to call the toString() method on it for it not to cause a cast error.  

[Sort within a group]

Found a solution

In the edit query dialogue, there is a "sort options" button at the bottom, which allows sorting using Jasper created variables.

[Sort within a group]

 Is there a way to sort the results after they are received or by a variable that is calculated in Jasper?

My query returns data sorted by age, and then county.  I then create a variable for age range, and group by that.  But within each group I then want them sorted by county.  I hope the following explains:

What is returned from db:

• Age 8 - Warren County
• Age 9 - Morris County
• Age 11 - Sussex County

All of these are in the 0 - 14 age category, so that is the way they will be listed in the group.  What I want is:

• Age 9 - Morris County
• Age 11 - Sussex County.
• Age 8 - Warren County

Thanks in advance for any help.

Mike

 

[Access subreport variable from main report]

When are you evaluating the new variable?

[Access subreport variable from main report]

 I noticed one of the last properties of a subreport is return values.  I have you tried using that?

[Creating a .xls file with multiple worksheets]

 I set the float, but some of the stuff in parameters appears twice in the final report if I have the page break in there.  Trying different placements in the order (bring to front, bring to back).  Maybe just a quirk in there.

[Creating a .xls file with multiple worksheets]

The subreports are part of the parameters.  I put the page break in with "Float" for position, and it sort of works right.  The parameters are on a different page, but then a portion of the parameters page is also put on the page with the rest of the data.

I think I'll just put all the stuff on one page.  If I wanted all this aggravation, I would stick with Crystal.