Thursday, March 26, 2015

Crystal Reports : Getting Creative with Parameters

Usually we think of Parameters simply storing values for selection criteria. Start Date, End Date, ad nauseam. But let us not forget a Parameter can store ANYTHING. Including "switches" which can then be evaluated by Formulas.

Example;

I want to include a parameter that specifies whether or not to calculate Tax for every line item on an invoice report. So, I create a Parameter called {?Tax} with two possible choices, "Yes" or "No".

So, then, my Tax Formula looks something like this;

IF {?Tax} = "Yes" THEN {INVOICE.AMOUNT} * .07 ELSE {INVOICE.AMOUNT}

I also use this trick to Hide or Suppress detail sections on reports with a lot of Summarizing.

Remember, a parameter that only drives Selection Criteria is dying to let it's full potential out!

1 comment:

Anonymous said...

At present, some people are located in distinct versions and even signs to help you prompt an important trace in contemporariness in them. Building just the right account balance around customary and even today's design, chanel replica sale they are really somewhat that sizzling hot most-liked in between today’s 21st 1 adult females. replica chanel Quite possibly the most evident facet of an important jute backpack is without a doubt that experts claim it will be eco-friendly. chanel replica sale In our universe, at which citizens are often grieving within the considerable file format in contamination with absorbed that herbal and even good surrounding, chanel replica sale eco-friendly programs is the demand belonging to the 60 minutes. chanel replica sale Unlike cosmetic plastic bags, jute plastic bags are made of herbal fibre, as a consequence helping to make them all a good pick.