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:

Include a big block of text (1997) More on the email templates (1997) Another question about credit cards (1997) Upgrade Problem.... (1998) apostrophe in search item (1997) Field name-subcategory (1997) Shownext never shows next...still (1997) Omnibase db manipulation utility available as gift to Webcatalog community. (1999) Country & Ship-to address & other fields ? (1997) list cookies and list http headers (1997) 6.0 Upgrade Issue (2005) Max Record length (1997) Server slowing down. (1997) NT Version on IIS 4.0 (1997) Don't do this! (was: Crashing Type 3) (1999) Multiple catalog databases and showcart (1997) [referrer] tag (1997) Sort on time (2003) Unable to append (2001) Nav. 4 probs with cart - Serious problem (1997)