Multivalue with Null value SSRS 2005

[schmidtkaren]

I have a query to populate a multivalue parameter:
SELECT distinct cast(AGRPYear.value as varchar(4)) + AGRPMonth.value
'ReportDate'
FROM TPROJECT AS TPROJECT

One of the values that is returned from this query is NULL. However, when I
run the report, the NULL value does not show in the dropdown. I've also
tried adding
"select NULL as 'ReportDate' union" to the above query and the null value
still doesn't show.

As a result some of the records in my database have a null value for this
field, they will never show up on my report. Any ideas?

--
Systems Analyst
Office of the Auditor General of Alberta

[Uri Dimant]

Hi
Why do you want to show NULL? Does it mean if he/she click on NULL you show
all rows?

<schmidtkaren> wrote in message
news:0BF02C46-DF08-4C61...@microsoft.com...

[Rictastic]

> > Office of the Auditor General of Alberta- Hide quoted text -
>
> - Show quoted text -

Hi

I don't think you can have NULL = NULL in a where clause, the best way
to get around this would be to use ISNULL in both queries e.g. ISNULL
(year, "NoValue")
This way the "NoValue" (or whatever text value you want) will show up
in the multi-select drop down and work in the where clause

Rick
www.reportingservicestips.co.uk

[Uri Dimant]

Rick
Sure we cannot use NULL =NULL, I just tried to understand his/her
requirements

"Rictastic" <rickd...@gmail.com> wrote in message
news:b2ea773f-96ea-4047...@g27g2000yqn.googlegroups.com...

[Rictastic]

On 11 Nov, 10:35, "Uri Dimant" <u...@iscar.co.il> wrote:
> Rick
> Sure we cannot use NULL =NULL, I just tried to understand his/her
> requirements
>

> "Rictastic" <rickday...@gmail.com> wrote in message

> Rickwww.reportingservicestips.co.uk- Hide quoted text -

>
> - Show quoted text -

Sorry Uri, I was replying to the original "schmidtkaren" post, I just
got lazy and clicked the above reply button