Grouping in Report (2000 SP3)

Topic

New Reply

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
TIA
Steve

Reply | Quote

Replies

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″.

Reply | Quote

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″.

Reply | Quote