Welcome and thank you for joining our new OpenText forum. Your questions, responses, best practices, and tips shared with other members will help make this channel vibrant. We're glad you're joining us and look forward to collaborating with you online.

Check out the Getting Started With OpenText Forums for tips on personalizing your experience.

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:



ReportLibraryLinked.png



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



Hyperlink%20with%20Parameters1.png



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.



BuildParamsListFunction.png



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.



SelectedProductNames.png



Run the report and you’ll see something like:



ColorReportOutput.png



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



BWReportOutput.png



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