Post reply

Multi-Value parameter conditions question

  • September 14, 2006 at 1:05 pm

    #115349

    My multi-value parameter has four values entered in it. Each entry in the multi-value parameter selection has a different condition attched to it.

    My Question is How do I attach those conditions to each entry and assign the result as a paremeter to the main query.

    Please help me in generating above condition.

  • September 15, 2006 at 3:04 am

    #660633

    you can either pass the parameters to a stored procedure on which you base you dataset or use the parameters, e.g. with IIF, to build an SQL string in Report Designer.

  • September 15, 2006 at 7:27 am

    #660688

    Thanks Jon Spink. I have done those vaidations behind the scenes in VIEW and using that in SSRS.

    Thanks

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

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