[combined crosstab with simple report]

So, is it possible anyway?

or have you any idea how to solve this?

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

[subdataset parameter]

hey all

i want to pass the parameters to the subdataset queryy to work in crosstabing, but i can`t deal this.

 

then i write this it doesn`t work.i have the blank crosstab with no data

 

test.testdat=to_date($P{Datefrom},'yyyy-mm-dd')

 

but than i write it without parameter

test.testdat=to_date('2007-07-10') it works fine

 

I SOLVED THIS

needed to add the expression $P{Datefrom} into default expression.....

Post edited by: megotronx, at: 2007/07/10 14:34

[combined crosstab with simple report]

put it in summary band...

any ideas of my problem?

[combined crosstab with simple report]

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

[Simple calculations]

then try this:

 

new java.lang.Double( ($F{field_price}.doubleValue()) *($F{quantity}.doubleValue()) )

[Simple calculations]

hi dewie!

 

try this:

 

new java.lang.Integer( ($F{field_price}.intValue()) *($F{quantity}.intValue()) )

[parameter with all values]

Thank you thank you thank you

That is what I wanted :woohoo:

[parameter with all values]

thats fine.But i want to know is at this tool something like wildcard function in other reporting tools.For example i want to search in database for records which starts with N.in other tools Wildcard(N*).

is smthing similar to this? or search all records in database (wildcard(*))????

thanks

 

your suggestion is good.But for example if db is growing with several thousands records a day and to put all values in to array is suicide.any suggestions?

[parameter with all values]

how to pass all values with parameter in query?

for example

 

select x1,x2

from table

where

x1='value'

 

it may be the exact value or all values

Post edited by: megotronx, at: 2007/07/02 12:50

[combined crosstab with simple report]

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

[Display different value using same field and]

no,this doesn`t solved my problem.

with parentheses and with IN syntax i have "this document has no pages" error

anyway i solved this problem

i put the crosstab in the detail section and need in summary :dry:

Post edited by: megotronx, at: 2007/06/28 13:47

[Display different value using same field and]

hey.thank you for helping.I solved the layout problem with crosstabs, but still have a problems with data in it.Instead 3 records i see 3*8=24records.it may be in fact that i have 8 Analys and 3 testno in database.But need to see just that 3 records.My sql in subdataset and in main report are the same:

 

SELECT TESTIN.TESTNO, TESTIN.SERIALNO, TESTIN.ANALYS, TESTIN.ANALYSEX, TESTIN.MEANVAL

FROM TESTIN

where testin.testtype='DOCUMENTS' and

testin.analys='SAL' or

testin.analys='PAV' or

testin.analys='BLANK' or

testin.analys='ID' or

testin.analys='KLANR' or

testin.analys='KLATIP' or

testin.analys='KLAAPR' or

testin.analys='QUANT'

 

Help me to solve this who have more experience with crosstabs

 

Thank you in advance

[Display different value using same field and]

My own problem is:

I have the table

TESTNO ANALYS VALUE

0001 A 20

0001 B 10

0001 C 5

0002 A 17

0002 B 15

0002 C 20

 

and in report i need this:

TESTNO A B C

0001 20 10 5

0002 17 15 20

 

How to put ANALYSES in header and VALUES in detail section

[Display different value using same field and]

have you solved this problem?

I have the same...

[Display different value using same field and]

have you solved this problem?

I have the same...

[how to change the null value]

i wrote your code, checked n+1 times if the blank when null uncheked but i see the blank anyway.have no idea :S

 

moreover, I tried this on other string fields.No one field changed it`s value...and i found out that this field C24 in my example is not nullable.may be it means

if i enter to the code empty string "" that don`t help

so?any ideas?

Post edited by: megotronx, at: 2007/06/14 12:01

[values from field in columnHeader section]

in database i have the fields ANALYS and VALUE

i need to see all Analys in columnHeader section and Value in detail section...

for example:

 

analys1 analys2 analys3

value of analys1 value of analys2 value of analys3

 

analys1,analys2,analys3 are from the same table ANALYS

values are in value field

 

i can`t solve this for several days.Can you help me?

Post edited by: megotronx, at: 2007/06/13 14:08

[how to change the null value]

Thanks but i see just blank field in place where i need to see "0".it doesn`t solved my problem.what`s an idea?

 

new java.lang.String($F{C24} != null ? $F{C24} : "0")

[Report with more than one page]

i have the same problem.How to solve this?

what exactly to do? how to put the columns that doesn`t fit?

[Report with more than one page]

i have the same problem.How to solve this?

what exactly to do? how to put the columns that doesn`t fit?

[Report with more than one page]

i have the same problem.How to solve this?

what exactly to do? how to put the columns that doesn`t fit?

[how to change the null value]

i wrote this ($F{C24} == null ? "0" : $F{C24}) for my report but i see blank field where is null.what to do?

p.s blank when null checkbox is uncheked

[how to change the null value]

i wrote this ($F{C24} == null ? "0" : $F{C24}) for my report but i see blank field where is null.what to do?

p.s blank when null checkbox is uncheked

[sum of strings]

Hey there

I`m new with this reporting tool

So i have database fields with values of strings

(c13,c14,c15,c16)but these string values are numbers.

("3","2","1")

And i need to sum all these fields values.In report i need to see c13+c14+c15=3+2+1=6

 

i created variables with expressions:

$F{C21}==null ? "0" : $F{C21}

and then used the Integer.valueOf($V{c16}) but it doesn`t worked.String and integers conflict

Post edited by: megotronx, at: 2007/06/11 13:05