Post reply

Pass Multi-Value 'All' Parameter Value to Drill Through Report

  • September 15, 2010 at 8:25 am

    #224066

    I'm trying to figure out how to pass the 'All' value to a drill through report but don't seem to be having any luck. I can pass dates, etc. from other parameters, just having trouble passing the 'All' for the multi-value parameter.

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • September 15, 2010 at 9:16 am

    #1221427

    Use the VB Join() function to pass all of the items.

    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

  • September 15, 2010 at 11:24 am

    #1221556

    WayneS (9/15/2010)

    Use the VB Join() function to pass all of the items.

    Not exactly familiar with usage on the Join() function. I know I would put it in the 'Parameter Value' for the Parameters to pass on the Jump to Report area of the textbox I'm wanting to setup navigation on. But it doesn't seem to be working when I put it in as such:

    Parameter Name Result

    Parameter Value =Join(Parameters!Result.Value, ",")

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

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

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