drizzt321

UPDATE: So using the main DataSet doesn't appear to work, but when I create another data set (a sub dataset really) and use the same query it populates just fine and outputs everything just the way it is supposed to. Is this a bug in JasperReports or in iReports for not specifying something correctly?

Balaj, Thank you for the reply, but your suggestion did not work. In the NB Standalone (v3.1.0) there is no property anywhere on the cross tab that says "Use dataset to fill the crosstab". I also installed the regular v3.0.0 and tried using it in there (which does have the property), and with it checked I still get the exact same error. I am attaching the .jrxml file itself, and the only change I made was to obfuscate the inner SELECT statement. Please take a look and let me know what, if anything, is wrong.

So I've made a few posts already, had none of my questions answered, but I understand not everyone is browsing the forums all of the time. So how about a few general questions that I have? 1) I have the book copy of Definitive Guide to iReport and I notice in the Introduction it says it is applicable to version 2.0.0. I've used it none the less on 3.0.0 and NB standalone v3.1.0 and found it still somewhat helpful. Is there an updated version to at least 3.0 or, more useful, NB 3.1? 2) In NB standalone 3.1 I'm looking for the built-in scriptlet editor, but it doesn't seem to exist, or at least I can't find it anywhere. 3) In NB standalone 3.1 where/how do I add/create my own templates in a similar fashion to the included Classic template? I've tried following the directions in the Definitive Guide as best I can, but no luck at all. 4) Is there any significant documentation online? I've found virtually nothing of any use other than trying to search the forums. 5) Is there any kind of IRC group for JasperReports or iReport? So those are my more general questions, here is my more specific questions including a few new ones. 6) In NB standalone 3.1 I've tried creating a crosstab, but it keeps dying whenever I try and run it with the following error. I can include the stack trace if necessary. Error filling print... Error incrementing crosstab dataset net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset 7) How would I create a DataSet that I can fill with data from the main DataSet. For example the top 20 which can then be displayed in a Chart as part of the Summary band. 8) I've tried to create a sub-report in order to pull a few different bits of information back into the Title page (based off one of the parameters), but I get absolutely nothing printed out when I run the report. No errors, nothing. When I run it as its own report (Its a separate .jrxml file) it runs and returns just fine, the exact data it should have. I look forward to any help/advice/pointers that anyone can give me. Just for background, I'm an experience Java coder with additional background in PHP and mySQL so I'm not afraid to get my hands dirty (dig into some code) if thats what it takes.

Cross tabs are there, you have to create a new report (or through the Wizard) and drag the Crosstab from the ReportElements Palette onto your report.

So I have iReport 3.1.0 NB Standalone version installed, and I am trying to create a crosstab off of a SQL query that returns 3 fields. Field1 is the row name, Field2 is the column name, and Field3 is the actual data to go into the Detail cells. I go through the Crosstab wizard, everything seems to fit in fine. I look at the different cells and see things are mostly fine, and try and run a preview. Well, I keep getting Error filling print... Error incrementing crosstab dataset net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:666) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:152) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:682) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:275) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:889) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:792) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:890) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:296) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:662) ... 13 more Print not filled. Try to use an EmptyDataSource... I did notice that the Measure that was automatically created was doing a Count, which I actually want it to just contain the actual value since what is returned as Field3 from my query is exactly what I want to be put there, so I changed the Calculation to Nothing. Still no luck running, I get the exact same stack trace as above. Someone please help! If need be I can run this as a NB module in debug mode to try and trace through some stuff if you like.

So I have iReport 3.1.0 NB Standalone version installed, and I am trying to create a crosstab off of a SQL query that returns 3 fields. Field1 is the row name, Field2 is the column name, and Field3 is the actual data to go into the Detail cells. I go through the Crosstab wizard, everything seems to fit in fine. I look at the different cells and see things are mostly fine, and try and run a preview. Well, I keep getting Error filling print... Error incrementing crosstab dataset net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:666) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:152) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:682) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:275) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:889) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:792) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:890) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:296) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:662) ... 13 more Print not filled. Try to use an EmptyDataSource... I did notice that the Measure that was automatically created was doing a Count, which I actually want it to just contain the actual value since what is returned as Field3 from my query is exactly what I want to be put there, so I changed the Calculation to Nothing. Still no luck running, I get the exact same stack trace as above. Someone please help! If need be I can run this as a NB module in debug mode to try and trace through some stuff if you like.

I basically have the same question as OP, and your reply doesn't help me much unfortunately. I'm using the NB Standalone version 3.1.0 and I have The Definitive Guide to iReport (paper edition) and I'm looking in Chapter 12 under the Custom Templates section. I see where it says I can the MyTemplate[C|T].xml files into the templates directory, except I don't know where the templates directory is!! I have placed the files in the $HOMEApplication Data.ireportdevconfigTemplates directory and still couldn't get access to them via the Report Wizard. I have also tried adding them through Tools->Templates and hitting Add... and placing them in the Report folder. Still no luck, even after restarting iReport. I have found that documentation for iReport, especially for the new NB version (standalone or module) is pretty skimpy, especially for basic things like this. I want to use iReport and JasperReports, but right now it seems to be pretty hard for me to figure out how to do what I would consider to be basic things. Is there any real effort to try and improve the state of the documentation?