Question : I am creating a SSRS report using a Stored procedure. The stored procedure does dynamic pivoting couple of […]
Tag: ssrs-2012
Convert SID string to varbinary(85)
Question : My ssrs server was moved to a different domain because of which the Users table need to be […]
Creating Report Subscriptions on report that are using a Shared data source that uses Windows Integrated Security
Question : We’ve recently deployed a new SSRS Server 2012, that can use Windows Integrated Security. We configured the servers […]
SSRS is missing after failover to other node
Question : We have 2 node setup cluster, after a failover I can’t see the reporting services, even the service […]
I changed permission of SQL Server Reporting Services through SQL Server Management Studio
Question : Now I can’t access Reporting Services through SSMS. I can’t even connect to Reporting Services now. Answer : […]
Pass a parameter from SSRS to MySQL
Question : Here is the query for the dataset: SELECT DISTINCT CompanyId, Company FROM User_Hierarchy_Mapping WHERE UserId = @FieldManager FieldManager […]
SSRS 2012 Report with Oracle database as datasource never finishes
Question : I am investigating a SSRS 2012 Report which used to return data from an Oracle database. However, recently […]
SSRS – ERROR NUMBER:7357 while passing multiple value parameters using comma delimited string to stored procedure
Question : I am working on a SSRS report to display the logins permissions in a set of databases on […]
SSRS purge rows from dbo.catalog
Question : We have a third party software that generates reports by adding a new “temp” report to the SSRS […]
Creating Report Subscriptions on report that are using a Shared data source that uses Windows Integrated Security
Question : We’ve recently deployed a new SSRS Server 2012, that can use Windows Integrated Security. We configured the servers […]
- 1
- 2