Grouping in Crystal

[GrannyJo]

How do I take a group field and the group with in the field? Ie, I am grouping by market model, I want to group by the first 5 digits of the model.

 

[synapsevampire]

Create a formula with:

left(table.marketmodel,5) if it's a string.

If it's a number, use:

left(totext(table.marketmodel,0),5)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

Ooops, if it's a number use:

left(totext(table.marketmodel,0,"&quot,5)

Otherwise you'll get a thousands separator.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[chelseatech]

Remember that a new group will come in as the lowest level group.

You can chaage the group order inside the designer, by dragging the group header or footer to a higher or lower level.

Saves a lot of time. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm