How do I add SSRS Reports to the Gizmo in IntelliFront BI?

This is a step by step guide to add SSRS Reports to a Gizmo in IntelliFront BI.

Adding a SSRS Report to the Gizmo

  • Select Add SSRS Report.
KPI's and Dashboards: Adding SSRS Reports in a Gizmos in IntelliFront BI.

Report tab

KPI's and Dashboards: Adding SSRS Reports in a Gizmos in IntelliFront BI.
  • Select Account: From the dropdown select the account for the reports you want to schedule.
Tip: the SSRS Account must have been set up in Accounts first. To learn more about setting up an SSRS Account in IntelliFront BI click here.
  • Click Connect.
  • Once connected select the report from the available reports.
KPI's and Dashboards: Adding SSRS Reports in a Gizmos in IntelliFront BI.
  • Click on the report you want to schedule and select Load Report. A confirmation message will be displayed when the report details have been retrieved.
KPI's and Dashboards: Adding SSRS Reports in a Gizmos in IntelliFront BI.

Add Menu

KPI's and Dashboards: Adding SSRS Reports in a Gizmos in IntelliFront BI.

Output Format

  • Click Output to determine the output format of the report.
KPI's and Dashboards: Adding SSRS Reports in a Gizmos in IntelliFront BI.
  • Select the required format form the drop down list.

Data Source Credential

KPI's and Dashboards: Adding SSRS Reports in a Gizmos in IntelliFront BI.
  • In this section you will authenticate to the database the report runs against and other options.

Adding Parameters to the report

KPI's and Dashboards: Adding SSRS Reports in a Gizmos in IntelliFront BI.
  • If the report you are using has Parameters, go to Parameter tab.
KPI's and Dashboards: Adding SSRS Reports in a Gizmos in IntelliFront BI.
  • Enter the required parameter values.
  • Click Save Report.
KPI's and Dashboards: Adding SSRS Reports in a Gizmos in IntelliFront BI.
  • Save Report and Close: This will close the report screens and return to the Gizmo setup screen.
  • Save Report and Create Another:This will add another report to the Gizmo.