hyperlink, mailto

[EvilSock]

Hello All,
My goal is to wite a report that groups orders taken by various people. Each person needs to get a summary of their activites from the administrator. The hyperlink/mailto function is perfect for this. At the footer of each group I have written a formula that pulls the employee's email address and creates a simple string

"mailto:someone@here.com?Subject=stuff&Body=more things";

This works great! However, Crystal reports has a limit of 254 characters in a string. I need at least 400 characters to send the amount of information that is required. How can I get around this contraint?

any ideas??

I was thinking about using an array of strings, but I don't know how I would implement that.


My ultimate goal is to send an email with a portion of the report embedded in the email's body. I am open to any solutions other than what I am attempting.

 

[IdoMillet]

EvilSock (are you related to SynapseVampire?),

If you upgrade to CR 9.0, the 254 character limitation goes away (it becomes 64k).

There are several 3rd-party tools (see a comprehensive listing at

http://www.kenhamady.com/bookmarks.html)

including my "CUT" and "Visual CUT" software utilities that allow automatic bursting, exporting, and e-mailing from Crystal reports.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[EvilSock]

While upgrading to version 9 will obviously correct my problem, can you think of a work around using native Crystal reports functions to do this task?


The issue at hand is that the Crystal Reports Engine is tied in with our PeopleSoft Financials System. Our company has licenses for Crystal Reports Version 9, but I do not know if the Version 9 Engine is compatible with PeopleSoft (and the PeopleSoft factor far out-weighs the potential usefullness of the report I'm trying to improve).

I will endevor from my end to determine what are the dangers (if any) to upgrading to Crystal v9.

 

[chelseatech]

The UFL solution suggested by Ido will work with older Cr versions.

I've got a similar function to send to disk, email or XML that works in the same way as Ido's utilities.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm