SSRS Interview Question and Answers - How to Create Calendar Parameter in SSRS Report

Parameter/s are used to filter report data. We often has column/s in table which are date or datetime type. If we would like to use those column/s in our SSRS Report, we can create the parameter and have the Calendar icon to choose date.

Let's say we have a column in a table such as CreatedOn of Date type, we can write our query as below


SELECT Col1Name
 ,Col2Name
FROM dbo.MyTable
WHERE CreatedOn = @Param_CreateDOn

If we have column which is datetime and we would like to use only date part of it to filter our records by using parameter, our TSQL Query will be like below

SELECT Col1Name
 ,Col2Name
FROM dbo.MyTable
WHERE Cast(CreatedOn AS DATE) = @Param_CreateDOn


After using the query in SSRS Report, we will see the Text Box for our parameter. As we want to have the Calendar, we need to change the parameter Data Type.
Right Click on the Parameter, go to properties and change the data type to Date/Time as shown below.

How to show calendar Parameter in SSRS Report - SSRS Interview Question


Calendar Parameter in SSRS Report - SQL Server Reporting Services(SSRS) Interview Questions and Answers





5 comments:

  1. This post is amazing I am a developer and I have my own Android app developers team after reading this blog I decided to create an application that will create calendar parameter reports daily

    ReplyDelete
  2. I have an ecommerce business of fLV Neverfull Tote, due to which I cant do my Spss assignments. Anyone can provide me Spss assignment writing services?

    ReplyDelete
  3. Giving an interview for the first time seems like a nervous task but if you prepare yourself for the interview question and answers you can have a better results. To share interview questions and answers you need to buy a domain name where you can share your experience and share the interview questions and answers.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. The SSRS is the advanvced pattern of sharing the reports. The making of calendar is also one of the questions that can be asked during interview. Maria B Wedding Unstitched is one of the finest women dress that can be found very hardly.

    ReplyDelete