Configuring SSRS with Znode

TABLE OF CONTENTS

For Reports deployment, you need to follow the below steps.

  1. Right-click on the “Znode.Libraries.Report” project from Solution Explorer. Select Properties.
  2. In the “TargetReportFolder”, You can give any name to the report folder. After deployment, All reports get created in the same folder on the reporting server.
  3. In “TargetServerURL”, You need to give the Target Server URL. For that please refer to the below image:
    1. For Reference to the URL, You can go with the following steps.
    2. Open SQL Server Reporting Server Configuration Manager.
    3. Go to Report Manager URL, Copy URLs and paste it into the TargetServerURL.
  4. Give any name in the TargetReportPartFolder.
  5. Expand ZNode.Libraries.Report.
    1. In Report Library, Double click on Shared Data Sources
    2. In General Tab - Connection String, give your Data Source and Database name.
    3. Open the Credentials Tab, Click on Use this user name and password and enter the Database login Credentials.
  6. In Report Library, Double click on Shared Datasets.
    1. Please make sure to assign the correct data source to the dataset.
  7. Right Click ZNode.Libraries.Report and Click on Deploy. Your reports will get deployed.
    Notes:
    1. In case you face any problems after deploying reports then you need to verify the access permissions to the data source and datasets folder.
    2. In case you don’t have permissions then you need to create a particular user then you can deploy the reports.
    3. You can deploy any particular report also. Right-click on a particular report and click on deploy. Your reports will get deployed.
  8. If reporting services are configured, then add the settings below in Admin and API’s Web. config file.


Changes to Admin Web.config File



Once the report server is configured, below settings need to be added in the Web.configfile Admin site:

  1. Report server connection string. Please find the name“ZNodeReportDB” and add the connection string of report DB in the same.
  2. Add the report server URL, Username, and Password in the web.config file as per the above screenshot.
  3. Next, mention the name of the report server folder where the reports will reside.The current screen shows there the port structure of the Znode’s QA environment.(You can keep the structure as it is as it will be accessible in your environment only.)


Changes to API Web.config File

In the same manner that we did in Admin’s web.config, we have to add the setting in

API sites web.config file

  1. Please add the proper connection string in the web.config file of the API site.
  2. Provide the URL, username, domain name, password used for reporting services.
  3. Provide ZnodeReportFolderName , Same we have given in the properties of report.
  4. Provide the folder names where the reports need to be saved on the reporting server.
  5. Similarly, if the DataSet name is changed then that name has to be replaced in the web.config file of the API site. This report data set name should be similar to the dataset name which is available in the library named “Znode.Libraries.Reports → Shared Data Sources” folder

Note: From version 9.3.1 to version 9.8, we have to use the ‘MvcReportViewer.ReportServerUrl’ key instead of the ‘ReportServerUrl’ key in API web.config file.



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.