Multiple Select Values Hyperlinks
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.<br />
<br />
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.<br />
<br />
When everything is setup correctly you will see this:<br />
<br />
<br />
<br />
Go to the Master Page tab and define the hyperlink value for the ‘Printable Version’ label.<br />
<br />
<br />
<br />
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.<br />
<br />
<br />
<br />
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.<br />
<br />
<br />
<br />
Run the report and you’ll see something like:<br />
<br />
<br />
<br />
Select the ‘Printable Version’ link and you’ll see:<br />
<br />
<br />
<br />
Notice the multiple select parameters are shown as passed from the hyperlink definition
<br />
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.<br />
<br />
When everything is setup correctly you will see this:<br />
<br />
<br />
<br />
Go to the Master Page tab and define the hyperlink value for the ‘Printable Version’ label.<br />
<br />
<br />
<br />
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.<br />
<br />
<br />
<br />
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.<br />
<br />
<br />
<br />
Run the report and you’ll see something like:<br />
<br />
<br />
<br />
Select the ‘Printable Version’ link and you’ll see:<br />
<br />
<br />
<br />
Notice the multiple select parameters are shown as passed from the hyperlink definition
0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management