Export to excel from SSRS 2005 report

• Sathish Raja

  SSC Rookie

  Points: 45

  More actions

  December 23, 2008 at 1:35 am

  #204456

  Hi,

  I have aggregate formula in my groupFooter as below

  Column1 Column2 Column3

  =field1.value =field2.value =field1.value*field2.value

  Footer =Sum(field1.value*field2.value)

  While exporting this to excel i get formula for Column3 in each cell.

  But the Footer row in excel is missing aggregate formula. Can anyone help to export reports with formula in excel.

  Thanks in Advance,

  Sathish Raja S

  With Regards,
  Sathish Raja S,
  Chennai

• abhijeetv

  SSCommitted

  Points: 1945

  More actions

  January 2, 2009 at 5:45 am

  #920208

  If you are talking about the table footer row then it definitely works.(table that is showing the data and has the dataset associated with it)

  Are you putting the particular field in the REPORT footer? it should be a part of TABLE footer.