February 11, 2014 at 11:19 am
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?
February 12, 2014 at 4:26 am
Default Values -> Specific Values -> fx
Then copy this: =new Integer(){0,1}
Hope it works
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply