Post reply

Total in Table footer

  • December 6, 2005 at 7:11 am

    #115630

    I calculate a field on a report by taking the max cost for a group and multiply it by the difference of 2 other columns.  I want to total this is the table footer.  I have tried to sum using the reportitems element but get an error.  Any ideas on how I can accomplish this?

  • December 6, 2005 at 2:58 pm

    #608068

    hi there
    when you add you coolumn to "group by" it should automatically add total also at the bottom,does not it ?

  • December 7, 2005 at 3:52 am

    #608134

    You need the calculated value to appear in the report somewhere, but not in the footer.  RS will not allow data to be dropped here.  Set the hidden value to true.

    In the report footer, add a text box and set the value to reference the calculated value of the report.

  • July 13, 2006 at 11:54 am

    #649069

    How exactly would you set a text box in the footer to be the value of a hidden text box?  Sorry, I am a Reporting Service newbie, and I've been trying to figure out how to do this.

    Cynthia

Viewing 4 posts - 1 through 3 (of 3 total)

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