SSRS Interview Questions and Answers - What are range parameters in SSRS Report

Range parameters are used to choose a range of values. Let's say we would like to see data between two dates. We can create two parameters StartDate and EndDate.
The query to create date range parameters is shown below


SELECT FName
    ,LName
    ,SaleAmt
FROM dbo.TotalSale
WHERE SaleDate BETWEEN @StartDate
        AND @EndDate

We often use Range Parameters and configure them with default values to show records e.g
  • Get records from start of the year to date
  • Get records from start of month to date
  • get all records for current quarter etc.

2 comments:

  1. cheap mcqueen shoes, combining elegant style and cutting-edge technology, a variety of styles of cheap mcqueen tread slick boots, the pointer walks between your exclusive taste style.

    ReplyDelete
  2. Social media marketing is a strategic use of online social networks to promote a product or service. Although the terms e-marketing and digital marketing are still dominant in academia, social media marketing is becoming more popular for both practitioners and researchers. Social Media Marketing Agency Chicago

    ReplyDelete