Re: Generating Report Totals

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11184
interpreted = N
texte = >>Total purchases to date: $[format 5.2f][search >>db=XXX.db&nedatedata=0][math][founditems] >>[NumericField]+[/founditems]0[/math][/search][/format]This got me on the right track. I had not thought of having two or more [founditems] contexts in the same page. My search is generated by form data, so I had to put this on the results page, which now has two [founditems] contexts. One set formats the rows of returned records, and the second sums up the numeric fields, using your method. This makes sure the math is done on the exact same set of returned records. Works great, and opens up lots of possibilities.Thanks. Associated Messages, from the most recent to the oldest:

    
  1. Re: Generating Report Totals (Kenneth Grome 1997)
  2. Re: Generating Report Totals (Grant Hulbert 1997)
  3. Re: Generating Report Totals (Dan Gilpin 1997)
  4. Re: Generating Report Totals (Gil Poulsen 1997)
  5. Generating Report Totals (Dan L Gilpin 1997)
>>Total purchases to date: $[format 5.2f][search >>db=XXX.db&nedatedata=0][math][founditems] >>[NumericField]+[/founditems]0[/math][/search][/format]This got me on the right track. I had not thought of having two or more [founditems] contexts in the same page. My search is generated by form data, so I had to put this on the results page, which now has two [founditems] contexts. One set formats the rows of returned records, and the second sums up the numeric fields, using your method. This makes sure the math is done on the exact same set of returned records. Works great, and opens up lots of possibilities.Thanks. Dan Gilpin

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

2nd WebCatalog2 Feature Request (1996) Summary search -- speed (1997) Welcome Back (was) Newbie Question (1999) Authorizenet and expiration dates (2002) Emailer setup (1997) [WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011) Exclamation point (1997) About to give up (1998) Force a search at the default.tmpl page? (1997) POST through TCPConnect (1999) show related items (2003) FREE Stuff .. (2003) Where's Cart Created ? (1997) [click][/click] (1999) [addlineitems] (1997) Auto Delete EmailCompleted Files (2002) [WebDNA] [OT] BBEdit Glossary (2012) Re1000001: Setting up shop (1997) Caching [include] files ... (1997) Help with getting rpm file (2002)