Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 ssrs 2008 parameter default want to display
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

332 Posts

Posted - 02/11/2014 :  13:17:55  Show Profile  Reply with Quote
In an ssrs 2008 report, I want to add a parameter called Processed and have default values set so the
user does not have to select the parameters. The problem is the default parameters are not preselected
when the report is executed.

The following is the query for the dataset that is used for the parameter called Processed. This
is used under available values.

select DISTINCT IsNull(Processed,'') as Processed,
CASE IsNull(Processed,'')
WHEN 0 then 'Non Processed'
WHEN 1 then 'Processed'
END AS label
FROM [Items]
where Processed in (0,1)
order by label

The default values are set to 0 and 1. I also have the Allow Multiple values checkbox for the parameter checked(set).

The column called Processed as defined as 'bit'.

Thus can you tell me what you think could be wrong? Do I need to specify the bit values as
something else? If so, how should I refer to the values for bit?

Edited by - jassie on 02/11/2014 14:05:05

Posting Yak Master

120 Posts

Posted - 02/20/2014 :  15:12:30  Show Profile  Reply with Quote
is this select statment/case created first in a view? I find it much easier taking the tables I want do all my calculations in the views then import the data into ssrs.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000