DBCross agregation problem

waletko

Hello! I have Dataset

<!--sql--><div class='sqltop'>SQL</div><div class='sqlmain'><!--sql1--><span style='color:blue;font-weight:bold'>select</span> 1 <span style='color:green'>as</span> sensor, <span style='color:red'>'test1'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 1 <span style='color:green'>as</span> sensor, <span style='color:red'>'test1'</span> <span style='color:green'>as</span> name, 4 <span style='color:green'>as</span> minval, 6 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 1 <span style='color:green'>as</span> sensor, <span style='color:red'>'test1'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 3 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 1 <span style='color:green'>as</span> sensor, <span style='color:red'>'test2'</span> <span style='color:green'>as</span> name, 1 <span style='color:green'>as</span> minval, 2 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 2 <span style='color:green'>as</span> sensor, <span style='color:red'>'test1'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 2 <span style='color:green'>as</span> sensor, <span style='color:red'>'test1'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 2 <span style='color:green'>as</span> sensor, <span style='color:red'>'test2'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 2 <span style='color:green'>as</span> sensor, <span style='color:red'>'test2'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 2 <span style='color:green'>as</span> sensor, <span style='color:red'>'test2'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 2 <span style='color:green'>as</span> sensor, <span style='color:red'>'test3'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 3 <span style='color:green'>as</span> sensor, <span style='color:red'>'test1'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 4 <span style='color:green'>as</span> sensor, <span style='color:red'>'test3'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 5 <span style='color:green'>as</span> sensor, <span style='color:red'>'test3'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 5 <span style='color:green'>as</span> sensor, <span style='color:red'>'test3'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 6 <span style='color:green'>as</span> sensor, <span style='color:red'>'test1'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 6 <span style='color:green'>as</span> sensor, <span style='color:red'>'test1'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 6 <span style='color:green'>as</span> sensor, <span style='color:red'>'test1'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 6 <span style='color:green'>as</span> sensor, <span style='color:red'>'test3'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval
union all
<span style='color:blue;font-weight:bold'>select</span> 6 <span style='color:green'>as</span> sensor, <span style='color:red'>'test2'</span> <span style='color:green'>as</span> name, 0 <span style='color:green'>as</span> minval, 1 <span style='color:green'>as</span> maxval <!--sql2--></div><!--sql3-->

and CrossTab with 1 row (sensor), 1 collumn(name) and 2 cells (min)minval and max(maxval)
After report generates i see that cells minval and maxval are accumulated instead of MIN and MAX
Am i doing something wrong or there is problem with TfrxCrossTabView? Or maybe i dont understand crosstab?