Upgrade and Migrate Reporting Services (SSRS)
Sources: https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reporting-services?view=sql-server-ver15
SSRS Permissions
Error: The permissions granted to user ‘DOMAIN\user01’ are insufficient for performing this operation. (rsAccessDenied) User permissions need to be setup both at the SQL Server and SSRS. Account can be both SQL Server account or NT account. SQL Server Account has access to database. (Database -> Security) SSRS Reports pointing to correct Data Sources file.... » read more
Calling Code from SSRS Report
Report File Code Section Note: Make sure you reference the dll in the report. DLL myapp.MyAppFacade.dll C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin
SSRS Reports vs ReportServer
Report Manager URL: http://servername/reports Report Server URL: http://servername/reportserver Report Manager is a convenient web user interface to the Report Server that enables you toview and administer your reports, data sources, and report resources. Report Server is the web service application that functions as your programmatic gateway to the SQL Reporting Services engine. When browsing to... » read more
Create Custom SSRS Security Role
Create new Role via SSMS. Add User to Role via Reporting Services web interface. Create New Role (via SSMS) Make sure you select “Reporting Services” in the Server type. Add User to Custom Role (via Reporting Server Web) Sources: https://marcosfreccia.com/2017/11/06/creating-custom-ssrs-security-roles/ https://docs.microsoft.com/en-us/sql/reporting-services/security/role-definitions-create-delete-or-modify?view=sql-server-2017
SSRS RDS File
Shared Data Sources file. SQL Server Connection string:
SSRS Expression
Field01 String Sum of Field01. If statement. Global Date Currency Switch Running Value https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-runningvalue-function?view=sql-server-2017 Bit Number
Could not load file or assembly. The system cannot find the file specified.
Error: Resolution: If you use custom DLL in your SSRS reports, make sure the DLL is copied over to the shared DLL folder. For VS2017 Community Edition, copy over the DLL to this folder… Other Locations: Sources: https://stackoverflow.com/questions/43520437/ssrs-custom-assemblies-could-not-be-loaded-under-visual-studio-2017
SSRS Report Data Panel
In Reporting Services Report Designer in SQL Server Data Tools (SSDT), the Report Data pane displays a hierarchical view of data objects that you can use in a report, including data sources, datasets, fields, parameters, and images. Data sources in this view can be embedded or references to shared data sources that are displayed in... » read more
Find the Report Definition Schema Version (SSRS)
A report definition file specifies the RDL namespace for the version of the report definition schema that is used to validate the rdl file. When you open an .rdl file in a report authoring environment such as Report Designer in SQL Server Data Tools (SSDT), Visual Studio, or Report Builder. If the report was created... » read more