Integrating the database column values into URLs and anchors allows you to dynamically generate links and anchors.
To include a column value in a URL or anchor name, place the string <##QueryName=TableName.ColumnName> in the hypertext link’s URL or the anchor’s name. When you run the report, the column’s value replaces the defined string.
For example, to add the current value of the name column in the customers table for a main query, you would enter the following string:
In another example, assume you want to provide a link to each customer’s Web page in a Customer List report. You would first add the column homepage in the customer table. This column would contain the home page URL for each customer. Instead of typing in a URL you would enter <##Main=CUSTOMERS.HOMEPAGE>.SQR Production Reporting Studio automatically generates the correct URL by using the URL specified in homepage for each customer.
Another more powerful example assumes you have a Web-based information retrieval system that can retrieve information on customers through a structured URL. In this case, you could form the URL by entering the prefix http://www.yourcompany.com?, appending the customer name, and following that with the string &info=sales.
In this example, whenever you create a report that includes customer names, SQR Production Reporting Studio will automatically generate the correct URL by assigning the following URL to the customer name object in your report.
http:/www.yourcompany.com?custname=<##Main=CUSTOMERS.NAME>&info=sales