Hi Mlalis, As Uri posted above, we should design two charts(eg: Pie Chart and Line CHart) with the same data. We can add a parameter to the report and then write an expression to control the visibility of the charts. For example, if we specify two default values which are “1” and “2” for the parameter. Set the expression to the “Visibility” property of Pie Chart: =IIF(Parameters!My_Parameter=”1”,TRUE,FALSE) Set the expression to the “Visibility” property of Line Chart: =IIF(Parameters!My_Parameter=”2”,TRUE,FALSE) So, if the user selects “1” in the parameter drop-down list, the Pie Chart will be hidden but the Line Chart will be shown. If you have any more questions, please feel free to ask. Thanks, Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi, I have one data set ,i have one parameter in that parameter list different types of charts(pie,line),based on user selection the data will appear that chart format,by default there is no data region ,how can we do like this Thanks in Advance Regards Mallis

Mallis You can put on the details section all charts to be designed for specific parameter format and just hide them or visible....based on chosen parameter Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Dimant, Thanks for reply,can u give brief description, and also provide navigation according to requirement Regards Mallis