Post reply

MultiValue Parameters in SSRS

  • June 1, 2009 at 7:55 am

    #210315

    Hi,

    We have a report which have to select multivalue parameters for the products.Inthe report we need to caluculate calls for each product.Now when I select multivalue parameters say p1,p2,p3 then is it possible to generate a report so that there will be columns calls(p1),cals(p2),calls(p3).

    If I select 5n parameter values then there should be 5 columns one for each parameter selected.Is there any way to do this SSRS 2005

    Any help would be appreciated.

    Thanks,

  • June 2, 2009 at 7:50 am

    #1003420

    How about setting the hidden property of the field to conditional based on teh value being NULL?

    Rog

  • June 2, 2009 at 9:43 am

    #1003485

    Roger has the right idea. Using a table control there is no way to dynamically add columns. You can hide columns though.

    The matrix control does add columns based on the data, but is really a pivot table/cross tab control.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • June 2, 2009 at 10:10 am

    #1003508

    Roger ,

    Thanks for the reply.

    I tried using the expression

    =iif(Parameters!product.Value(0)="column1",false,true)

    But I got an error index was outside of the bounds of array.

    Any ideas,

    Thanks

  • June 2, 2009 at 11:46 am

    #1003561

    I have given hidden expression as

    IIF(Parameters!PRODUCT.Value(0)="product1",false,true) for first column

    IIF(Parameters!PRODUCT.Value(0)="producr2"",false,true) for second column

    .

    .

    .

    IIF(Parameters!PRODUCT.Value(0)="producrt..n"",false,true) for n th column

    This works well if one parameter is selected.But when I select more than one parameter ,I could see only the first column of the selected parameter.I am not able to see remaining columns.

    For example if Iselect product1,product2,product5 in the parameters I could see only product1 column.

    Is there any way I could see product1,product2,product5 columns?

    How to hide or show columns when multivalue parameters are selected

    Any ideas on this

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

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