Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting in groups

Status
Not open for further replies.

falcons1

Programmer
Oct 20, 2003
12
BY
Hi experts!
I hope you will help me
I have the following:
1) my datas are grouped by one of the fields of the table
2)the field of sort is coming as a parameter
I need to sort in groups with this parameter
What I need to do ?
sorry if i have asked the stupid question ( i am
a beginning programmer in CR)
 
hi
just go to format group expert and click on your group and see if you have sort ascending

cheers


pgtek
 
no, i need sort with a parameter which is coming from outside
 
At least for Crystal 8.5, a group will be the highest level of a sort.

Possible work-rounds include:
a) Setting up a higher group with the value you want
b) Grouping on a formula field that reads a value and chooses some other value, e.g. a) Pears, b) cherries, c) apples

Madawc Williams
East Anglia, Great Britain
 
what Madawc means in his option B is something like this

Create a grouping formula based on your parameter...something like

if {?Param} = "something" then
{table.stringvalue}
else if {?Param} = "somethingelse" then
totext({table.numericvalue})
else
{table.defaultStringOrNumericValue}

Note: the results are all either strings or converted to strings...this is done since all results of the If-then must be of the same data type.

You could also use this approach to create a sorting formula.


Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!
 
Hello!
Thanks for the amswers.
Sorry, but i didn't understood enought.
I need sort on this parameter in every groups
 
Hello!
Thanks for the amswers.
Sorry, but i didn't understood enought.
I need sort on this parameter in every groups
Just to sort but not to group
 
You can also use this type of field for sorting. Just include it in [Sort Records] under [Report]

Madawc Williams
East Anglia, Great Britain
 
Hi!
all of us are telling me about grouping on the parameter but
i need "sorting" on the parameter
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top