HDTutorial
EN
SSRS Tutorial 90- How to Create SSRS Report with Dynamic Columns ( Source Definition Change)

Playback starts YouTube’s embedded player (privacy-enhanced mode).

SSRS Tutorial 90- How to Create SSRS Report with Dynamic Columns ( Source Definition Change)

64,470 views October 25, 2015 29:22

Watch on YouTube
ChannelTechBrothersIT

Description from the creator

In this video of SSRS Tutorial, we are going to create a report in which the number of columns can change anytime. This report that we want to create should be Tabular report ( Detail Report).

The problem with the scenario is , we are using a table/view in which we can add or drop columns anytime. If we create simple tabular report , the problem is that every time our Table/View Definition change, we have to alter our report definition and redeploy.


In this video, we are going to learn some tricks, How to create report with Dynamic Columns. Here are the steps involved


We will create our SQL queries with Unpivot, Convert the columns to the Rows

Use Matrix Item in SSRS Report, so the dynamic columns can be handle dynamically

Use the Primary Key or ID as part of Rows so we have detail level data

Delete the Row level Column to hide the Primary Key

Change the definition of Table/View and check if everything working for our Dynamic Column SSRS Report

Visit our website to check out SSRS Tutorial Step by Step
techbrothersit.com/2015/07/ssrs-video-tutorial.…

link for the script used in the demo
techbrothersit.com/2015/09/ssrs-tutorial-90-how…

About this tutorial

TechBrothersIT published this 29:22 video tutorial on October 25, 2015. It has been watched 64,470 times on YouTube.

Duration
29:22
Published
October 25, 2015
Views
64,470
Likes
215

Tags

Share

Further reading

This tutorial in other languages