Tutorial Videos

Get started with complete SQL Server Business Intelligence from choosing your programming language to understanding data components (databases, tables, views, functions, triggers, stored procedures, event handling), ETLs, Data visualisations (Reporting Services and Power BI), data modeling, data warehousing (Azure SQL Server, MDX, Cubes, facts and dimensions) and in-database analytics ( R Services in SQL Server) by watching our SQL tutorials. 
A sort expression controls the order in which data appears in a data region. You can add interactive sort buttons to enable a user to toggle between ascending and descending order for rows in a table or for rows and columns in a matrix. The most common use of interactive sort is to add a sort button to every column header. The user can then choose which column to sort by. 

SSRS reports are designed to display graphs, charts and KPI’s (Key Performance Indicators) very beautifully in the different kinds of the dashboards. A Key Performance Indicators (KPI) is any measurable value in our report that has business significance, for example, Total Sales. If we want to display the current state of a KPI's on a report, we can use one of three different approaches:

Drill-down describes an increasing granularity in the management of data with comfortable functions for navigating through the data where user is capable to jump to the next level of detail or the next report object on the same level, hide individual levels and switch between the detail and drilldown data information. 

These beautiful features bring a lot of satisfaction to report writer and developers to marge values from two datasets. These functions are is playing a very handy role to combine data from two datasets in a single data region which was not possible in earlier versions of Reporting Services.

Multi-value parameters allow us to select more than one value for a report parameter. To create a multiple values parameterised report, we must have to change report parameters properties from single valued to multi-valued and must have made the necessary changes in a query also, a filter, and an expression to accommodate using a multi-value parameter collection. 

SSRS - How to Create or Build Drill-Through in SSRS
A drill-through reports is the combination of the two reports. One report is known as the base or main report having link option to call another report. Another report is known as the sub report in this scenario and must have the parameterized functionality because drill-through reports commonly contain details about an item that is contained in an original summary report.

SSRS -  Read images data from the SQL Server database
SQL Server Reporting Services has a feature to read images data from the SQL Server database. To render the images on the report, we use the special report item called Image that contains a reference to an image that is embedded in the report, stored in a database, stored on the report server, or stored elsewhere on the Web. An image can be a picture that is repeated with rows of data. An image can be used as a background for certain report items also.


  1. Keep up the good work. I enjoyed watching a tutorial on YouTube which was clear, concise and answered the questions i had when working on a POC for my team.

  2. Information researcher's activity is favored worldwide and it additionally gives great pay bundles. ExcelR Data Science Courses

  3. Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.

    Data Science In Banglore With Placements
    Data Science Course In Bangalore
    Data Science Training In Bangalore
    Best Data Science Courses In Bangalore
    Data Science Institute In Bangalore

    Thank you..


  4. Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article.
    Data Science Course in Hyderabad

  5. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data sciecne course in hyderabad

  6. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, best online data science courses


Popular Posts

Get Sponsored by Big Brands