Post reply

(Select All) option in Drop down list in, Reporting Services, SQL Server 2005

  • June 1, 2009 at 8:46 am

    #210218

    Hi,

    When creating a parameter for a drop down list, (Select All) option is included in .rdl, but when I publish the report to Report Manager,

    (Select All) option disaapeared. Can some one help me to solve this problem?

    Thank you.

  • June 1, 2009 at 8:18 pm

    #1003124

    You need to make sure you are on SP2 or higher with SSRS 2005. Sounds like you are still on SP1 when this was removed and this was primarily for SSAS because it does not leverage the 'All' member in the dimension which is a performance hit.

    What's new with SSRS 2005 SP2

    You will probably want to go with SP3 which was released this past December.

    SQL Server 2005 Service Pack 3 (SP3) – now available

    You can check your build number to verify this, but I would guess that you are on SP1.

    SQL Server 2005 Build List[/url]

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

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

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