Home Forums Reporting Services Reporting Services export report to excel and excel should create formula fields for the sum fields of the report RE: export report to excel and excel should create formula fields for the sum fields of the report

  • Hi Peter,

    you could wrap the detail rows a group and calculate in a group footer?

    i.e. have your header rows in the group header i.e. order number, order price etc (in this example group on customer id) then in your detail would contain a list of order numbers and prices, then your group footer could contain the totals.

    clear as crystal? or clear as mud?

    reply if you would like me to elaborate.

    cheers,

    Frank..