Wednesday, August 1, 2012

Crystal Reports : Groups as a Parameter

This is neat: Let us suppose we want a report to be Grouped on either Users.UserID or Users.UserTerritory, depending on a Parameter field.

So, provide a simple parameter, {?Group} and let the user set it to "UserID" or "Territory".

Now, within your report, create a formula field called {@Group1} and paste in the following code:

IF {?Group} = "UserID" THEN {USERS.USERID} ELSE
IF {?Group} = "Territory" THEN {USERS.USERTERRITORY}

Now, create your Group in crystal, and use {@Group1} as your Group Field.

This way, the user can select how the report should group itself, affecting all summaries, etc.

Try it!

3 comments:

chanel bottle bag price said...

While the Moto E does not have a great front camera, the rear camera functions well under daylight. Also, the Moto E comes with pure Android 5.0 and if you do not want any bloatware to slow down your device’s performance, the Moto E delivers just that.

wei coco said...

A brace of affidavit cover accepting a new job in the gucci replica company, or architecture business communities in order to facilitate projects you ability be absorption on.The capital allotment of centralized networking is usually to plan with humans aboveboard so they advance assurance aloft you. It is a affiliation that will pay off in the best term. This agency that you can not act in a blitz to hermes replicaget some thing. The ambition is to understand who does what central the business and see how you bout for that mix. This centralized networking is able because you are accouterment the added affair with a affair and they are giving you something.Whatever the louis vuitton replica Purse alignment you are in, if you accept to pursue some affectionate of centralized networking, you accept to apperceive what you are searching to achieve.Remember that as you artifice the journey, accept the individuals to breitling replica contact, and the assignments you are accommodating to plan on. Even admitting it is a two-way partnership, you are in allegation of the accurate route you wish to take, so accept an agenda.There are abundant means of networking that can plan when activated to the adapted situation. Everything comes down to the ability of who you are aggravating to replica watches arrangement with and what you should accompany to the table. Business is absolutely a two way street and if organizations and individuals adjudge to affix with one another, it accept to be equally valuable.





Anonymous said...

Thanks guys for making this Q&A on groups as parameter, finally I found the resolution to my old problem. Page that I created http://www.procustomwriting.com/custom-term-papers/ could not give any academic help to students, not it can! Good friends of mine at college, Derek and Phillip were happy to receive essays.