Wednesday, December 2, 2015

Crystal Reports : Driving Grouping with 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!

5 comments:

Willie Kaminski said...

Just curious, as this is my main trouble with hand taken notes in that I can't decide any logic. But then I don't ever have a computer handy to put them in a database.
essay writing service reviews

Zheng junxai5 said...

zhengjx20160623
nike blazers uk
jordan shoes
michael kors purses
air jordan femme
kobe shoes 11
louis vuitton outlet
nike trainers sale
ray ban sunglasses outlet
michael kors outlet online
cheap oakley sunglasses
celine bags
toms wedges
michael kors outlet clearance
cheap jerseys
nike air max
coach outlet
louis vuitton handbags
rolex watches
louis vuitton purses
cheap air jordans
cheap basketball shoes
christian louboutin sale clearance
adidas factory outlet
adidas outlet store
rolex watches
hollister clothing
cheap jordans
hollister jeans
toms shoes
michael kors outlet online
coach factory outlet
beats by dr dre
nike roshe run
true religion outlet online
air jordan shoes
jordan 3s
montblanc pen
ralph lauren
cheap oakleys
ed hardy outlet

Hua Cai said...

michael kors factory outlet
ralph lauren outlet
rolex watches
adidas wings
nike air max
oakley sunglasses
mizuno shoes
coach outlet online
michael kors outlet
timberland shoes
mulberry handbags
christian louboutin outlet
toms outlet
cheap ray ban sunglasses
new balance shoes
ray ban sunglasses
longchamp handbags
fred perry polo shirts
fitflops outlet sale
rolex watches
coach outlet
omega watches
cartier outlet store
swarovski crystal
oakley sunglasses
michael kors outlet online
prada outlet
cheap mlb jerseys
chaussure louboutin
jordan shoes
hollister uk
chicago blackhawks jerseys
tiffany jewelry
oakley sunglasses uk
ralph lauren outlet
20160716caihuali

Meiqing Xu said...

polo ralph lauren outlet online
converse shoes
louboutin uk
birkenstock sandals
true religion jeans
converse outlet
moncler outlet
ugg boots
michael kors outlet store
coach outlet
20161209caiyan

dong dong23 said...

tory burch outlet
michael kors outlet clearance
coach outlet
north face
supra sneakers
oakley outlet
true religion outlet
cheap ray ban sunglasses
ice jerseys
fitflops shoes
2017.1.19chenlixiang