This but not that...

[celauritz]

When I do this...

http://www.sunflower.com/~chrisg/question.bmp

I get this...

http://www.sunflower.com/~chrisg/question2.bmp

As you see, it adds another line for account for every service the account has.

What I can't figure out how to do is to get a list of accounts that have one service, say BAS, but definitely not have another certain service, say EB

I know it is likely pretty easy, but I am lost when it comes to this. Help please

 

[Turkbear]

Hi,
Assuming this is somehow related to some version of Crystal Reports and assuming that the data comes from some kind of database, then use a Record Selection formula to limit what is returned.

With so little info provided, not much help can be supplied..





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

 

[lbass]

Create a formula {@BASnotEB}:

if {table.field} = "BAS" then 1 else
if {table.field} = "EB" then 1000000 else 0

Then go to report->selection formula->GROUP and enter:

sum({@BASnotEB},{table.acct}) in 1 to 999999

This will return the accounts that meet your criteria. If you need to do calculations at the report level, you will need to use running totals, since the non-group-selected records will still contribute to any inserted summaries.

-LB