Format Analysis Services parmeter in chart title
I'm making a Reporting Services chart report using an Analysis Services dataset. There is one parameter for the chart and I would like to put the parameter value in the chart title. Normally when I do this for reports using other datasets I just right click the text box, select Properties, click the function buttion, select Parameters in the Category list and double click what is listed in the Values list. The following is an example of the expression that is always generated. =Parameters!OriginationDivision.Value Usually the above expression just returns the value selected in the parameter. For example, "East". However this is what is appearing on this chart I'm working on - [Origination Division].[Origination Division].&[East]. Is there a way to just get the value without all the preceding information without having to write a complicated expression? Kevin
October 4th, 2012 4:17pm

Try switching it to =Parameters!OriginationDivision.Label, if your Parameter Label is seperate from the Value (EG: you select "East" from the drop down and it passes [Origination Division].[Origination Division].&[East] to the DB) that should work.
Free Windows Admin Tool Kit Click here and download it now
October 4th, 2012 6:04pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics