Post reply

problem with parameters multivalue in ssrs

  • July 3, 2009 at 5:19 am

    #211646

    About reporting services....

    I have a matrix in a report and when i clik the cell it 'jumpt to report' to second report and this is filtered by the parameters(from first report). I set the 'navigation' properties. The first report has a parameter multi-value, and i set the parameters in navigation :

    parameter name : OlapProyect2

    parameter value : ="[Olap].[Proyect].&[" + Parameters!OlapProyect1.Value(0) + "]"

    , but the parameters is multivalue and not singlevalue.

    i know do it with single but not multi.

    I want filter the second report by all filters values and not by one.

    How can I do it?

  • July 3, 2009 at 5:49 am

    #1019721

    If I remember correctly (and it's been a year since I did any SSRS), just remove the "(0)".

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • July 3, 2009 at 6:36 am

    #1019745

    WayneS (7/3/2009)

    If I remember correctly (and it's been a year since I did any SSRS), just remove the "(0)".

    if i remove (0) is error, because the parameters is multivalue, and not single.

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

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