SmartList Builder 2018
Using Drill Downs In External Applications
This section describes how to add Drill Downs to Web sites, e-mails and reports built using SQL Reporting Services. It does require that you have security to the window that you are trying to drill back to and that you are logged into GP and into the company that the data is for.
To get started, you must setup the Drill Down in Drill Down Builder, defining the parameters and window you want to drill back to. Once you have that defined, the setup from Drill Down Builder can be added in Excel Report Builder and SmartList Builder. It can also be added to other locations such as Web Sites, e-mails, and SQL Reporting Services reports.
When you add that drill down to the external application, it is going to need some information from you so that it knows how to drill back and with what data. Below is the basic syntax for the drill down.
The URL string for the drill down takes the form:
dgpp://DGPB/?Db=SQL_Instance&Srv=Server_ name&Cmp=Database_Name&Prod=3830&Act=OPEN&Func=Drill_Down_ID&Param_Name=Value
There can be multiple parameters added to the URL string.
The variables in the drill down break down as so:
| • | Db: Equal to the Instance name of your SQL Server. If you do not have a SQL instance name, leave it equal to nothing. |
| • | Srv: Equal to the Server name of the SQL Server. |
| • | Cmp: Equal to the database ID of the company database to drill back to. |
| • | Prod: Equal to the product the drill down is from. If you are using Drill Down Builder, this would be 3830 |
| • | Act: Equal to the Action Type which is generally going to be OPEN. |
| • | Func: Equal to the Drill Down Function you are calling. If you are using Drill Down Builder, it would be equal to the Drill Down ID. |
| • | Param_Name: Param_Name is to be replaced by the Parameter you are calling and set equal to the value to pass to that parameter. |