Lab Create: jDropdown

Estimated reading time: 6 minutes


When manually entering different filter values, it can be difficult to remember what the exact filter names are and which are even available. This is especially true in large reports with many filtering options. However, you can use Interject’s jDropdown formula to automatically create hyperlinked lists of available filters, which makes filtering in large reports a much simpler task. In this lab you will modify the Customer Aging report by adding the jDropdown functionality to one of the filters, while using an existing data portal.

IMPORTANT: The jDropdown feature requires a stored procedure to operate. In the event that you cannot create a stored procedure, you can reuse a data portal from the report formula that populates the report in which you want to use this feature. To learn how to build the database connection, dataportal, and stored procedure used in this example, follow the instructions in the developer lab. Otherwise contact your IT department to help implement this functionality.

Preparing the Report

Step 1: Open the report INTERJECT Customer Collections under the INTERJECT Demos in the Report Library .

Step 2: Next, unfreeze panes by going into Quick Tools and selecting Freeze/Unfreeze Panes.

Adding a Named Range

Step 1: Now select the Formulas ribbon tab and select Name Manager.

Step 2: Next, select New….

Step 3: For the Name: field input CompanyNameDDL, and in the Refers to: field input =CustomerAging!$H$7

Note: A named range is used here so that upon the movement of the formula, the hyperlink that is created later will still reference the cell with the jDropdown() formula.

Creating the Formula

Step 1: Next, in cell H7 insert =jDropdown() then select fx

Step 2: For the DataPortal argument field, input NorthwindCustomersDropdown.

Step 3: For the MultiSelect argument field, input False. Then for the Target Cell Argument field, input C17.

Step 4: In the Value Column Name argument field, insert CompanyName.

Step 5: Scroll down in the function arguments untill you see the Display Column Name argument field and insert DisplayText.

Step 6: Next, scroll down in the function arguments to find the Instruction Text argument field and input Select A Customer.

IMPORTANT: The Value Column Name and the Display Column Name arguments must exactly match the name of a column that is returned by the stored procedure. A good place to look for valid columns is in the Column Definitions section of the report. To learn more about the jDropdown() function and what each of its arguments do, review its index page.

Step 1: Now select cell B17 and right click. Then select the Link option in the menu.

Step 2: Click on Place in This Document then select the CompanyNameDDL defined name in the list of options. Then select the ScreenTip… button.

Step 3: In the ScreenTip text: field input Interject Dropdown.

Reviewing the Report Changes

Step 1: Now select the hyperlink you just made and type Market into the search options. Notice that there are 4 options. Select BOTTM - Bottom-Dollar Markets.

Step 2: Pull the report.

Step 3: The pull will only return the Bottom-Dollar Markets data.

To build the stored procedure and dataportal, and database connection that allows this formula to work, continue to the developer section of this lab.