Results 1 to 13 of 13
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Report Details (2003)

    I created a report which detailed invoice details, which included the invoice number. There could have been a range of invoices on the report from say 1001 to 1017. These invoice numbers could relate to a number of customer orders. They have now asked if we could just group the invoices by order number and have a page for each order number. This, I have done, but my problem is that before I could put the invoice serial number range on the report, as they were all together. I want to detail what invoices are on each page when the report is printed, but I'm not sure how to do it.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Details (2003)

    Can you provide information about how the invoice numbers and order numbers are related? Will the invoice numbers on a page always be contiguous? Please be as specific as possible.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Report Details (2003)

    No they won't. I see from the sample they have given me, that on one order number, they have invoice numbers 10062 and 10067. I know this doesn't help matters.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Details (2003)

    So what exactly would you want to be printed on the report? Wouldn't it be easier to drop this feature in the new situation?

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Report Details (2003)

    It would be easier, but we're talking about customer requirements. Ideally, I would like to show what invoice numbers are on each page, but if it's too complicated, we may have to drop the idea.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Details (2003)

    If you want to display a list of invoice numbers, you could use the Concat function from <post#=301393>post 301393</post#>. It requires a reference to the Microsoft DAO 3.6 Object Library.

  7. #7
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Report Details (2003)

    Thanks Hans, I'll try that. Another problem is the report footer. Because of the 'Force New Page' after section, the report footer prints on a page on its own.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Details (2003)

    Try forcing a new page before instead of after the section.

  9. #9
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Report Details (2003)

    Creating a Text box bound to the Invoic Number only gives me the first Invoice number on the report. Do I need the vba code.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Details (2003)

    You should copy the Concat function into a standard module, and set a reference (in Tools | References...) to the Microsoft DAO 3.6 Object Library.
    You can then put a text box in the group header or footer for the order number with a control source like the following:

    =Concat("tblSomething", "InvoiceNo", "[OrderNo] = " & [OrderNo])

    Of course, you must substitute the appropriate names. The above assumes that the order number field is numeric; if it is a text field, change the expression to

    =Concat("tblSomething", "InvoiceNo", "[OrderNo] = " & Chr(34) & [OrderNo] & Chr(34))

  11. #11
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Report Details (2003)

    Inovice No is text as well

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Details (2003)

    That shouldn't be a problem.

  13. #13
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Report Details (2003)

    Thanks Hans, that's done the job. Cheers.

Posting Permissions

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