CODEWITHSUNDEEP
sqlsql-serverreporting-services
TheProgrammer
TheProgrammer

Reputation: 1344

How to add SQL query parameters into service report

I have a query with the parameters @startDate and @endDate. They are not apart of the table columns/fields. Is there a way to show the startdate and enddate in the report using the business intelligence development studio? My main goal is to show the dates for which the data I am returning occurred. The query is shown below:

DECLARE @return_value int

EXEC    @return_value = [dbo].[usp_GetSystemAvailability]
    @startDate = N'12/31/2013',
    @endDate = N'1/9/2014'

Upvotes: 1

Views: 180

Answers (1)

M.Ali
M.Ali

Reputation: 69494

You will need to add a text box some where on your report and add an expression something like 

="Start Date: " &  Format(Parameters!startDate.Value, "dd/MM/yyyy")  & " and End Date: " 
  &  Format(Parameters!EndDate.Value, "dd/MM/yyyy")

Assuming StartDate and EndDate are the names of your report parameters.

Upvotes: 1

Related Questions