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:
Now I think I need a table or view in this format
to be able to start working with the dataAny 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
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