Multiple Select Values Hyperlinks

SailRCGSailRCG Junior Member
edited June 26, 2013 in DevShare Downloads
Here is an example which will demonstrate two functions and an ‘if statement’ in the initialize that can make a report very flexible. The two functions build a list of comma separated values from ‘Multiple-Select’ enabled parameters. The ‘if statement’ and variables in the initialize is used with a hyperlink to choose between two ‘themes’ depending on desired output.

To use the example you will extract the rptdesign and rptlibrary files and import them into your report project. Include the library in your shared resources and make the rptlibrary file available to the rptdesign file.

When everything is setup correctly you will see this:


Go to the Master Page tab and define the hyperlink value for the ‘Printable Version’ label.


Use the expression builder for the ‘paramProductName’ parameter, to leverage the buildParamList() function. The ‘Report Data Set’ will have ‘beforeOpen’ scripted to use buildWhereClause() for the multiple selections of the paramProductName values.


When you first run the report you’ll see the entire unrestricted report output, as the visible parameter is not required. So, for you to test the passing of a string of multiple selected values to a report parameter in a hyperlink, select the show ‘Parameters’ from the toolbar and select a few product names at random.


Run the report and you’ll see something like:


Select the ‘Printable Version’ link and you’ll see:


Notice the multiple select parameters are shown as passed from the hyperlink definition
Sign In or Register to comment.