2. ASPRunnerPro General questions
  3. Totals not Calculating
This topic is locked

Totals not Calculating

 		7/21/2006 2:26:42 PM
ASPRunnerPro General questions
C
 chriscps author

I have generated a list page that I have 1 Count, 5 sum totals, and 3 averages at the bottom of the page in that order. The Count, and first 2 Totals calculate correctly but after the second total none of the other totals are calculating nor is the average. They display Total: 0.00 and Average: 0.00. Is there a limit to the number of totals at the bottom of the page?
The data is coming from an SQL Server view. Fields are number fields in view.
Thanks

Chris
Sergey Kornilov admin 7/22/2006

Chris,
please zip and send your generated ASP files, along with project file and SQL script that creates required tables and views to support@xlinesoft.com for investigation.
C
 		chriscps author 7/27/2006

Chris,

please zip and send your generated ASP files, along with project file and SQL script that creates required tables and views to support@xlinesoft.com for investigation.


I have emailed the required documents.
ngomong 12/4/2006

Was this issue ever resolved? I'm having the same problem.
I have calculated fields, and am unable to get a "Total" for these columns.
Thanks,

clay.



I have emailed the required documents.
ngomong 12/4/2006

Aha! I found the fix:
http://www.asprunner.com/forums/index.php?...83&hl=total

Hi,

thank you for pointing me to this issue. I'll fix it in the next update of ASPRunner.
You can use this workaround now:

  • open generated ..._list.asp file by any text editor.
  • find this line:
    and replace it with this one:


Any way we can get this bug fixed in future build?
Sergey Kornilov admin 12/4/2006

The problem is caused by extra spaces characters in your calculated field. You need to modify SQL query so calculated fields don't have extra spaces and totals work fine.