Value display in Filters for report

Posted on 2013-06-20
Last Modified: 2013-07-17
I'm working on a .rdl report in VS2008/SQL server 2008 R2.  

Please see the attached file. When I preview the report, the Year filter contains all year options (Fig 1). If "Select All" is selected, all drop down items (2009,2010,2010,2012) are displayed in the box (Fig 2). I would like to display the word 'All' instead of all year values when 'Select All' is selected.

Is there a way to do it? How can I achieve it?

Thanks for any help.
Question by:minglelinch
  • 2

Accepted Solution

Prakash_Kavar earned 500 total points
ID: 39265317
From where you fetch Fiscal year value?

if from dataset than in the query use

select "ALL" as fiscal_year
select yoryearcoloumn as fiscal_year from yourtable

and in the main data set query use like
where (year=@fiscal_year or "ALL"=@Fiscal_year)

if yu given defualt value in parameter than add ALL as labele in one value

Author Comment

ID: 39265982
Thanks for comments. I think I made a little confusing here. Please see the updated attached file.

The label 'Select All' is fine, and it is like the tool default.

The label “Select  All” is fine. When this item is selected,  year values ‘2009, 2010, 2011, 2012’ all are displayed in the Fiscal Year  box. I want the label ‘All’ or ‘Select All’ instead of ‘2009, 2010, 2011, 2012’ is displayed in the box.

Author Closing Comment

ID: 39333449

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Generate Weekly Schedule 15 28
MSSQL Speen Degradation 4 22
Addition to SQL for dynamic fields 6 38
SSRS - How do I get a year value to display based on the current month? 8 40
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question