Calculate total and percentage columns from ssrs 2008 r2 dataset for reports.

what does the raw sql query look like? What is the table structure? Is TotalColumn a calculated field, or is it something directly from the DB?

You might be able to do this:

SELECT ValueColumn, TotalColumn, ValueColumn/TotalColumn*100 AS PercentageColumn FROM DataTable

I can do it in db but these columns are not individual columns e.g.,

As per your select statment ValueColumn is derived from number of aggregagetes and divisions with 10 different columns in database dataset. If I calculate percentage again in database then i need to calculate ValueColumn twice and there more than one columns where i need to calculate percentage. It slows down the whole query and increases CPU usage.

Thats why I want to calculate percentage from already calculated columns in Reporting Services instead of DB.

Please suggest solution in reporting services. Your answers and suggestions are greatly appreciated.

Thanks

TotalColumn:

=Sum(Fields!ValueColumn.Value, "DataSetName")

Select allOpen in new window

PercentageColumn:

=Fields!ValueColumn.Value/Sum(Fields!ValueColumn.Value, "DataSetName")*100

Select allOpen in new window

try this

 

=Sum(Fields!FieldName.Value,"DatasetName")

Select allOpen in new window

=Round((Fields!SrNo.Value/SUM(Fields!FieldName.Value,"Dataset")*100),2)

Select allOpen in new window

Please use custom code or assembly reference.

https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_7316-Variable-Custom-Code-and-Assembly-reference-in-SSRS.html

Thanks a lot for your suggesions; I want to use this calculated percentage column in pie chart as series!!!!!!!!!

Is this possible???????????