Versions Compared

Old Version 1

changes.mady.by.user Knowledge Assistant

Saved on

compared with

New Version 2

changes.mady.by.user Knowledge Assistant

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue

Need to configure Live_Builder datasourceDatasource

Need connection to Production database server

Setup datasoruce Datasource in SSRS for Production environment

Setup datasoruce Datasource for building Custom SSRS Reports

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

Need Live_Builder Datasource to build Custom SSRS Reports


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

The following steps illustrate how to setup a Live_Builder datasourceDatasource

  1. Refer to site report for Database Server name, this is usually listed as CNAME. 
  2. Replace <server_name> and <database_name> in the following template to build the connection string:
    • Data Source=<server_name>;Initial Catalog=<database_name>
  3. In SSRS URL, click on + New on the top right and select Data SoruceSource 
  4. After providing an appropriate name for this datasoruceDatasource, paste the connection string from Step 2 in the Connection string textbox 
  5. Under Credential section, select By prompting the user viewing the report for credentials
  6. Select Database user name and password from Type of credentials dropdown
  7. Click Apply

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional Information

A reporting account is necessary to run any report using this datasoruceDatasource. Refer to the following article on how to create a reporting account.

Munis Cloud Admin Reporting Accounts

...