Monday, September 30, 2013

Crystal Reports : Creating a Custom Parameter Choice

Let us consider our {?UserID} parameter, which accepts multiple values.
Let us further consider that the end-user will need to occasionally print the report for all UserID's. They could simply add each UserID to the parameter before printing the report, but in cases of many UserID's, this becomes cumbersome.
A better solution is to give an "all" option in the parameter choices, then use the following code:

if {?UserID} not like "*all*" then {SALES.USERID} = {?UserID} else true

Here is what's happening:
IF our parameter DOES NOT have he word "all" within it, we execute the Selection Criteria normally. The trick here is that our ELSE clause ends in TRUE, which means that we "skip over" this part of the Selection Criteria, therefore returning ALL UserID's.

1 comment:

Anonymous said...

A normal Dooney Carrier works with a value of approximately $300 money which usually chanel outlet is truly a actually value, due to top quality top quality Dooney and also Bourke are notable for. You will find several superstars bringing these kinds of artist hand bags around, and also unless you feel myself merely grab any newspaper occasionally and you may notice yourself. The particular Dooney Carrier is manufactured having an extraordinary buckskin substance and also sewed also flawlessness. In the event you have been to get the identical top quality goods which can be made out of some other developers you'll notice the value will be considerably increased. Not merely will be the shades and also top quality perfect for buyers, nevertheless the developers by themselves acquire these kinds of delight inside their perform and also actually endure powering that, they've offered a few of their particular goods like the Dooney Carrier a very long time warrantee and also other goods feature a yr warrantee. Being a awareness, they could be regarded easily transportable timepieces. These kinds of designs can easily be involved in the 2 qualities, side to side and also chanel replica top to bottom meridian, and also which usually need to, needless to say, driven so your top to bottom wall structure going through in the direction of the particular to the south. The particular Gnomon sign regarding hrs can be a twine in which will serve to keep up the particular perspective regarding ninety days ° involving the a couple of quadrants. Hence, the identical twine kind occurs with all the side to side aircraft a great perspective corresponding to the particular latitude with the spot. Which means top to bottom perspective means the particular co-latitude with the spot.