megotronx Posted June 29, 2007 Share Posted June 29, 2007 Is it possible to combine crosstabing with simple report? For example i have 2 tables:First:TESTNO X1 X2 X3 X40001 aa bb cc dd0002 bb cc aa dd 0003 dd aa bb ccSecondTESTNO ANALYS VALUE0001 aa 120001 bb 100002 aa 210002 bb 150003 aa 70003 bb 14 I want to have report like this:TESTNO X1 X2 X3 aa bb0001 aa bb cc 12 100002 ...........................0003 ........................... I can get the last record with crosstabing but i can`t join the info from the first simple table.Is it possible?HOW? Thanks in advance Link to comment Share on other sites More sharing options...
megotronx Posted July 9, 2007 Author Share Posted July 9, 2007 I mean is it possible to write crosstabing query and then use it in another query?for example to write query:TRANSFORM Nothing(VALUE) AS NothingVALUESELECT TESTNOFROM TABLE2GROUP BY TESTNOPIVOT ANALYS save it query1 and then use it in other query: select testno from query1orselect query1.testno, query1.xxx ??? is it possible?and how?thanks Link to comment Share on other sites More sharing options...
kelly Posted July 10, 2007 Share Posted July 10, 2007 Hi, i also have a problem with crosstab. i'm using iReport.i can make a crosstab no problem, but it only show the result when there is only one record. if there are more than one record, it will show:Error filling print... Error incrementing crosstab datasetnet.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:671) 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:652) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:252) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:763) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:669) 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 it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:942) at java.lang.Thread.run(Unknown Source) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:295) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:667) ... 12 more Print was not filled. Try using an EmptyDataSource... anybody knows why this happened?thanks in advance.Post edited by: kelly, at: 2007/07/09 19:08 Link to comment Share on other sites More sharing options...
megotronx Posted July 10, 2007 Author Share Posted July 10, 2007 put it in summary band...any ideas of my problem? Link to comment Share on other sites More sharing options...
kelly Posted July 11, 2007 Share Posted July 11, 2007 you are right. thanks a lot. i'm very new about ireport, i have no idea about your problem....sorry...but i'll try... thanks again. Link to comment Share on other sites More sharing options...
megotronx Posted July 16, 2007 Author Share Posted July 16, 2007 So, is it possible anyway?or have you any idea how to solve this?Post edited by: megotronx, at: 2007/08/01 12:45 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now