Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Thanked 0 Times in 0 Posts

    Grouping in Report (2000 SP3)

    I have a report which I have to sort products in a particular order. I have assigned sort numbers along the lines of 111, 112, 113,211,212,213,214,215,311,312,313 etc.
    I wish to start a new page whenever the first digit of the number changes ie 111,112,113 would be on first page(s), 211-2145 would start on a new page, 311 on a new page etc
    Appreciate any help - I am sure this is linked to Intervals but am not holding my tongue right and have circled it for ages to no avail
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 33 Times in 33 Posts

    Re: Grouping in Report (2000 SP3)

    In the query behind your report, add an expression something like this:
    GroupNo: Left (SortNo,1)

    In this, We are creating a new field named "GroupNo", which is the first character of your sort number (I guessed at the field name).

    In your report, put GroupNo as the first entry in your Sorting/Grouping list, and set Header property = True. In the Header itself, set the PageBreak property accordingly, and set the height to 0".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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