Group by on email address

[ppetronas40]

Hi,
I am very new to Crystal reports, so please excuse if my question is simple.
I have to group by email_address. The query pulls data based on if (email_address like '%@abc.com' or '%@xyz.com')
I want my report to look like:

@abc.com
Record1
Record2
@xyz.com
Record1
Record2

I have created two formulas.
{Command.email_address}= '%@abc.com'
{Command.email_address}= '%@xyz.com'
How do I go from here.

Thanks,
Petronas

 

[IanWaterman]

YOu need to create one formula

If {Command.email_address} like '%@abc.com' then '@abc.com'
else if {Command.email_address}like '%@xyz.com'
then
'@xyz.com'
else
'Other'

Then group on this formula.

If you do not want to see the others you can filter out in select statement using

(
{Command.email_address} like '%@abc.com' or
{Command.email_address} like '%@xyz.com'
)

Ian

 

[lbass]

If you are using a command, then you can insert a group on this formula:

mid({Command.email_address},instr({Command.email_address},"@"))

Note also that if you are working within the Crystal GUI, you would use "*", not "%". Within a command, however, the "%" is the appropriate wildcard.

-LB