SSRS Report View

The SSRS Report view enables you to view and edit all the information required for connecting to, and executing, a SSRS report.

SSRS Report Features

The main function of the SSRS Report view is to allow the specification of the report you want to execute on your SSRS reporting service, along with the type of report you would like to create.

By default the system will connect using the SSRS credentials set up in your settings.config file (see here for more information). This uses the following settings:

NameDescription
SSRS_URL
Indicates the url to connect to your SSRS report server that the SSRS Reports will use by default.
The url needs to connect to the 2005 report execution server, for example:
http://localhost:80/ReportServer/ReportExecution2005.asmx?wsdl
SSRS_Credential_Domain
The domain to use when using domain/username/password credentials to connect to the SSRS report server.
SSRS_Credential_UserName
The username to use when using domain/username/password credentials to connect to the SSRS report server.
SSRS_Credential_Password
The password to use when using domain/username/password credentials to connect to the SSRS report server.
SSRS_Credential_UseDefault
Indicates when connecting to the SSRS report server if it should use default network credentials or not. You must provide domain/username/password if this is false.

You can however override these settings, or specifically supply them if they are not configured in your config file, for any individual report.

Report Properties

SSRS Reports have the following properties:

NameDescription
[Required]
[Key]
Name		The unique user friendly name of this Report
Default Export Type

The type of file to generate when executing this report. Can be any of the following:

  • PDF
  • Excel
  • Word
  • PowerPoint
  • HTML
Folder PathThe path of the folder within the connected SSRS instance that contains the report you want to execute.
Report NameThe name of the SSRS report you want to execute.
Override Report Server URLThe override value for the SSRS_URL setting specified above
Override Report Server DomainThe override value for the SSRS_Credential_Domain setting specified above
Override Report Server User NameThe override value for the SSRS_Credential_UserName setting specified above
Override Report Server PasswordThe override value for the SSRS_Credential_Password setting specified above
Override Report Server Use DefaultThe override value for the SSRS_Credential_UseDefault setting specified above
DescriptionA user friendly description of this Report

Commands

SSRS Reports also have the following custom commands:

  • Execute Report
    Popups a dynamically created parameter screen for the user to select any parameter values setup for the report (if any). Then passes all the information to the 3rd party reporting service to execute the report, and saves the generated file for viewing as the result of the report.

 

© 2020 LemonTree Software.