In SSRS, is it possible to have a section header for one column and a chart for each section?

For example I have a location column, I want to use the location column as a section header and in each location section, I want to display a chart about this location.  Any idea?  Thanks.
thomaszhwangAsked:
Who is Participating?
 
itcoupleConnect With a Mentor Commented:
Hi

SSRS is quite flexible and that should be possible however I cannot fully picture your idea. Are you able to provide an example of the expected result (excel or pain).

Regards
Emil
0
 
thomaszhwangAuthor Commented:
Here is an example:

Sales Amount by Location by Salesperson Report [This is the report name]

Seattle, WA [This is the section header]
[Followed by a column chart to display the sales amount for each salesperson in Seattle, WA]

Chicago, IL [This is another section header]
[Followed by a column chart to display the sales amount for each salesperson in Chicago, IL]

[Repeat each location we have in the database...]
0
 
itcoupleConnect With a Mentor Commented:
From my understanding you should have a dataset with the following columns:

Location, salesperson, total

On the report drag location (you might have to group by location) and inside group add row below and add your chart. It should understand it is for a specific group.

Hope that helps and is what you are after
Emil

0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
thomaszhwangAuthor Commented:
Yes, you are right.  I have those three columns.

Which report item should I use?  Thanks.
0
 
itcoupleConnect With a Mentor Commented:
From toolbox you should add table. It might be best to find a tutorial on google. Should be easier than me explaning it.

I will ask my wife to send you a report, It will be 2008 R2 but should work with 2008.

Regards
Emil
0
 
thomaszhwangAuthor Commented:
Thanks, actually I'm using R2 as well.
0
 
itcoupleConnect With a Mentor Commented:
Hi

See below report. Let us know if that is more or less you had in mind

 location by salesperson
Regards
Emil & Katie
0
 
thomaszhwangAuthor Commented:
OK, this is good, but what in my mind is I want to show it in a column chart.  For example, in Chicago, the salesperson d, e and f should be in one chart instead of show as three rows.

Does this make sense?  Thanks.
0
 
itcoupleConnect With a Mentor Commented:
From what I understand you want just column bar for location? without details? Is that correct?
0
 
thomaszhwangAuthor Commented:
Something like this.  Thanks.

Report
0
 
itcoupleConnect With a Mentor Commented:
I must admit I intially thought you want it this way but I deliberately used data bar for several reasons:
1) Charts usually present time which is not in your case
2) DataBar saves space and allow to more easily compare sales people because the bar is horizontal and does not contain space
3) You can easily sort it by values and sales person name using interactive sorting option.
4) What I don't have in my case is 'scale' which I could add.
5) You can easily add more information in extra columns

Anyway this was my reasoning. I will do second version like you want it and send you both of them. I hope to do that today (evening UK time).

Regards
Emil
0
 
itcoupleConnect With a Mentor Commented:
Hi

I attached zip file that contains two rdl files one with data bar and second one with column bar chart.

 SalesByLocation.zip

Hope that helps
Emil
0
 
thomaszhwangAuthor Commented:
Thanks Emil.  I really appreciate this.  I will present both to my boss and see which one he likes.  I will keep this thread open for now, just in case I encounter any issue when I actually start to work on it.
0
 
itcoupleConnect With a Mentor Commented:
Let me know how it goes. I have period where I don't reply in EE so if you don't hear from me feel free to send me an email emil at itcouple co uk

Regards
Emil
0
 
thomaszhwangAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.