March 4, 2008 at 8:00 am
I have a line chart that plots hours vs dates and there are currently 6 categories of hours so I have 6 lines on the chart. I would like to be able to hide categories 1,2, and 3 and add a new line that shows the sum of categories 1,2, and 3. Any ideas on how to do this? do I need to change by sproc that returns the data or can I do this in the Report? using SSRS 2005
Thanks
Dean
March 17, 2008 at 10:50 am
I would have thought this one was reasonably simple to do unless I am misunderstanding something. To not show categories 1,2 & 3 just remove them from the chart. To include a sum of category 1,2 & 3 add another category to the chart which is formed from an expression which is Fields!Category1.Value + Fields!Category2.Value + Fields!Category3.Value
This is very simple so I apologise if I have misunderstood something and told you what you already know. If this is the case, provide a bit more information on the problem and I'll see what I can do to help.
Good luck,
Nigel.
Nigel West
UK
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy