Results 1 to 2 of 2
Thread: Grouping in Report (2000 SP3)
2004-07-10, 08:48 #1
- 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
SteveDummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>
2004-07-10, 10:11 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 37 Times in 36 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".