Hi all

Can anyone tell me how to perform grouping of a crystal report

 

The field to group on is variable (selected by the user at runtime)

 

If anyone has any axamples, please let me know

 

Thank you

 

Create a formula that looks something like this (not know what your groups are, I'm writing this base on my data):

if {?GroupName} = 'Loan Number' then
  {loan.loan_number}
else if {?GroupName} = 'Property State' then
  {loan.property_state}
else if {?GroupName} = 'Posting Date' then
  ToText({loan.posting_date}, 'yyyyMMdd')

All of the results have to be in the same format - string, number, etc. - so you may have to do some conversion based on the field type.   So, you can see that I converted the date field to text.  When you're working with dates that have been converted to text, you have to format them differently when you're using them to sort data than if you're just displaying them because they'll sort in text order instead of in date order. 

 

Once you have your formula set up, use that as your group instead of a specific field.

-Dell

I just tried it and it works great!!!

 

I was trying to figure out how to set the grouping on a date field by year, month, week, day, hour and so on

Ive used this option but not at runtime, that option is the one available when you click the options... button in the group expert

If you or anyone else could give a clue or something

Ill appreciate it

 

 

Thanks