top of page
07479 744442
Home: SQL
Search


Marek Vavrovic
Apr 13, 20221 min read
SSRS Loan Statement
Using T-SQL Stored Procedure to create a report in Power BI Report Builder. Data set: Using T-SQL to create a bank loan statement...
2520


Marek Vavrovic
Sep 5, 20212 min read
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]...
2,3530


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...
1,6670


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...
3170


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...
3400


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...
2500


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...
490


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 ....
5,4520


Marek Vavrovic
Aug 31, 20212 min read