Post reply

SSRS Mulitvalue parameters--get field value for individual parameter

  • June 8, 2009 at 8:30 am

    #205988

    Hi,

    I have a report which has to select multivalue parameters.I have to select the parameters say 'level' which is a multivalue parameter.

    Now my dataset query will be

    select product_sum,-------

    from-----

    where --=@level

    Now if I select parameters (level1,level2,level3..) I will get field value as the combined value of the selected parameters.

    In my report I should have column for each parameter selected.For example if I select level1,level2,level3 as parameters I should have 3 columns product_sum(level1) which should have values of level1,product_sum(level2) which should have values of level2,product_sum(level3) which should have values of level3.

    Is there any way to dynamically get the field value of each parameter.

    Thanks

  • June 21, 2009 at 1:48 am

    #1012977

    Hi

    I think first you need to update your query so that it will also display all selected levels

    "Select levelname,product_sum from tablename where levelname = @level. Now you will get your o/p with all level names, and product sum. In matrix, in the column cell you can place

    ="place_sum(" + levelnames + ")". and in data cell you can place your measure. HOpe this will help you.

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

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