So i am using SSRS 2008, I have a few questions about working with charts. I have a Stacked Bar chart im trying to work with and in my series i have it separated by what is called a revenue bucket and then by year. The only problem is that the stored procedure is passed a number instead of the actual label that i need to have on the legend for the revenue bucket. Is there anyway to get the label in there other than making an expression in the Series Group Properties Label field to make sure the correct labels print out? Or would this be my best option to just make the expression? Also I have a multi select parameter for the revenue bucket and i need to be able to print out multiple revenue buckets if multiple values are selected. So if Example1 is selected the title prints out "Example2 Revenue Bucket" If Example1 and Example2 is selected the title then prints out "Example1, Example2 Revenue Bucket" I know this is possible because i've done it before, i just forgot what is necessary. Any help on either of these issues would be great!

For the chart: It would be best to modify the stored procedure to return the Label you require. To display multiple revenue bucket labels you need to use the JOIN expression in your text box with a comma separator. see http://munishbansal.wordpress.com/2008/12/29/passing-multi-value-parameter-in-stored-procedure-ssrs-report/ or http://www.lukehayler.com/2009/08/the-join-function-in-ssrs/My Blog "Karl Beran's BI Mumble"

For the chart: It would be best to modify the stored procedure to return the Label you require. To display multiple revenue bucket labels you need to use the JOIN expression in your text box with a comma separator. see http://munishbansal.wordpress.com/2008/12/29/passing-multi-value-parameter-in-stored-procedure-ssrs-report/ or http://www.lukehayler.com/2009/08/the-join-function-in-ssrs/My Blog "Karl Beran's BI Mumble"

Thank you so much!! Both worked great!!