I have a hyperlink to a CRM view in the header of a compound report. The URL has an amper. After some searching here and tried using defaults, replacing with ascii, but not able to get the link to work properly with a workaround. Any thoughts ?

Here's the statement causing me problems...

OBJECT=STRING, URL=http://crmna.sybrondental.com/Krr/_root/homepage.aspx?etc=1&viewid=%7b5AA0B51A-05A4-DF11-8834-005056B01CD7%7d, NAME='text1', TEXT='Target List', POSITION=(0.501 0.505), MARKUP=OFF, WRAP=ON, DIMENSION=(3.038 0.681), font='ARIAL', color=RGB(0 0 0), size=10, $

This message has been edited. Last edited by: Kerry,

use the escape character |. Focus is trying to resolve your &'s in your string, if you escape it like this &|VARIABLE it should treat it as part of the text.

Thanks Eric - it is no longer prompting for a URL, but now gives me a 'bad value in stylesheet' (citing the updated url) error and the report terminates.

The error seems to be related to the '=' in the URL. Is there a way to qualify the = symbol (the escape | only worked for the amper) ?

This message has been edited. Last edited by: Stephen,

In this case, the url is in the style sheet, functioning as a kind of drill down.
For drill downs it is always possible to enter parameters, like for a focexec call you just put the parameters in a bracketed list. For URL's it is exactly the same. Put the variable (in this case the viewid) in a bracketed list.