Reports - Veritcal Sum of Fields on Results page

[lebisol]

Hello People!
With great hope that someone has an advice/solution I present my problem. I am new to FileMaker (FMPro6) so I would apprechiate all of the help.
Here is the DB structure (the actual field names differ but for the ease of understanding...):
=====Reports.fm6================================
-Location (text)
-ItemPrice(number)
-Quantity(number)
-TotalSaleForThisItem (calcualtion=ItemPrice x Qunatity)
-Date(date-autoenter)
--TotalDailySaleBasedOnDateRangeSelected(??????)
===================================================
the scenario is:
user goes to search page (CMDL custom web-pub) that does sorting just fine.So if user selects

Location:Los Angeles
DateRange)1/1/2002...1/7/2002

I would like to get the results:
Location | Item Price |Quantity |TotalSale |date
======================================================
1.Los Angeles| 50 | 2 |100 |1/1/2002
2.Los Angeles| 20 | 7 |140 |1/2/2002
3... 4... 5... 6.
7.
======================================================
for the selected time frame (one week worth of time)
1/1/2002-->1/7/2002
WEEKLY_TOTALQuantity=xxxx WEEKLY_TOTALSale=$xxxx

SO in other words a weekly report where the week starts based on my date selection and Verital Summ of resulting fields per page?
IS this possible?My background is in VBscript and ASP not FM scripting sooo....
I am at the point where I would really apprechiate your help...and IF this is NOT possible...CHANGE OUR WHOLE DB to Access...maybe?! help help help
Thank you guys......

 

[Schlogg]

Change to Access. What heresy!!
Just define two Summary fields -
Total Quantity = Total of Quantity
Total Money = Total of TotalSaleForThisItem
and two calculation fields -
Calc Total Quantity = GetSummary(Total Quantity, Total Quantity)
Calc Total Money = GetSummary(Total Money, Total Money)
The two calculatin fields can be used to display the totals.
Check out the FMP help on GetSummary.
HTH

Cheers,
Paul J.

 

[lebisol]

thank you very much....what got was the fact that in FM these fields would reflect only 1 record Total at the time...but in CDML it reflects the total of records found...hm strange yet efficient!
Thanx

 

[zteve]

If you're used to ASP, there now is a solution called FmConnector for ASP to connect ASP to Filemaker.

You can check it out on

http://www.fmcdn.com

Good luck,

Zteve