Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XML Data with Running Total

Status
Not open for further replies.
KoRUPT

KoRUPT

Programmer
Jul 25, 2002
25
CA
I am trying to get a running total (sum) of some numbers but I do not get the option of using sum as a summary type. I think it has something to do with all the XML data being treated as string fields. Can someone help me get this working? Thanks
 
Sort by date Sort by votes
Try a formula containing:

val({table.field})

Now you can use summaries or running totals against the formula.

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lavadan
  • Locked
  • Question
Export to excel with drop down data
Replies
2
Views
129
hilfy
hilfy
hpl2001
  • Locked
  • Question
BI4/Crystal 2016 upgrade issue with scheduled reports
Replies
1
Views
120
hilfy
hilfy
allyne
  • Locked
  • Question
RE: Sub Reports with parameters 1
Replies
3
Views
121
allyne
allyne
Almie
  • Locked
  • Question
Display records with identical field data
Replies
1
Views
88
NickieP
NickieP
IanWaterman
  • Locked
  • Question
Using Subreport with a different database connection
Replies
3
Views
103
IanWaterman
IanWaterman

Part and Inventory Search

Sponsor

Back
Top