Monday, July 27, 2015

Crystal Reports : Using Custom Parameter Values

Parameters need not only drive selection criteria;

We will create a parameter that will control whether or not taxes are added to each Invoice.

Create a parameter called {?Tax} and give the users two options, "Tax" or "No Tax".

So,. based upon what user chooses, the formula will calculate itself differently. Here is how it might look;

{@frmTotal} :

IF {?Tax} = "Tax" THEN ({INVOICES.TOTAL} * .08) + {INVOICES.TOTAL}
ELSE {INVOICES.TOTAL}

So, you can see that if "Tax" is selected, the Invoice total adds eight percent to itself. We need not test for "No Tax" explicitly as there are only two choices.

You could also do it this way:

IF {?Tax} = "No Tax" THEN {INVOICES.TOTAL}
ELSE ({INVOICES.TOTAL} * .08) + {INVOICES.TOTAL}

Giving the end user the ability to change the way the report is calculating (rather that just modifying the Selection Criteria) is an extremely powerful way to create some longevity for your reports.

2 comments:

beliuy trey said...




Several unsparing brandnames that can be duplicated as a result of tswisswatch grant Audemars hublot replica uk, Buzzer and even General practitioner look-alike rolex replica sale, Breitling reproduction running watches, Cartier copy running watches and even Chopard imitate running watches. Many are that brandnames that can be e'er on ignoring exact same concerning people and even replica chanel is known as a well-rounded significant difference as a result of a lot of these brandnames which can be offered by a powerful unexpectedly raucous cost you. A lot of these replica watches uk really be like to their seminal brandnames. Some other legendary brands' running watches can be bicephalous together as a result of Tswisswatch within a evaluate. A lot of these legendary brandnames anxiety IWC, Zenith, Versace, Vacheron Constantin, Ulysse Nardin, U-Boat, chanel replica uk, Sinn, Rolex, Roger Dubuis, Rich Mille, Tswisswatch is known as a highly regarded web based adventure which inturn cases to help you delude imitate running watches.

PLC training in chennai said...


WIZTECH Automation, Anna Nagar, Chennai, has earned reputation offering the best automation training in Chennai in the field of industrial automation. Flexible timings, hands-on-experience, 100% practical. The candidates are given enhanced job oriented practical training in all major brands of PLCs (AB, Keyence, ABB, GE-FANUC, OMRON, DELTA, SIEMENS, MITSUBISHI, SCHNEIDER, and MESSUNG)

PLC training in chennai
Automation training in chennai
Best plc training in chennai
PLC SCADA training in chennai
Process automation training in chennai
Final year eee projects in chennai
VLSI training in chennai