Sort specific Word First

[Zonie32]

I have a report that is grouped by ProductName. In my report I always want a certain product to be listed first, even though it isn't alphabetically supposed to come first.

Is there a way to specify that I want Tables to come first even though Chair would come before Table in the alphabet?

As long as Table comes first, the sort order does not matter after that. Thanks.

 

[randysmid]

Hi,
I've had to do this with some of my reports. So, I went into the tables and created a numeric field indicating the sequence of the items to appear in the report. Then, I use Sorting and Grouping by that specific number to print the report. With the numbers, I used a "gapping" technique, where I started with 3, then 6, then 9, then 12. That leaves me room to place the cost center in any sequence just be rearranging them.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association