Monday, July 27, 2015

Crystal Reports : Run Time Grouping

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!

2 comments:

lin liyi said...

This will likely occur as being a amaze, nevertheless Seiko designer watches are generally increasing a perception while fashionable along with collectable. Opulent, deluxe hublot replica sale can be a must to many, and some position your target purpose. Lavish designer watches can be be extremely high-priced nevertheless you'll find solutions to purchase treat designer watches for the small percentage in the charge. Nearly all designer watches are generally created for you to very last indefinitely, generating applied along with repaired rolex replica uk a new functional expenditure. In numerous aspects of the globe, your rolex replica uk company have been seen as reputable, nevertheless unremarkable. Nevertheless search tightly along with an excellent history will begin for you to come up. Seiko will not genuinely receive the admiration the idea should get. Until eventually just lately, local Seiko firms distributed your company as outlined by community style. Nevertheless just japan parent or guardian, chanel replica sale, thought we would renovate their printing along with promoting approaches.

chenlina said...

chenlina20170228
tory burch handbags
cheap jordans
adidas outlet online
kate spade
adidas shoes
miami heat jerseys
mont blanc pens
hermes handbags
mont blanc mountain pen
nike outlet