I have a report which have a URL in the report header.The url was coded with following logic,

TYPE=HEADING,
LINE=13,
OBJECT=TEXT,
ITEM=1,
TARGET='_blank',
JAVASCRIPT=location.href('&VURL') ,
$

This url is working fine , when I run this report directly in my report server .When I schedule this report in the report caster , I recieve the report in the email with same formating and link also visible, but when I click on the link of the url , it is not opening the url but just flickering when click.I tried the view source and it looks like somany spaces are added(%20) after the correct url address.

Why this is coming as spaces only in mail?

Note:-
I am getting the value of &VURL from a database column defined as VARCHAR2(250) and corresponding metadata datatype is
FIELD=REPORT_URL, ALIAS=REPORT_URL, USAGE=A250V, ACTUAL=A250V, MISSING=ON, $

How can I remove space before sending the VURL to the style command? Will STRREP useful for this?

Regards,
Johney.

I don't know if this will solve your URL problem, but if you use the TRUNCATE function on a Dialogue Manager variable, it will remove the trailing blanks. Here's a test program:

-SET &TEST1 = 'APPLE                 ';

-SET &TEST2 = TRUNCATE(&TEST1);

-TYPE LENGTH OF TEST1: &TEST1.LENGTH
-TYPE LENGTH OF TEST2: &TEST2.LENGTH

I find the TRUNCATE function is poorly documented in the 5.3.2 docs - it isn't included in the Function Reference section of the docs, but in the "Creating and Working With Local and Global Variables" section.

It's possible your company/client site may be disabling scripting from within your email client (ex. Outlook). If you're sending the report as an inline message, try it as an attachment.

aha what you describe makes perfect sense.
HTML ignores multiple blank spaces, by default, but the field containing all those extra blanks, brought from your original database, is honored, spaces and all, in other formats.
i would have suggested TRIM function, but Francis's TRUNCATE looks cooler.

Hi ,

I have solved the problem by escaping & = { } characters using below commands.

-SET &VURL = STRREP(&VURL.LENGTH, &VURL, 4, '&', 1, '%26', &VURL.LENGTH, 'A&VURL.LENGTH');
-SET &VURL = STRREP(&VURL.LENGTH, &VURL, 4, '=', 1, '%3D', &VURL.LENGTH, 'A&VURL.LENGTH');
-SET &VURL = STRREP(&VURL.LENGTH, &VURL, 4, '{', 1, '%7B', &VURL.LENGTH, 'A&VURL.LENGTH');
-SET &VURL = STRREP(&VURL.LENGTH, &VURL, 4, '}', 1, '%7D', &VURL.LENGTH, 'A&VURL.LENGTH');

Also , I used URL=&VURL NOW instead of JAVASCRIPT=location.href('&VURL') which I was trying earlier and now it is working even inline email .

I still have lot of doubts about creation of a hyperlink using different methods as below ,

JAVASCRIPT= window.open('&VURL), -* 1
JAVASCRIPT= location.href('&VURL), -* 2
URL=&VURL, -* 3

When I used method 1

I did not escape the url except & and it worked fine in direct run in reporting server and attached mail using report caster.but inline links are not going to the location but just seems like flickering.And when we save the "View sorce" as n HTM for these cases and execute then the link is opening correctly. Also there was an additional window opening with "[object]" as content in that.

When I used method 2,

It was same result except it was not opening the additional unwanted window.Inline urls just flickered but not opened.

When I used method 3

I had to escape & = { } to get everything work fine. Using this method I am able to open the link even in email inline message.I am able to open it in any method , and I am happy in this method.


Regards,
Johney.