| Cross Tab export to dataSet [message #903625] |
Fri, 24 August 2012 11:10  |
 SHENG HUANG
Messages: 17
Registered: August 2012 |
Junior Member |
|
|
I've some problems with the calculation in the cross tab.
1. I need to calculate a difference between deux types de colonnes.
2. I need also to calculate a difference between deux lignes.
For example,
OK | KO
Jan N1_OK | N1_KO
Fev N2_OK | N2_KO
I want to calcul the difference between the number of OK et KO (For example N1_OK-N1_KO)
I want to calul the difference avec the month above. (For example N2_KO-N1_KO)
I don't find how to do it with the option "Add derive mesure". If it's possible, can someone help me?
Is it possible to export the result of the cross tab in a dataSet which i can do many types the calcul and configure the presentation of my table more simplely?
Thank you in advance
HUANG Sheng
|
|
|
|
| Re: Cross Tab export to dataSet [message #903920 is a reply to message #903642] |
Mon, 27 August 2012 05:43  |
SHENG HUANG
Messages: 17
Registered: August 2012 |
Junior Member |
|
|
Thanks for your reponse.
I actuaully use the version 2.3 of BIRT and I will test the new version later.
But is it possible to export the result of the crossover table into a dataSet?
(This can help me to manipulate it easier in both presentation and calculation)
HUANG Sheng
|
|
|
|
| Re: Cross Tab export to dataSet [message #908010 is a reply to message #904031] |
Tue, 04 September 2012 10:42 |
SHENG HUANG
Messages: 17
Registered: August 2012 |
Junior Member |
|
|
Have you an example/a link of the case to write a crosstab script, please?
I'm argee that to do something like this is not clean. The version of the BIRT that I use can't be changed recently, so I'll try it anyway.
Thanks again.
HUANG Sheng
|
|
|
|
| Re: Cross Tab export to dataSet [message #910900 is a reply to message #908051] |
Mon, 10 September 2012 11:32 |
SHENG HUANG
Messages: 17
Registered: August 2012 |
Junior Member |
|
|
I've exported a example of the data in the csv file and here's a example of rptdesign that I've realised.
My original purpose is to add one or more rows to calculate the difference between "PREVUE" and "REALISE" and also the percent of the total "REALISE" for every month. Avec version 2.3 of the BIRT, it's not easy.
Actually, I've to get every data in a global variable avec a dataSet different and calculate the table manually. I'm looking for a solution in cross tab because i've got similar report to make and I've got much more the data which i can no more do it manually.
If I can construct a dataSet avec a cross tab, this can help me much to progress in the subject.
I'm also open for other advices.
Thank you.
HUANG Sheng
[Updated on: Mon, 10 September 2012 11:36] Report message to a moderator |
|
|
|
| Re: Cross Tab export to dataSet [message #911226 is a reply to message #910992] |
Tue, 11 September 2012 03:59 |
SHENG HUANG
Messages: 17
Registered: August 2012 |
Junior Member |
|
|
Here's the report that I've previewed and exported in format .doc.
I've seen the difference is always that of the totals but not of every month.
I don't know if this is because of the version of the BIRT, but it doesn't work actually on my pc.
HUANG Sheng
|
|
|
|
| Re: Cross Tab export to dataSet [message #911792 is a reply to message #911405] |
Wed, 12 September 2012 06:30 |
SHENG HUANG
Messages: 17
Registered: August 2012 |
Junior Member |
|
|
It works well with this expression. Thank you.
But I need to do more  .
1. I need a difference cumulative which means the month of February shoule add the number of the January and so on for the rest.
I tried this :
if( data["TYPE"] == "PREVUE" ){
gblprev += data["NB_Group/month_Group2/TYPE"];
data["NB_Group/month_Group2/TYPE"];
}else{
gblprev = gblprev-data["NB_Group/month_Group2/TYPE"];
gblprev;
}
After declare gblprev in the initilize script, it looks like OK.
Another problem is that how BIRT order those datas, why "PREVUE" is showed before "REALISE"? Can I change this order? And does the expression depends also on the order?
2. And I need also two rows which caculates the total of the "REALISE" (the sum of all the critique 0 and 1) and "PREVUE" for every month, i've tried several times sub Totals and grand Totals, none of them works as I wished. Can you also help me on this subject?
3. At last, the presentation problem, how can I make the title "diff" in the same line of type and cache compeletely the empty row in the "PREVUE" row properly?
Here's in the attached doc a example that I'm looking for. (I also want to change the order of REALISE and PREVUE if possible.)
HUANG Sheng
[Updated on: Wed, 12 September 2012 09:35] Report message to a moderator |
|
|
|
|
|
| Re: Cross Tab export to dataSet [message #915404 is a reply to message #913077] |
Mon, 17 September 2012 04:00 |
SHENG HUANG
Messages: 17
Registered: August 2012 |
Junior Member |
|
|
What a pity! Almost, all the data is OK, but it's strange to have a empty row in the report. As I indicate above, the version of BIRT can't be changed recently in my situation.
How about my initial idea, to export all the data of the cross table in to a array and re-organzied the presentation in another dataSet, is it possible?
HUANG Sheng
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03125 seconds
] 
Search
Help
Register
Login
Home
, I meant the empty column.