Add URL Links to a Column

You can define report column cells as URL links.

When you click a URL link in a report, your web browser launches and the website the URL points to opens. You can customize the URL and add variables to the link, using the values in any of the report’s columns. For example, you could direct a URL to open an answer on the customer portal, or you could direct the URL to a page designed by your organization.

1. Right-click the header of the column you want to modify and select Edit Format.
   The Column Format window opens.
2. Click the URL tab.
3. Enter field information.

   URL Tab

   Field	Description
   None	Select this option to clear URL options.
   Display Cell Value as Link	Select this option to enable URL options for the column. This lets you link to a website using either the value displayed in the field or a custom URL.
   Display Cell Value as Image	Select this option to enable image options for the column. This lets you store images on a separate server and display the images in the column. Since you can point to external locations for the image files, you do not need to upload the images. Instead, you specify the URL where the image you want to display is stored. See Display External Images in a Report Column.
   Use Cell Value as URL	Select this option to use the value in the field as the URL link. Use this only if the value in the field is a valid URL.
   Use Custom URL	Select this option to manually specify the URL. You can enter the URL you want in the text box, or click Advanced URL Definition to view options to help you define the URL.
   Advanced URL Definition	Click this text to display advanced URL formatting options. When you click Advanced URL Definition, the text changes to read Simple URL Definition. Click this text to hide the Advanced URL Definition options.
   Report Column Selection	You can add variables and variable values to the custom URL in this section. Enter the variable you want to add to the URL in the text field, and then select the column to use to populate the variable’s values from the drop-down list.
   Target	Enter the value you want for the customer portal URL’s target attribute in this field. This is optional and is used to specify where the customer portal page that's linked to opens. This can be used to customize the browser window used to display content customers can view, such as answers.
   Append Session ID	Select this check box to append the session ID number to the URL. Use this option when the URL links to a customer portal page to ensure the URL for the page is valid.
   Begin with Server End-User URL	Select this check box to automatically prepend the path to the B2C Service server to the custom URL.
   Begin with Answers Detail URL	Select this check box to automatically prepend the path to the customer portal’s answers detail page to the URL. This is defined in the CP_ANSWERS_DETAIL_URL configuration setting.
   Begin with Server Admin URL	Select this check box to automatically prepend the path to the B2C Service server’s PHP directory to the custom URL.
   Open URL in	You can use the options in this section to specify where you want the web page that's linked to from the column to open.
   Default Browser	Select this option to open the web page in the computer’s default browser. A new browser window opens if one isn't already open.
   Popup Window	Select this option to open the web page in a new window.
   Print Dialog	Select this option to open the web page in the Print window. You can then print the content displayed in this window.