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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

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...]

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Yes, you are right. I have those three columns.

Which report item should I use? Thanks.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks, actually I'm using R2 as well.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

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.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Something like this. Thanks.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

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.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.