format of printed report

  • Thread starter Thread starter Nathan Guill
  • Start date Start date
N

Nathan Guill

I have a report that I need to group the records into two sets. The
function of this report is for our shop to produce a block that we can
machine our tools out of. What needs to be done is that all the tools that
are 80# or less print together and everything else prints on the next sheet.
Also, these records need to be sorted so that the tool numbers are in
chronological order (i.e. T8952, T8952-1, T8952-2, etc.)

Any help would be appreciated.
 
Nathan said:
I have a report that I need to group the records into two sets. The
function of this report is for our shop to produce a block that we can
machine our tools out of. What needs to be done is that all the tools that
are 80# or less print together and everything else prints on the next sheet.
Also, these records need to be sorted so that the tool numbers are in
chronological order (i.e. T8952, T8952-1, T8952-2, etc.)
Click to expand...


Use an expression in the Sorting and Grouping box:

=Weight >= 80

Sorting on the numeric part of an alphanumeric string is
problematic. Generally, you would just add the tool number
field to Sorting and Grouping bu I think you'll have trouble
when it sorts it as:

T8952
T8952-1
T8952-10
T8952-11
T8952-12
T8952-2
T8952-20
T8952-21

This can get a little messy, so before we get into it please
provide a more extensive example of the tool identifiers and
any rules that are used to create them.
 
Back
Top