select only result is sum=??

[kuekue]

I have some problem, i have a report that i want to show different sum is <>0 and want to some in other group

exsample.

<gh1>
<gh2>
<gh3>
<gh4>
<detail>.....a b
<detail>.....a b
<detail>.....a b
<detail>.....a b
<gf4> sum(a) sum(b)
<gf3> sum(a) sum(b)
<gf2> sum(a) sum(b)
<gf1> sum(a) sum(b)

///////////////////////////////// end exsample /////////////////

but i don't want to show every record i want to show only sum(a)-sum(b)<>0 how to do it?

i can suppress in detail and group footer 4 but when sum in group footer 3, 2 and group footer 1 result is wrong because the sum is summarize in sum(a)-sum(b)=0

are you understand me?? LoL

 

[Turkbear]

Hi,
One way would be to use a Command rather than CR's selection method since with SQL ( assuming your database supports it) to can do the sums first then use them to filter the data. In CR, the summation is done after the records are retreived so they cannot be used to filter/supress before they exist.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

I think you need to clarify when you want sections suppressed. Maybe show examples of results in the various group sections and then indicate what you would want suppressed in each case.

-LB

 

[kuekue]

this problem i can resolve by calculate by my program and keep in temp database and then filter by Crystal Report.