Totalling Columns for report

  • Hello all,

     

    I am trying to write an ASP script that will pull data from MSSQL, then display that data on a webpage.  I want to total some of the columns at the end of the report.

    Would it be better to perform the total calculations in SQL or should I just do it in ASP?

    Thanks!

     

  • If it is classic asp you would have to go through a loop to diplay data in a grid. Better do it in the ASP.

    In asp.net if databind is used to datagrid, use aggregate functions in ADO.net.

    Regards,
    gova

  • Thanks for the fast reply.

    It is indeed classic ASP.  So I would just do a tot_count = tot_count+1 type deal at the end of each function.

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

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