Representation of data in Table & Matrix & Correlation
The objective of this article is provide a visualization for data in tablix as well as matrix and how we…
SSRS: How to put filter at visual level
Here is the sample Sales Report which shows Region & Year wise Sales Amount. If we want to put…
SSRS Reporting – How to add a Reference Line in Line Chart
Sometimes, requirement comes to add a reference line in the line chart which will act as benchmark to measure the…
High Level Architecture of Web & Database Server with Load Balancing & High Availability
1) Web application would be hosted on 2 web servers -Web Server 1 and Web Server 2. 2) Both the…
SQL Server Agent – How to enable SQL Agent Job using T-SQL script
USE MSDB; GO –Declaring Variable DECLARE @job_id UNIQUEIDENTIFIER DECLARE @Cnt INT DECLARE @Min INT –Declaring Table Variable DECLARE @SQLAgentJob (…
SQL Server Agent – How to disable SQL Agent Job using T-SQL script
To do unattended tasks like if error comes need to disable the job. In this case, we need to disable…
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…
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…