Grouping and Record Selection on a Running Total

[SuperTime]

I have a running total field on my report that I want to sort and perform a record selection on ...is it possible...

If not is there any work around...

The running total is a Count of tblLinks.Summary
Evaluated on formula: where tblLinks.Summary like "buyer"
Reseted on: Change of Group: ParentID

please advice
thanks

 

[Turkbear]

Hi,
Since a running total is always changing, you cannot ( as far as I know) use it for that..

What are you trying to accomplish?

What database?Version?Connection type?
What CR version?








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

 

[lbass]

If you don't currently have a group selection formula and your running total is accurate, you should be able to get the same result by creating a conditional formula like {@buyer}:

if {tblLinks.Summary} like "*buyer*" then 1

Right click on this and insert a summary (SUM, not count) at the group level. You can then use a group selection formula (report->selection formula->GROUP), e.g.,

sum({@buyer},{table.groupfield}) > 10

You can also go to report->group sort-> and do a topN or group sort on the summary field.

-LB

 

[SuperTime]

I was successful to change the running total to the formula with the right results....

That solved my problem...now i can sort and have a group selection formula on my report.

You are a genius lbass..kudos to you...


Thank you very much..