Limitation of mailto hyperlink

[PDAnalyst]

Hi,

I am using CR 11R2 on a windows XP machine, data stored on an Oracle 9i database.

I have a report that lists all of the comments made during a call. My officers would like to be able to send these comments by using a simple button push to selected apartment managers. I have manage to write the code by using "mailto" command and formula to insert the email address for individual properties, the subject line as well as most of the body but I ma running into prolem with the character length limitation. It seems that even though in CR, the body can be upto 1650 characters (over that it crashes, I have placed a truncation limit to this), when I export this to Adobe pdf, the body of the message gets truncated to only 941 characters (or 1040 total characters including the mailto and subject etc. tags.)

I will appreciate if anyone knows of how to tweak this setting to increase this pdf limitation to match with the CR limitation.

Thanks

Safa

 

[hilfy]

Is the body of the message truncating or the "MailTo:"? Your subject line says one thing but your description says another.

You could try splitting the body into two or more text objects based on where the carriage returns are located.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[PDAnalyst]

Thanks hilfy.

below is the code as well as how the body shows in the MS outlook when I click the button in Crystal Report and how it shows when exported to pdf and then click on the email button to send the info. There is definiteley some truncation going on.

The data is actually in multiple lines, I have used an accumulation script to concatenate the comments into a single data stream. That is the reason why the formatting is off.


Code in Crystal Report to create the email “mailto Command” (TOTAL: 1624 characters, body section is 1526 characters starting from “body=” code)-------------

mailto:someone@someone.com?subject=Calls for Service Occurred at - 900 XXX XXXXXX MAIN AVE&body=*****%0AIncident number: LHP100000000000 Report Number: No Report Occurred on: 11/9/2010 11:14:25%0AApartment Unit Number: XXXX Call Type: SOME CRIME %0A%0A*****%0AComments:%0AIncident Initiated By: HP-POLICE OFFC, IF VEHICLE FIRE DISPATCH PD UNIT AND NOTIFY SERGEANT-LIEUTENANT-OIC POSS XXXX IN FRM- TO-HPHPXXXX CODE 3 M**XXX01**YOU ARE RESPONDING TO A PATIENT WHO IS SICK (OR HAS A CURRENT M EDICAL CONDITION) THE PATIENT IS A XX-YEAR-OLD MALE WHO IS CONSCIOUS AN D BREATHING NOT ALERT **XXXXXXXXXXXXXXXXXX ** Original Location : XXXXXXX APTS RM HF-XXX HF-XXX RM XXXXXX AHFRXX USDXXXXXXXXXXXX 26XX PU FRM- TO-HF-XXX USD XXXXXXXXXXXX 26XX RN XX ADDED TO EVENT FHF100000000000 HFEXX USERXXXXXXXXXXXX 26XX WITHDRAWAL FROM XXXX MEDS USERXXXXXXXXXXXX 26XX EX-PATIENT, XXXXXXXXXXXX, CALLED DOCTOR AND SAID HE WAS GOING TO JUMP OF F HIS BALCONY, PT HAS QUIT TAKING HIS MEDS, WAS TAKING XXXXXXXXXXX5 MG, U NK WEAPS, TL-2, CALL BACK #XXXXXXXX DOCTOR'S OFFICE REC'D CALL FROM MALE MAKING THREATS TO JUMP OFF BALCONY, THEY ADV'D HE WAS EITHER COMING OFF HIS MEDS OR NO LONGER TAKING THEM, XXXXXXXXX,XX5MG 3X A DAY IAAssocInc FHF100000000000 UPDATE PriUnt to HF-RXX NEG XXXX DR. DOCTOR'S ASST XXXXXX ADVISED OF NEG XXXX BY #XXXX. IAAssocInc FHF10000000000 UPDATE Dispo to CLEAR



Comments in the Body section of the email if I click the “Email to” button inside Crystal Reports: (1516 characters total)--------------

*****
Incident number: LHP100000000000 Report Number: No Report Occurred on: 11/9/2010 11:14:25
Apartment Unit Number: XXXX Call Type: XXXXXX XXXXXXX
*****
Comments:
Incident Initiated By: HP-POLICE OFFC, IF VEHICLE FIRE DISPATCH PD UNIT AND NOTIFY SERGEANT-LIEUTENANT-OIC POSS XXXX IN FRM- TO-HPHPXXXX CODE 3 M**XXX01**YOU ARE RESPONDING TO A PATIENT WHO IS SICK (OR HAS A CURRENT M EDICAL CONDITION) THE PATIENT IS A XX-YEAR-OLD MALE WHO IS CONSCIOUS AN D BREATHING NOT ALERT **XXXXXXXXXXXXXXXXXX ** Original Location : XXXXXXX APTS RM HF-XXX HF-XXX RM XXXXXX AHFRXX USDXXXXXXXXXXXX 26XX PU FRM- TO-HF-XXX USD XXXXXXXXXXXX 26XX RN XX ADDED TO EVENT FHF100000000000 HFEXX USERXXXXXXXXXXXX 26XX WITHDRAWAL FROM XXXX MEDS USERXXXXXXXXXXXX 26XX EX-PATIENT, XXXXXXXXXXXX, CALLED DOCTOR AND SAID HE WAS GOING TO JUMP OF F HIS BALCONY, PT HAS QUIT TAKING HIS MEDS, WAS TAKING XXXXXXXXXXX5 MG, U NK WEAPS, TL-2, CALL BACK #XXXXXXXX DOCTOR'S OFFICE REC'D CALL FROM MALE MAKING THREATS TO JUMP OFF BALCONY, THEY ADV'D HE WAS EITHER COMING OFF HIS MEDS OR NO LONGER TAKING THEM, XXXXXXXXX,XX5MG 3X A DAY IAAssocInc FHF100000000000 UPDATE PriUnt to HF-RXX NEG XXXX DR. DOCTOR'S ASST XXXXXX ADVISED OF NEG XXXX BY #1245. IAAssocInc FHF10000000000 UPDATE Dispo to CLEAR



Comments in the body section of the email when generated from the adobe pdf document after getting exported by the Crystal Reports (937 characters total, so there is definitely some truncation going on)-------

*****
Incident number: LHP100000000000 Report Number: No Report Occurred on: 11/9/2010 11:14:25
Apartment Unit Number: XXXX Call Type: XXXXXX XXXXXXX
*****
Comments:
Incident Initiated By: HP-POLICE OFFC, IF VEHICLE FIRE DISPATCH PD UNIT AND NOTIFY SERGEANT-LIEUTENANT-OIC POSS XXXX IN FRM- TO-HPHPXXXX CODE 3 M**XXX01**YOU ARE RESPONDING TO A PATIENT WHO IS SICK (OR HAS A CURRENT M EDICAL CONDITION) THE PATIENT IS A XX-YEAR-OLD MALE WHO IS CONSCIOUS AN D BREATHING NOT ALERT **XXXXXXXXXXXXXXXXXX ** Original Location : XXXXXXX APTS RM HF-XXX HF-XXX RM XXXXXX AHFRXX USDXXXXXXXXXXXX 26XX PU FRM- TO-HF-XXX USD XXXXXXXXXXXX 26XX RN XX ADDED TO EVENT FHF100000000000 HFEXX USERXXXXXXXXXXXX 26XX WITHDRAWAL FROM XXXX




Any help is appreciated, Thanks.