Thanks! It did seperate it. If I wanted to be able to group it by the indivisual addresses to be able to see by recepient who gets what how can I do that?
Since the field is only one record, you can't really group on it. What do you want the output to look like.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
I would like to be able to group by it. My field is in a database which contains daily reports which are scheduled and in this field is the list of e-mail addresses of the people who receives them. I would like to group by the indivisual addresses so I can see by the receiver who gets what? Make sense?
Makes sense, but you can group 1 record into multiple groups. You might be able to give the illusion of your grouping feature but that would depend on how you plan to use the grouping. That is why I asked what the output would look like.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
It sounds like the list of addresses is in a single field. Each list would be one record. Are report1 and report2 fields in the same record, or are they related records in a different table?
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
What are the field names for these 2 fields?
How many Email addresses can there be in the list?
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
if it can hold unlimited email addresses, then my technique isn't feasable. Sorry.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
Not sure I understand the data anymore. You told me that report1 and report2 were in the same record, and then you said they were in the same field. Can't be both.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
My original technique would use conditional details, but that assumes that your information was in the same reoord. You have a batch record for each report with a list of recipients - the record can only appear in one group. The only technique you can use is to run a separate report for each Email address, listing the batches they are in.
If you have a master list (table) of recipients, wiht one record per recipient, you could do a linked subreport.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.