locked
Trying to pass a multi value parameter to a sub-report RRS feed

  • Question

  • I'm using: Microsoft Visual Studio 2005 with SQL Server 2005

     

    I have a sub-report that uses a multi value parameter (@Employee)

    When I run it by itself it runs correctly.  However when I try to run it as a sub-report, I get "Error: Sub-Report can not be shown".

    I commented out the parameter and the sub-report displays fine, so I know this is the issue.  When I mapped the parameter to the sub-report, I pass the Parameter Name of "Employee" and the Parameter Value of "=Parameters!Employee.IsMultiValue"

    Am I missing a step?

     

     


    -Pat
    Saturday, January 8, 2011 4:53 PM

Answers

  • I'm using: Microsoft Visual Studio 2005 with SQL Server 2005

     

    I have a sub-report that uses a multi value parameter (@Employee)

    When I run it by itself it runs correctly.  However when I try to run it as a sub-report, I get "Error: Sub-Report can not be shown".

    I commented out the parameter and the sub-report displays fine, so I know this is the issue.  When I mapped the parameter to the sub-report, I pass the Parameter Name of "Employee" and the Parameter Value of "=Parameters!Employee.IsMultiValue"

    Am I missing a step?

     

     


    -Pat

    While passing Multivalue parameters to either a Sub Report , Got to Report or Jump to Report ,

    make sure that destination report accepts parameters of type multivalue .

    And this is how we map the multivalue parameters from main report to sub report [ second report ]

    =Split(join(Parameters!ParamName.Value,","),",")

    Thanks .


    Rajkumar Yelugu
    • Marked as answer by Pcrews Sunday, January 9, 2011 3:10 PM
    Sunday, January 9, 2011 5:42 AM

All replies