SSRS – How to use filter in Report Dataset
We can use the filter by using the filter property of the dataset. This is very useful when we need…
Author: Team SQL Circuit
SQL Server High Availability – How to capture Server(s) status whether it is online or offline using T-SQL programming
Below is an example to capture Server(s) status whether it is online or offline. We are using XP_CMDSHELL extended stored…
SSRS Use Case – Role based display of Charts in the Reports
The requirement is to display some of the common charts to everyone + specific charts to specific team only in…
SQL Server – How to pull data from Source table to Target table ensuring it will pull only data which is not present in Target table.
To achieve the requirment of loading data from Source table to Target table with ensuring it will pull only data…
SQL Server – How to get data from multiple linked server
We can use a stored procedure/T-SQL statements having linked server & DB name as variables to get the data dynamically…
SSRS Error – Credentials used to run the report are not stored
This issue comes when implement automated process like subscriptions e.g. Email subscription, File Share Subscription, Data Driven Subscription. Report Snapshot…
SSAS – Why aggregation values are not changing for the hierarchical dimensions in Cube.
This issue normally comes when there is a problem in relationship between Dimension and Measure group. Go to the Dimension…
SSRS – How to print a same report for Laser jet printer as well as Dot Matrix Printer
A dot matrix printer is a type of printer that uses a print head that moves back and forth, striking…
Explanation of SQL Server Error Message – “String or binary data would be truncated”
The error message “String or binary data would be truncated” tells we are trying to put a longer string into…
SSRS – How to run large bulky report
If there is a case where we need to run a report which process large volume of data and we…
SSRS – How to remove the duplicate values from the report input parameter
If we are using ar eport parameter which is duplicate values. you can remove duplicate records by using T-SQL DISTINCT…
SSRS Report Subscription Issue – Parameters are not valid in subscription
If we get error parameters are not valid while subscribing the report in SSRS then we need to check Parameter…