Sort Ascending after Sort Specified, Group Expert Woes!!

[gregmuir2]

I have a report that displays customers and their selected options. From the returned data set, the first grouping I do is by the client name. That works out fine.

After that, I'm listing the options they selected for their purchase. The options are either structural or non-structural. I am using the "group by specified order" function to group the options. Structural options are numbers between 99,999 and 109,101. Non-Structurals are anything that isn't 100.

This works fine for me so long as I'm not caring about the order the option numbers are sorted in. I don't see a way to make it sort ascending here so I'm thinking that I might need to do all this in a formula instead. Any ideas on this? Thanks!

 

[synapsevampire]

You say "99,999 and 109,101. Non-Structurals are anything that isn't 100.", but 100 isn't between those, not sure why you wouldn't want to proof read your posts before submitting but you're going to net questions not answers with this sort of vaguery.

Perhaps you mean not 100,000?

And yes, if you want them sorted by theitr values, then use a formula, not specified order.

Of course posting example data and expected output would have clarified, again, some prefer to chat aout data instead of the simpler and clearer approach of showing what they have and what they want.

Anyway, try a formula, I've no idea what you want or I'd provide it, if you need additional help, try posting technical information rather than trying to describe it.

-k