I have an SSRS 2008 R2 report that contains a line chart. The data source is a SQL Server 2008 R2 stored proc. The chart can contain up to eight series. Those series can be hidden/shown based on data returned from the query. The chart reflects measures of Key Indicators. With my current steup, I can I have one chart show measures of up to thirty Key Indicators. Up to this point, I have been able to use one chart instead of thirty charts. However, now I have a problem. For some of my Key Indicatrors, I need to return a percentage instead of an integer. I need to have a secondary chart axis scaled to the percentage, and I don't see a way to programmatically create a secondary axis. One thought is to create the secondary axis for the single chart, and hide it if none of the numbers return a percentage (?). I'm really hoping that this accomodation for percentage values dosen't mean I have to create thirty charts. If you have some ideas on this, please let me know. Thank you for your help. cdun2

Never mind on this. I set my query up to return 'Format' information about my data columns to the report. With that, I can hide/show the axis labels and the first and last label on the axis. Just by doing that, I can effectively show and hide the secondary axis.

Hi cdun2, Thank you very much for your sharing. This is very helpful. I believe other community members who face with the same issue will benefit from your answer. Thanks, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.