Post reply

passing null when all items chosen in multi select

  • May 18, 2009 at 1:54 pm

    #200650

    I have a dataset (dsCategories) that populates a multiselect drop down list (prmPropCat). If the user selects all the Categories in prmPropCat I want to pass null to the stored procedure instead of all the Categories. prmPropCat is passed as a parameter to another dataset called dsInfo. How do I compare the values in dsCategories and prmPropCat? This is what I have so far:

    IIF((Parameters!prmPropCat.Count = COUNT(Fields!CO_NM.Value, "dsCompanyList"), Nothing, Parameters!prmPropCat.Value)

    But I get an error that Fields cannot be used in the parameters tab.

    Thanks for the help!

  • May 19, 2009 at 1:51 am

    #996763

    Check your same post in another forum

    http://forums.asp.net/t/1424492.aspx

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

Viewing 2 posts - 1 through 1 (of 1 total)

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