CODEWITHSUNDEEP
visual-studioreporting-serviceschartsssrs-2008
ola
ola

Reputation: 912

Chart for each table row SSRS

I am trying to create a report and I cannot figure out how to run/group the information. I am using VS 2008 R2 SSRS reporting services.

For the report, I have a list of questions. These questions are asked by a group of people over a period of time. For each question, I need a chart that displays the answers for each person in a bar graph. For example:

How is your day?

Person 1 -------great--------|---bad--|------okay----------|

Person 2 --great--|-------bad-------|--------okay----------|

Person 3 --------great------------|--bad--|------okay------|

The above would symbolize a chart with the amount of time the person answered 'great', 'okay' or bad throughout a period of time.

My question is, how do I create such a chart (an actual chart not a text representation) in the table so that the chart will follow each question. I will have anywhere between 5-10 questions all of which need a chart displaying the results.

I am at a loss here. I don't know SSRS very well and I have been unable to create anything other than a data bar in the table.

Any help is appreciated!

SOLUTION: I have solved the problem by using a list with a row group grouping by question. I can then add a chart into the list and format the chart accordingly.

Upvotes: 0

Views: 2254

Answers (1)

kyzen
kyzen

Reputation: 1609

Sounds like you might like sparklines and databars!

http://technet.microsoft.com/en-us/library/ee633676.aspx#DataBars

http://blogs.msdn.com/b/seanboon/archive/2009/11/23/an-introduction-to-data-bars-in-sql-server-reporting-services-2008-r2.aspx

Upvotes: 1

Related Questions