Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Challenge with embedded & in URL
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Challenge with embedded & in URL
 Login/Join
 
Silver Member
posted
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,


WebFocus 7.11/7.6
 
Posts: 38 | Registered: May 20, 2004Reply With QuoteReport This Post
Gold member
posted Hide Post
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.


Eric Woerle
WF 7.6.7 Reportting Server
ETL 7.6.10
Dev Studio 7.6.7
 
Posts: 95 | Registered: July 31, 2007Reply With QuoteReport This Post
Silver Member
posted Hide Post
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,


WebFocus 7.11/7.6
 
Posts: 38 | Registered: May 20, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Challenge with embedded & in URL

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.