I had a chart series with an action property to a self report ( same report with the chart on). The idea is to generate data on a tablix for the month click on the same. The parameter is Month and value is Datemember ([Dim Time].[Calendar].CurrentMember.UniqueName). The expression for the label on the tablix is: = "Sales for" & Fields!Month.Value & ", " & Fields!Year.Value But each time I click each month of the chart series, only the name of the current month is showing and only the data for the current month is showing. The chart is showing different value for the month but it is not sending this value to the tablix even though I set parameter to the chart series and month with value datemember. What could be an issue here. The mdx for the chart dataset and the tablix is posted below: Chart Query SELECT NON EMPTY {[Measures].[Prompt Pay Pct], [Measures].[DateMember] [Measures].[Amount], [Measures].[Cost], [ } ON COLUMNS, NON EMPTY { ([Dim Time].[Calendar].[Month].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@TimeCalendar, CONSTRAINED) ) ON COLUMNS FROM [SSASCube] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS Tablix Dataset Select NON Empty [Amount], [Measures].[Cost [Measures].[DateMember] } ON COLUMNS, NON EMPTY { ([Dim Other Invoice].[Invoice Type].[Invoice Type].ALLMEMBERS * [Dim Sales].[Age].[Age].ALLMEMBERS * [Dim Time].[Month].[Month].ALLMEMBERS * [Dim Time].[Year].[Year].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@YearCalendar, CONSTRAINED) ) ON COLUMNS FROM [SSASCube]) WHERE ( IIF( STRTOSET(@YearCalendar, CONSTRAINED).Count = 1, STRTOSET(@YearCalendar, CONSTRAINED), [Dim Time].[Calendar].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

I used action property on a series of a chart to be applied on the same report that the chart is. The action property parameter value is ([Dim Time].[Calendar].CurrentMember.UniqueName). But the issue is that the action only work on February which is the current month and not on January. I check everything I could check but the action work only on current month and not on other months. What could be the issue?

Hi, Are you able to see the link and a request to SQL Server is going when you click on January? Figure out if it is an issue with Reporting services or the database. You can do this by using profiler if that is a development environment. You can also look at ExecutionLog table to see the time taken to execute the request and get the work done VS where it failed. This may not give full information but could be an input that you can consider. Regards,Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

Hi Projack, Firstly, you should create three parameters Month, Year and SalesAmount, make sure these three parameters is hiden and set Allow Null Value, then add an action to chart's data label to go to the report itself, please give values for these three parameters, then just drag a textbox to your report body, then type in below expression: ="Sales for:" & Parameters!Year.value & Parameters!Month.value & CStr( Parameters!SalesAmount.value) If you have any question about the steps please feel free to ask. Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.