• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 434
  • Last Modified:

Is it possible to change the (select all) to (all dates) in the multi-select parameter selection list in SSRS?

Hi Experts, hopefully an easy question? Is it possible to change the '(select all)' to '(all dates)' in the multi-select parameter selection list in SSRS? This seems hardcoded somewhere?

Many thanks!
0
Papa1NZ
Asked:
Papa1NZ
  • 3
2 Solutions
 
Koen Van WielinkIT ConsultantCommented:
No, as far as I know it is not possible to change this.
What you could do is create a manual parameter value list where you add an option "all dates". In your underlying SQL statement you can then change it in such a way that when "all dates" is selected you include all the dates in your query.
0
 
Koen Van WielinkIT ConsultantCommented:
Just to clarify a bit further, your parameter list query could look something like this:

select NULL as 'Value'
, 'All dates' as 'Label

union all

Select distinct yourDateField as 'Value'
, CONVERT(nvarchar(12), yourDateField, 103) as 'Label'
from yourTable
Where "apply your selection criteria here"

Open in new window


When a user selects "All dates", you change your main report query to include all your selected dates, otherwise you include only the selected dates:

IF @date is null
Begin

Select your report records without a date filter, or to include all desired dates

End

else if @date is not null
Begin

Select your report records with the date parameter in the where clause

end

Open in new window

0
 
Koen Van WielinkIT ConsultantCommented:
By the way, the "103" in the convert statement refers to the style of the date as a string. More here: http://msdn.microsoft.com/en-us/library/ms187928.aspx
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now