Two level sort 1

[csm2]

User can request a 'ID# within Date' sort order or 'Date within ID#' sort order. How do I setup the formula(s) to achieve this? Am using CR 6 with Informix DB.

 

[alam]

r u using any parameter asking user to enter ID# and date or u jus wanna sort ID# inside Date which is also sorted..,in latter case u can jus jus GROUP ur Report on Date and when u do so make sure to make decision ASC or DESC and then go to SORT button and choose ID number and add it after the DATE as Date being a group has higher priority...,
and if u r asking to enter date and ID# to user u need to write a Query using the parameter names which comes automatically in FORMULA EDITOR...,jus double click to insert them in Query and complete the query...
My answers are based on Crystal rep ver 7.0 and doesn't know if it works in 6.
Best of luck..

 

[csm2]

Thanx for your suggestions.
I need to be more exact in stating problem. User supplies date range (StartDate, EndDate) and sort order (ID# within Date or Date within ID#). To take your idea a step further, if I can conditionally group on the major field then I can sort the minor field.

 

[kenhamady]

Look at the FAQ for common formulas, and look at formula #4.

You will need 2 formulas with these "if-then" statements that each selects one field based on your parameter. You will use these fields as sort and group fields, one to select the primary Sort/Group field and the other to select the secondary.

Since your data fields are different data types you will need to convert both to text. Otherwise the "if - then" formulas won't work Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[csm2]

Thank you, Ken. It worked like a charm.

I don't want to push my luck, but sooner or later my user will request a three or more level sort. Is there a general rule for accomplishing this? Would I use Group1, Group2...GroupN and than try to sort each one?

 

[kenhamady]

I don't know if it happens enough for a general rule, but this will work with any number of levels.

The trick will be what to do if they only want 2 levels instead of 3 some time. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal