Cross tab - Relationship between values
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Cross tab - Relationship between values
Hi
I need your help with cross tab.
I have two value in summary field and I need to make relationship between values. I'll explain better: value1 / value2.
Value1 is a sum of field "minute", value2 is a count of field "person". So I'd like to have a relationship to obtain How many minutes employ a person for a given activity.
thanks in advance
best regards
I need your help with cross tab.
I have two value in summary field and I need to make relationship between values. I'll explain better: value1 / value2.
Value1 is a sum of field "minute", value2 is a count of field "person". So I'd like to have a relationship to obtain How many minutes employ a person for a given activity.
thanks in advance
best regards
Re: Cross tab - Relationship between values
Hello.
You could use next code in the ProcessCell event of the cell.
Please, look at the attached report template.
Thank you.
You could use next code in the ProcessCell event of the cell.
Code: Select all
if (Cells[0,-1]> 0)
e.Value = Cells[0,-2] / Cells[0, -1];
else
e.Text = "NONE";
Thank you.
- Attachments
-
- CrossTabProcessCell.mrt
- (15.46 KiB) Downloaded 391 times
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Re: Cross tab - Relationship between values
Good evening. Thank you for the answer, we have correctly populated the cell.
Anyway, we've seen that the cell's totals are not correctly calculated: we've used your report as example with the datasource "demo.xml" present in Stimulreport installation.
In the attached files we've put in square red the total cells not correctly calculated: Thank you.
Anyway, we've seen that the cell's totals are not correctly calculated: we've used your report as example with the datasource "demo.xml" present in Stimulreport installation.
In the attached files we've put in square red the total cells not correctly calculated: Thank you.
Re: Cross tab - Relationship between values
Hello, Fabio.
It's possible to hide these Totals. Or you need to show something there.
Could you specify this moment?
Thank you.
It's possible to hide these Totals. Or you need to show something there.
Could you specify this moment?
Thank you.
- Fabio Pagano
- Posts: 355
- Joined: Mon Apr 16, 2007 12:38 pm
- Location: Bari (Italy)
Re: Cross tab - Relationship between values
Hello,
I'd like to see in column TOTAL the average of TOTAL.
thanks
I'd like to see in column TOTAL the average of TOTAL.
thanks
Re: Cross tab - Relationship between values
Hello,
We need some additional time to prepare a code for your task.
Thank you.
We need some additional time to prepare a code for your task.
Thank you.
-
- Posts: 4
- Joined: Thu Feb 04, 2021 9:40 pm
Re: Cross tab - Relationship between values
Hello
Did you get a response for this problem?
Thank you
D
Did you get a response for this problem?
Thank you
D
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Cross tab - Relationship between values
Hello,
You can use the ProcessCell event of the cell for such tasks.
Thank you.
You can use the ProcessCell event of the cell for such tasks.
Thank you.