Modify list by text string value 1

[johnwms]

G-day,
I'm using a list that has customer name with a "- prefix", I'd like to group the list by "- A", "- B", "- C", "- D" and can't figure how. Is it possible? The select expert does not have a prompt for the end of a text string and the formula for doing so evades me. Then I'd like this list to be sorted by -A's, -B's,-C's, etc ... Any hints .... would I have to split the report list up to do this?
thanx

 

[lbass]

Assuming you really mean "suffix", create a formula in the formula editor:

right({table.customername},1)

Then insert a group on this formula.

-LB

 

[johnwms]

Thank you much, it'll have wait till Monday A.M. I did mean suffix. This was my first post and I'm new to CR (I didn't even mention it was CR9.2). And I'm not totally sure what 'Then insert a group on this formula' means, I thought you inserted formulas into groups ...
-J

 

[lbass]

You can either go to insert->group and choose the formula above (let's call it {@suffix}) as your field to group on, or you could go to report->sort records and choose {@suffix} as a field to sort by. Either way will order your records alphabetically by suffix.

-LB

 

[johnwms]

Finally getting back to this - report writing is not my primary task. And I guess I wasn't clear enough in my posting.

The suffixes I have are "- CLOSED", "- COLLECTIONS", and "- NON PAY". And the list is already sorted by 'customer.active' and 'customer.id' - the @suffix is third and I can't reverse the order or remove the other sorts, therefore I don't get the desired result. Thanx, and I apologize ...

 

[lbass]

Please show a sample of the field results. Is there only one hyphen in the field?

Also, please show a sample of your report structure so we an see how the report is currently sorted (indicate groups, please), and then a sample of how you would like it sorted.

-LB

 

[johnwms]

This output list is 408 records sorted by “active” = N (field not shown on report) as Group Header #1 and customer ID as Group Header #2 – both groups are suppressed in report. The form is below, just a list in order of ID for the date closed range of 5/1 – 5/31.

I’d like to list ‘collections’, ‘closed’ and ‘non pay’ together, and maybe even a total of each. I need to run this monthly (date range parameter?), and even be able to suppress the details and just list the totals of each.

ID Name User Date Closed
2030 LEON KULINSKI – CLOSED lkulinski-closed 5/18/2005
2166 SCOTT MCCAULEY – NON PAY smccauley 5/18/2005
2431 Penn – Aire Aviation – CLOSED pennaire-closed 5/27/2005
2576 MICHAEL ROBINSON – COLLECTIONS msrptp-closed 5/25/2005
3196 MADE TO ORDER – CLOSED melnbarry-closed 5/2/2005
6043 RICK VOORHIES – COLLECTIONS rvoorheis-closed 5/25/2005
7195 JUDI CARLSON – NON PAY msmariah 5/18/2005


Again I apologize, I’m still learning how to post and use forums, the end result would be similar to –

ID Name User Date Closed
2030 LEON KULINSKI – CLOSED lkulinski-closed 5/18/2005
2431 Penn – Aire Aviation – CLOSED pennaire-closed 5/27/2005
3196 MADE TO ORDER – CLOSED melnbarry-closed 5/2/2005
Total Closed = 321

2576 MICHAEL ROBINSON – COLLECTIONS msrptp-closed 5/25/2005
6043 RICK VOORHIES – COLLECTIONS rvoorheis-closed 5/25/2005
Total Collections = 49

2166 SCOTT MCCAULEY – NON PAY smccauley 5/18/2005
7195 JUDI CARLSON – NON PAY msmariah 5/18/2005
Total Non Pay = 38

Whatever and however you can help, please offer – suggestions appreciated …
-J

 

[lbass]

You need to insert a group on the following formula:

split({table.name},"-")[ubound(split({table.name},"-"))]

Then go to report->change group expert and use the arrow key to make this Group #2, so that your groups are in this order:

Active Status
Suffix group
Customer ID

Then you will be able to insert summaries on the detail section to summarize at the suffix group level.

-LB

 

[johnwms]

Thank you LB, I'm getting the results desired. Even the suffix group summaries. First I had to figure where to put the formula - group or record selection, or formula field, but I got there. Now just to set up parameters and fomula to prompt for the user entered date range and I'll have something re-useable ... thanx again