Home Forums Reporting Services Reporting Services 2008 Development Creating a report to list totals from a table that doesn't require a re-design whenever a new field is added RE: Creating a report to list totals from a table that doesn't require a re-design whenever a new field is added

  • I am not exactly sure what you are trying to do, but using a running value function may help:

    http://technet.microsoft.com/en-us/library/dd255229.aspx

    If you are just getting the percentage of the column or row total, then you can use an aggregrate function like SUM to get the percent. The expression would look something similar to:

    =SUM(Fields!ID.Value)/SUM(Fields!ID.Value,"group_name")