combined crosstab with simple report

[megotronx]

Is it possible to combine crosstabing with simple report? For example i have 2 tables:

First:

TESTNO X1 X2 X3 X4

0001 aa bb cc dd

0002 bb cc aa dd

0003 dd aa bb cc

Second

TESTNO ANALYS VALUE

0001 aa 12

0001 bb 10

0002 aa 21

0002 bb 15

0003 aa 7

0003 bb 14

 

I want to have report like this:

TESTNO X1 X2 X3 aa bb

0001 aa bb cc 12 10

0002 ...........................

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

[megotronx]

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 NothingVALUE

SELECT TESTNO

FROM TABLE2

GROUP BY TESTNO

PIVOT ANALYS

save it query1 and then use it in other query:

 

select testno from query1

or

select query1.testno, query1.xxx ???

 

is it possible?and how?

thanks

[kelly]

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 dataset

net.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

[megotronx]

put it in summary band...

any ideas of my problem?

[kelly]

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.

[megotronx]

So, is it possible anyway?

or have you any idea how to solve this?

Post edited by: megotronx, at: 2007/08/01 12:45