Arrays

[menuch]

Hi,

I have a field in my database that contains e-mail addresses seperated by a " ; ". How can I break that field up?

Thanks,

Joel

Menuch
Report Designer

 

[synapsevampire]

Break it into what?

Here's a formula to display them on seperate lines.

join(split({table.email},";&quot,chr(13))

-k

 

[menuch]

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?

Thanks!

Menuch
Report Designer

 

[kenhamady]

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

http://www.kenhamady.com/

- tek@kenhamady.com

 

[menuch]

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?

Thanks!!


Menuch
Report Designer

 

[kenhamady]

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

http://www.kenhamady.com/

- tek@kenhamady.com

 

[menuch]

I would like the output to look like:

Group1 - johndoe@blah.com
Details - Report1
Report2

Group1 - janedoe@blah.com
Details - Report1
Report2


and so on...

Menuch
Report Designer

 

[kenhamady]

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

http://www.kenhamady.com/

- tek@kenhamady.com

 

[menuch]

They are in the same record.

Menuch
Report Designer

 

[kenhamady]

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

http://www.kenhamady.com/

- tek@kenhamady.com

 

[menuch]

The name for the field that contains the email addresses is:
{ReportBatch.Recipients}

This field can contain an unlimites amount of addresses seperated by a ";"

The field that contains the name of the reports is:

{ReportBatch.Subject}

Thanks!


Menuch
Report Designer

 

[kenhamady]

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

http://www.kenhamady.com/

- tek@kenhamady.com

 

[menuch]

What would it be I If limit them?

Menuch
Report Designer

 

[kenhamady]

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

http://www.kenhamady.com/

- tek@kenhamady.com

 

[menuch]

Im sorry you are right, report1 and report2 are in seperate records.

Menuch
Report Designer

 

[kenhamady]

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

http://www.kenhamady.com/

- tek@kenhamady.com