SSRS – How to create a Map report with Geospatial data
The objective of this article is create a SSRS report with geospatial data. Here we will use geospatial data for…
Category: SSRS
SSRS – How to create a report with XML data source
1) Objective: The objective of this article is to provide a way of developing report with XML as data source. Here…
SSRS – How to create a report with “Enter Data” connection type
1) Objective: The objective of this article is to provide a way of developing report without connnecting any data source…
rsReportServerDatabaseError – Timeout or low disk condition within the database
Error: An error occurred within the report server database. This may be due to a connection failure, timeout or low…
SSRS – How to run SSRS report based on either of the 2 parameters
We need to write dataset query in IF ELSE manner with Parameter. Below is the example: Suppose @QueryType is your input…
SSRS – How to dispaly data from Large Dataset without performance issue
We can enable report caching or Report snapshot if it fits in the requirement. There will be little data latency…
SSRS – How to check whether dataset is returning data or not
We can use the below expression to check whether dataset is returning data or not : =IIF(CountRows(“YourDataset”) > 0,“Data is…
SSRS Security Model – Role Permission Matrix
Role/Permission Matrix Following is the Role/Permission matrix for an application that uses SSRS reports for their portal. This matrix consists…
Need of Custom Role(s) in SSRS Security Model
1) Predefined Role(s) in SSRS Reporting Services installs with predefined roles that you can use to grant access to report…
SSRS – Timeout issue with frequently running report & Report Snapshot
When we pull the data from bulky DB/DW, query/report timeout is one of the main issue that user faces in…
SQL Server Reporting Services(SSRS) – Performance Monitoring & Optimization
Common Report Performance Issues Data takes too long to retrieve Report takes too long to process Report takes too long…