Post reply

Formulas in Excel

  • February 28, 2006 at 9:52 pm

    #167250

    I have a report on SQL 2000 RS SP2 that consists of a single table that has a detail row and two levels of grouping. Each grouping row contains a SUM formula to aggregate a single column in the table.

    When this report is rendered to Excel the sum is replaced with the result of the formula. Is there any trick to get Reporting Services to have the formula instead of the result?

     

    --------------------
    Colt 45 - the original point and click interface

  • March 2, 2006 at 6:27 am

    #624273

    Would you believe that the sum function isn't supported in the export to Excel? That's the way BOL reads anyway Now if you'd used Cos or Sin, that would be a different story... :S

    Steve.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply