Power BI

SSRS: IIF statement with grouped and summarized data

Switch Function Nested IIF statement IIF statement Data source: sample data Dataset: SELECT [product_brand] ,[product_name]...

SSRS: Create a Sub Reports and Call it in the Main Report

Marek Vavrovic

Sep 5, 20211 min read

SSRS: Create a Sub Reports and Call it in the Main Report

This demo will explain how to create a simple sub report which will be displayed in the main report. In order to make this works both...

Stored Procedure with IN operator in SSRS

Marek Vavrovic

Sep 4, 20211 min read

Stored Procedure with IN operator in SSRS

Data source: sample data Data set: stored procedure Create PROC dbo.uspSales @Region nvarchar(50) AS BEGIN SET NOCOUNT ON; DECLARE...

Marek Vavrovic

Sep 4, 20212 min read

SSRS: Bookmarks

SSRS bookmarks are customized navigational links in the report. The bookmark can be any string, but it must be unique in the report. If...

Marek Vavrovic

Sep 3, 20212 min read

SSRS: Drill Through Report

Demo : I want to create a drill through report like this one. If you click on the country, you'll be transferred into the second report...

Marek Vavrovic

Sep 1, 20211 min read

SSRS: Cascade Parameter

Data source: Northwind database Dataset: SELECT c.Country,c.City,c.CompanyName,c.ContactName,c.ContactTitle, od.Quantity,od.UnitPrice...

Marek Vavrovic

Sep 1, 20212 min read

SSRS: Boolean Parameter

Data source: ContosoRatailDW Date set: DimEmployee Fields that can be used for the Boolean parameter must have bit data type ....

Marek Vavrovic

Aug 31, 20212 min read

SSRS: Text Parameter

Parameter: Specify values Demo 2:Parameter: Get values from a query. Demo 1 Data source: database Northwind Data set: Step 1 Create a...

Marek Vavrovic

Aug 31, 20211 min read

SSRS: Running total

Step 1 Create a data source and a dataset Step 2 Add an extra field for the Running total. Add an expression. Step 3 Go to Common...

SSRS: List: Writing Christmas Bonus Letter.

Marek Vavrovic

Aug 30, 20212 min read

SSRS: List: Writing Christmas Bonus Letter.

Demo: I want to create a letter which will look like this Data source : NorthWind database Data set: Use Northwind; go Select...

SSRS: Display all the table rows on a single page

Marek Vavrovic

Aug 29, 20211 min read

SSRS: Display all the table rows on a single page

Press F4 to display Report Properties Go to Page > InteractiveSize. Set Height: 0 Note: you may have a performance issues by large amount...

SSRS: Report Name and Headers on Each Page

Marek Vavrovic

Aug 29, 20211 min read

SSRS: Report Name and Headers on Each Page

Step 1 Right click on the report page > Add Page Header [or Page Footer] . Every information residing on Header or Footer will be...

Marek Vavrovic

Aug 29, 20211 min read

SSRS: Report Items: List

Data source : NorthWind database Dataset: Select c.Country, c.City, c.CompanyName, SUM(od.Quantity) Quantity, SUM(od.UnitPrice) UnitPrice...

Marek Vavrovic

Aug 28, 20212 min read

SSRS: Grouped Report with Drilldown

Demo: What do I want to create: Data source: connection to NorthWind database Dataset: Select c.Country, c.City, c.CompanyName,...

SSRS: Create Grouped Report with subtotals

Marek Vavrovic

Aug 28, 20211 min read

SSRS: Create Grouped Report with subtotals

Data source: connecting to database Northwind Dataset: Select c.Country, c.City, c.CompanyName, SUM(od.Quantity) Quantity,...

SSRS: Create a Report with the Report Wizard

Marek Vavrovic

Aug 27, 20211 min read

SSRS: Create a Report with the Report Wizard

Data source: database Northwind Dataset: Select c.Country, c.City, c.CompanyName, SUM(od.Quantity) Quantity, SUM(od.UnitPrice) UnitPrice...

Marek Vavrovic

Aug 26, 20213 min read

SSRS: Data sources, Data sets

Data source specifies a database connection. Can be either shared or embedded. Best practise is to use shared data source. Shared Data...

Power BI

SSIS

Import .CSV files from web site

Data Refresh - Expression.Error column not found

Covid-19 Dashboard

AdventureWorksDW2017 Dashboard

Wide World Importers Dashboard

Slovakia covid-19

DAX measures for Covid-19

Tesla 2009-2020 Financial reports analysis

Covid 19 Dashboard (OWID)

Huffner Textile Dashboard

Northwind dashboard

File System Task

Sequence Container

Execute SQL Task

For Loop Container

Foreach Loop Container

Project Deployment Model

Slowly Changing Dimensions

Lookup Transformation

Derived Column

Union All vs Merge Transformation

Merge Join

SSIS Access is denied

Expressions, Parameterized con.

SCD using Lookup and Conditional Split

Append tables

Power BI

SSRS

DAX

Data Source , Data Set in SSRS

Tabular Report with Wizard

Grouped Report with Subtotals

Grouped Report with Drilldown

List: Group on Page

List: writing a letter

Headers on Each Page

Table rows on a single page

Running Total