Group by formula

[acessn]

Using cr 9.0, mssql database

In my database, I have a view VP_PERSON.

I have grouped on VP_PERSON.HOMELABORACCOUNT, which works just fine.

Now what I need to do is to have to groups. One where VP_PERSON.HOMELABORACCOUNT=["536", "456"] and one which contains VP_PERSON.HOMELABORACCOUNT=["444","577"].

What I have tried to do is to group by formula:

VP_PERSON.HOMELABORACCOUNT=["536", "456"] but that won't work.

I need to display totals in each group footer which is a piece of cake if I can get the actual grouping to work..

Suggestions are very welcome.

Thanks,

Bjorn

 

[campsys]

Check out thread 767-1012607 titled Easy Grouping Question

http://www.tek-tips.com/viewthread.cfm?qid=1012607

It explains grouping in clusters by creating a formula like:

if {VP_PERSON.HOMELABORACCOUNT} in ["536","456"] then 1 else
if {VP_PERSON.HOMELABORACCOUNT} in ["444","577"] then 2 else 3

Then insert a group on this formula.