[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 342
  • Last Modified:

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.
0
thomaszhwang
Asked:
thomaszhwang
  • 8
  • 7
8 Solutions
 
itcoupleCommented:
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
 
itcoupleCommented:
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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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

Which report item should I use?  Thanks.
0
 
itcoupleCommented:
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
 
itcoupleCommented:
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
 
itcoupleCommented:
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
 
itcoupleCommented:
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
 
itcoupleCommented:
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
 
itcoupleCommented:
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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now