Dynamic Hyperlink in Report Studio 8.2 based on variable choices

[cdndesi]

Hello folks,

I'm a newbie here, but I'm hoping you can help me.

Currently, I've designed a report with 3 variable choices. These variables are selected as a user selects a drop down menu, and populates an existing chart with new query data.

The three variable choices, and their associated variable values are:

- Current Month (1)
- Year to Date (2)
- 13 Months Trending (3)

I have created 3 separate reports (which output to PDF) within C8.2 RS and want to link to these individually when an individual report is selected.

ie. For example, CurrentMonth-Summary is linked to when (1) is selected, or YTD-Summary is linked to when (2) is selected.

I have set up a hyperlink within Report Studio, but I would probably think an HTML control would likely need to be used.

I'm also trying to go through this particular article from IBM's website (http://www-01.ibm.com/support/docview.wss?rs=0&context=SSCXMLL&q1=null&uid=swg21339459&loc=en_US&cs=utf-8&cc=us&lang=en), but not having much success. Here is a summary of the page:

Problem(Abstract)
This document describes how to create a Hyperlink which is based on a Query and how to open the target in new browser window.

Resolving the problem
Add a new Data Item to the Query of the report, which retruns the hyperlink. Include target="_blank" into these Data Item in order to open the target in new browser window. Add an HTML Item to the report, and specify the HTML Source as the Query Item.

Steps:

1. Add a new Data Item to the Query of the report, that will perform the validation for the hyperlink.
- A simple example query from the Go Sales and Retailers model, is included below:
- if ([Product line] = 'Camping Equipment' ) then ('<a href="http://localhost/'; + [Product line] + '" target="_blank">link</a>' ) else null

2. Add an HTML Item to the report, and specify the HTML Source as the Query Item created in (1) above.

Thoughts?

Basically, what I want at the end of the day is those 3 separate reports to display a PDF rendering of them, and enable the right one to be downloaded when the user clicks on the "Download PDF" hyperlink.