Hi everyone,

Wonder if you could point me in the right direction for the following query:

I have a list of records that I would like to group by.
The records all have email addresses associated to them e.g j.smith@companyA.com

I would to group by the domain name of the email address.

Is there a way that you can tell Crystal to only look at a certain portion of the email address and then group by that?

Any help would be greatly appreciated.

Thanks
Sean




Edited by hancorn - 03 Nov 2009 at 6:48am

Thank you for the reply, you are most kind!

Can I then ask, what happens if some of the "table.email" values are not in a format of name@company.com. I also cannot change the non email address format values to a proper email format, unfortnuately.

I have found that it errors my report and produces no results.

"String length is less then 0 or not an integer"

Any ideas?

Thanks dblank




Edited by hancorn - 05 Nov 2009 at 3:59am

again, cheers for your reply.

So what I would like to accomplish is the following.

Total number of requests by submitter(company or employee of that company) over a date range, grouped by submitter.

The problem I am having is that sometimes the record is recorded against the COMPANY name and sometimes the record is recorded against an employee at that company in the form of NAME@COMPANY.COM.

I need to report on all calls from a COMPANY over a time period.

So a short answer would be:

I would like to group the invalid rows(the ones that are in a format of COMPANY) to the same records that are in an EMAIL format. Obviously only when they are both from the same company.

Hope this makes sense and I have not bored you too death!

That has worked just GREAT!

A million thanks from a very appreciative person.