As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Difference between revisions of "Tips:Adding URL Links to a Web Report Studio Report"

From sasCommunity
Jump to: navigation, search
(Scheduled May 6, 2011)
(gardening; using .png images since .bmps won't display properly)
 
(2 intermediate revisions by 2 users not shown)
Line 3: Line 3:
 
<td valign="top">
 
<td valign="top">
 
You can add a custom URL link in your Web Report Studio report output by creating a custom measure in Information Map Studio.  
 
You can add a custom URL link in your Web Report Studio report output by creating a custom measure in Information Map Studio.  
<br>First, create a custom data item. You can follow the [http://support.sas.com/documentation/cdl/en/imsgs/61225/HTML/default/viewer.htm#n07k5wfc1azj8in1x4fmpif612nv.htm Information Map User Documentation] for this one.  
+
 
<br>Next select 'Edit' button in the 'Expression Settings' area and type in the URL path.<br>If you are using another data item as part of the URL path (say, for a parameter in a Stored Process result), use SAS functions to include this as well.  
+
First, create a custom data item. You can follow the [http://support.sas.com/documentation/cdl/en/imsgs/61225/HTML/default/viewer.htm#n07k5wfc1azj8in1x4fmpif612nv.htm Information Map User Documentation] for this one.  
</td><td>[[File:IMAP-EditExpressionButton.bmp | 450px]]
+
 
 +
Next, select 'Edit' button in the 'Expression Settings' area and type in the URL path.
 +
 
 +
If you are using another data item as part of the URL path (say, for a parameter in a Stored Process result), use SAS functions to include this as well.  
 +
</td><td>
 +
[[Image:IMAP - Edit Expression Button.png|350px]]
 
</td></tr>
 
</td></tr>
 
<tr>
 
<tr>
Line 15: Line 20:
 
   || strip(put(<<TABLENAME.COLUMNNAME>>,12.))||">"
 
   || strip(put(<<TABLENAME.COLUMNNAME>>,12.))||">"
 
   || strip(put(<<TABLENAME.COLUMNNAME>>,12.))||"</a>"</source>
 
   || strip(put(<<TABLENAME.COLUMNNAME>>,12.))||"</a>"</source>
<br>Finally, Move to the Classification Tab and select 'Display as a hyperlink'.<br>Note: Only the custom data element is underlined in a resulting Web Report Studio List Report. Report Linking (per [http://support.sas.com/documentation/cdl/en/citug/62779/HTML/default/viewer.htm#n1cxoydhoyhsain13of3rrl6yfir.htm|Web Report Studio Documentation]) will display everything as underlined in a list report because it links to a subsequent application.
+
 
</td><td>[[File:IMAP-DisplayasHyperlink.bmp | 450px]]
+
Finally, move to the Classification tab and select 'Display as a hyperlink'.
 +
 
 +
Note: Only the custom data element is underlined in a resulting Web Report Studio List Report. Report Linking (per [http://support.sas.com/documentation/cdl/en/citug/62779/HTML/default/viewer.htm#n1cxoydhoyhsain13of3rrl6yfir.htm|Web Report Studio Documentation]) will display everything as underlined in a list report because it links to a subsequent application.
 +
</td><td>
 +
[[File:IMAP - Display as Hyperlink.png|350px]]
 +
</td></tr>
 
</table>
 
</table>
 
{{SubmittedBy|angelahall|Angela Hall}} [mailto:angela.hall@sas.com angela.hall@sas.com]
 
{{SubmittedBy|angelahall|Angela Hall}} [mailto:angela.hall@sas.com angela.hall@sas.com]

Latest revision as of 15:17, 20 April 2017

You can add a custom URL link in your Web Report Studio report output by creating a custom measure in Information Map Studio.

First, create a custom data item. You can follow the Information Map User Documentation for this one.

Next, select 'Edit' button in the 'Expression Settings' area and type in the URL path.

If you are using another data item as part of the URL path (say, for a parameter in a Stored Process result), use SAS functions to include this as well.

IMAP - Edit Expression Button.png

/*Example:*/
 /* breaking up into bits so it displays better */
"<a href=/SASStoredProcess/do?"
  || "_program=/test+folder+location/stp+program+name&promptval="
  || strip(put(<<TABLENAME.COLUMNNAME>>,12.))||">"
  || strip(put(<<TABLENAME.COLUMNNAME>>,12.))||"</a>"

Finally, move to the Classification tab and select 'Display as a hyperlink'.

Note: Only the custom data element is underlined in a resulting Web Report Studio List Report. Report Linking (per Report Studio Documentation) will display everything as underlined in a list report because it links to a subsequent application.

IMAP - Display as Hyperlink.png

Submitted by Angela Hall. Contact me at my Discussion Page.

angela.hall@sas.com