Post reply

Show a Customized Text in the Prompt List

  • November 7, 2013 at 2:55 am

    #282222

    Goal:

    Display the text "All State-Province" instead of "All geographies" at the prompt list in SSRS

    Problem:

    I tried googling around and in the end I don't know how to solve it.

    Information:

    I'm using SQL server 2012

  • November 7, 2013 at 7:54 am

    #1664779

    Surely you can just use the Iif function in the calculated member since member caption is a text value.

    I.e.

    WITH

    MEMBER [Measures].[ParameterCaption] AS

    Iif([Geography].[State-Province].CurrentMember.Member_Caption = "All Geographies","All State-Provinces",

    [Geography].[State-Province].CurrentMember.Member_Caption)

    MEMBER [Measures].[ParameterValue] AS

    [Geography].[State-Province].CurrentMember.UniqueName

    MEMBER [Measures].[ParameterLevel] AS

    [Geography].[State-Province].CurrentMember.Level.Ordinal

    SELECT

    {

    [Measures].[ParameterCaption]

    ,[Measures].[ParameterValue]

    ,[Measures].[ParameterLevel]

    } ON COLUMNS

    ,[Geography].[State-Province].ALLMEMBERS ON ROWS

    FROM [Adventure Works];

    Or failing that the parameter datasets generated by SSRS use a formula to indent the members and you could change the parameter caption here. Protip: you need to right click datasets and check "Show Hidden Datasets". In there you should see an SSRS calculated field named ParameterCaptionIndented. You can change the formula in here to do the replace.

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

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