GROUPS - Novice user?????? 1

[dnguyen]

Hi All,

Upon creating Groups in CR, you must specify a field in your DB to group by, this is assigned as Group 1. Is is possible to assign a parameter to a "Group" without hard coding the field you want to group?. IE. Provide a parameter to the user and let them specify which FIELD to group by?.

Thanks.

 

[krill]

Are you trying to do this in code or via a stand alone crystal report. If you are not passing group values from your application, you could set up a parameter that you can use in a crystal formula and group on the value returned from your formula.

 

[kenhamady]

From an application you can change the group field. From CR itself you can create a parameter, then use that parameter in an if - then formula. Then you group on the formula. Something like:

If {?Prompt} = "A"
then {table.field1}
else {table.field2} Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[dnguyen]

Hi Krill/kenhamady,

Thanks for that, I was justed thinking the same thing when I left work and it was in my head all night.

It works fine now, for your info. we are building a Lotus Notes app. which uses CR for the reporting side. And as I do not have any formal training in CR, I have been putting together this report on the fly!!!!!. It's really a great product and I wish they send me on a course.

Anyway, thanks so much for the reponses and assistance.

Cheers,
David.