Post reply

SSRS report with Multi Value and Null Parameter

  • September 30, 2010 at 8:22 pm

    #1229992

    can you please show me how can I implement this with respect to your option ONE? Thanks for your time and effort.

  • September 30, 2010 at 11:49 pm

    #1230041

    Hi Zombi,

    i think you have a similar scenario as me.

    If your table do indeed have null values for that field and you like to select those null value.

    Heres what i did,

    CASE WHEN FieldX is null THEN 'None' ELSE FieldX END

    Then default the 'None' as the value for the multiple selection

    If your table do NOT have null values but you would like to use blank selection as selecting everything.

    Default ALL for the multi selection.

    As long as there are default, your users do not need to enter if they do not wish to.

  • October 1, 2010 at 6:19 am

    #1230144

    Zombi,

    Glenn had two suggestions. The first doesn't seem to apply to you. The second is actually the same as option#3 I presented earlier. Option 3 is definitely easy to implement but it is inefficient if you have a large table you're querying against. Would you want to try that first?

    -Vince

  • November 2, 2010 at 8:02 am

    #1245389

    shanu.hoosen (9/28/2010)

    Hi Zombi,

    Does your data contain NULL?

    or do you want to retreive everything when NULL is passed?

    I'm not understanding your reqiurement

    Hi,

    I've similar exact same issue.

    In my case, If NULL is passed (means,at run time in parameter field we don't pass any value) then report should retreive everything. I'm running my report against Oracle 10.

  • November 4, 2010 at 12:51 am

    #1246389

    Not too sure on the p-sql

    but heres t-sql

    declare @p int

    begin

    if @p is null

    select * from dataset

    else

    select * from dataset where @p=' values'

    end

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply