Results 1 to 6 of 6
  1. #1
    Join Date
    May 2006
    Posts
    386

    Unanswered: Can anyone help please? How to create a report to show total sales per client in ..

    Dear All,
    I am trying to create a report to show Total Purchase per client in Decending order meaning whichever client has the biggest purchase amount should appear at the top of the page and other clients should follow the same sequence. I do not want individual invoices to appear I need their total for each client.

    The query has the following fields
    ClientID
    DateOfJob
    InvoiceDate
    TotalAmountLessVAT


    I am trying to create a report to show present me the Report like the attachment which I have created manually in a word document for illustratino purposes.

    Any help would be grately appreciated,

    Regards
    Emmi,
    Attached Files Attached Files
    Emi-UK
    Love begets Love, Help Begets Help

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so create your report
    set the sorting and grouping levels as required
    bearing in mind you want a DESCending sort on the purchase prices or should that be invoice/billed total
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2006
    Posts
    386
    thank you for your respons,
    I created a blank report then in the Record Source I got the desired query and then added the following two fields only
    ClientID and
    ClientAmountLessVAT
    I went to view and clicked on Sorting and Grouping and then Chose both ClientID and ClientAmountLessVAT but I did not do anything from there onwards as I could not see any option for Grouping Levels to be set as required.
    Emi-UK
    Love begets Love, Help Begets Help

  4. #4
    Join Date
    May 2006
    Posts
    386
    sorry, i did not respond in full, yes, it should be invoice/billed total for each client. At the moment the report shows me individual invoices for each client, for example if a client has 50 invoices, the report shows 50 separete rows for that client and it shows the name of the client 50 times. But want to total of those invoices in front of every client.
    Emi-UK
    Love begets Love, Help Begets Help

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so supress the detail (look at code in the forms on format event.
    or writew a query which sums invoices and groups by customer
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    May 2006
    Posts
    386
    That is perfect, i went with the query option.
    Thank you very much, it really did the job so quickly.
    Emi-UK
    Love begets Love, Help Begets Help

Posting Permissions

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