Reporting Services --> dynamically change chart type.

[Nuovo2004]

Hi Guys,
Working on some reports right now and the guy from sales likes bar charts and the girl in marketing likes pie charts.
Simple solution right? Be able to toggle from one chart type to another!
I'm actually having trouble doing this. I'd like to simply modify the report.type property from column to pie but I don't see a way to do this yet.
I sloppy solution is to have two identical reports with different chart types and navigate from one to the other but I'd hate to do that!
Has anyone tried this yet with Reporting Services?
Thanks and I'll let you know if I find a cool way to do this.

 

[jmk418]

what if you set up a paramater that let the user select which type of report they would like to see i know that means creating to seperate reports but it would give the user more flexability