megotronx
-
Posts
24 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by 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
-
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
-
put it in summary band... any ideas of my problem?
-
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
-
then try this: new java.lang.Double( ($F{field_price}.doubleValue()) *($F{quantity}.doubleValue()) )
-
hi dewie! try this: new java.lang.Integer( ($F{field_price}.intValue()) *($F{quantity}.intValue()) )
-
Thank you thank you thank you That is what I wanted :woohoo:
-
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?
-
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
-
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
-
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
-
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
-
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
-
have you solved this problem? I have the same...
-
have you solved this problem? I have the same...
-
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
-
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
-
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")
-
i have the same problem.How to solve this? what exactly to do? how to put the columns that doesn`t fit?
-
i have the same problem.How to solve this? what exactly to do? how to put the columns that doesn`t fit?
-
i have the same problem.How to solve this? what exactly to do? how to put the columns that doesn`t fit?
-
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
-
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
-
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
