Search code examples
visual-studiot-sqlreporting-servicesreportssas

SSRS - Parameter - SELECT ALL vs ALL - How to remove ALL option


Please look at this ss Screenshot

I am using SSRS 2008 + pulling data from a cube and made Country my parameter.

I want to keep "Select ALL" option but remove "ALL" option.

How would I go about doing that?

Thank you


Solution

  • You need to replace the ALLMEMBERS function with the CHILDREN function.

    http://www.bidn.com/blogs/ChrisAlbrektson/bidn-blog/1452/mdx-ssrs-how-to-remove-the-all-member-from-your-parameter <-- will show you what I mean