Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping on Sequential Number Field, Sets of 1,200 2

Status
Not open for further replies.

jpstrzoch

Technical User
Mar 24, 2004
59
US
Good evening,

I have created a report that contains a field with a sequential number. The number is ascending and as each detail line is added the field increments.

I want to create a grouping for every 1,200 records in order to burst the report. Thus I need to know how to group by 1-1200, 1201 - 2400, etc.

The report will vary in length and may end with less than 1200 records in the first or last grouping...that's OK...but need some advice on how to proceed.

Thank you in advance for your help.

James J. Pstrzoch
 
Insert a group on this formula:

truncate(({table.seqno}-1)/1200)

-LB
 
LBass,

Thank you very much! Worked great!

Follow-up question.....the formula results in a "0" for the first group. How do I start off at 1?

James
 
Change the formula to:

truncate(({table.seqno}-1)/1200) + 1

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top