What is the best way to approach report building form a single table?

Well this in my situation:

There is a single denormalized table, with one descriptive column, followed by 30 columns containing setting ( -1, 0, 1 ,2). My problem is that I only have this table as a data source and need to do a pie chart on the percentages of the values ( -1, 0, 1 ,2) occurring per row.Sorry for the confusing description but I am just as confused.

The table that holds all the information looks something like this:

alt text

Now I think I need a table or view in this format

alt text

to be able to start working with the data

Any opinion on what would be the best way to get a fully dynamic report build on this table with report builder 3.0 would be a great help.

asked Jul 31 '12 at 07:10 AM in Default

WcMyburgh
80 ● 4 ● 6

Tanks Jonathan, Ill have a look into your suggestion. The thing is this is going to be my first exposure to reporting services and I am not really sure where to start with this.

Aug 01 '12 at 06:07 AM WcMyburgh

If you are completely new to SSRS then there are lots of resources around that can give you great advice - check out SQL Server Central's Stairways series - http://www.sqlservercentral.com/stairway/72382/ as a starting point and feel free to come back here if you get stuck!!

Aug 01 '12 at 07:42 AM Fatherjack ♦♦

(comments are locked)

1 answer:

unless there is a subtlety in the question that I have missed (or in the images that are currently not showing) then I'd simply create a stored procedure to get the data from the table, set that as your datasource in the report and use the charting objects to calculate the percentage etc

answered Jul 31 '12 at 02:05 PM