Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    7 sec. away
    Posts
    4

    Question Unanswered: CDML and Reports-- Sum of Vertical fields on Results page

    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)
    -TotalSale-->ForThisItem (calcualtion=ItemPrice x Qunatity)
    -Date(date-autoenter)
    --TotalDailySaleBasedOnDateRangeSelected(??????)
    --TotalWeeklySaleBasedOnDateRangeSelected(??????)
    ==============================================
    the scenario is:
    user goes to search page (CDML 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/4/2002
    3...
    4...
    5...
    .....
    ==============================================
    for the selected time frame (one week worth of time)

    1/1/2002-->1/7/2002
    TOTALQuantity=xxxx TOTALSale=$xxxx

    SO in other words a weekly report where the week starts based on my date selection and Vertical Sum of resulting fields per page?
    Instead of making reports my idea was to use the search page to:

    User enters a date range for one day-->DAILY REPORT
    User enter a date range for 7 days-->WEEKLY REPORT

    IS this possible?My background is in VBscript and ASP not FM scripting and have barely started CMDL-scripting (2 days ago)so...
    I have used the Columnar-List Report within the FM and it works OK except for the fact I can sort ONLY by Date not the Range....I was even ready to go to Buit-in publishing
    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......
    Last edited by lebisol; 02-19-03 at 17:55.

  2. #2
    Join Date
    Feb 2003
    Location
    7 sec. away
    Posts
    4

    Thumbs up

    OK.....I found the problem I was using a "Sum" rather than "Total Of" on the field properties.Also, the TotalSALE and TotalQUANTITY should be out of "repeated region" of records.....
    so there it is....Using a Search to generate Reports with CDML!
    If anyone outhere has questions I would be more than happy to extend the topic.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •