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.
7 comments:
This is very good. Thanks for shared..........
Crystal Custom
It is very helpful.
Crystal Custom
Nice looking
Crystal Custom
Take introductory programming classes at a college or extension college offering C#.
http://www.dotnetobject.com/
Awesome
Crystal Custom
International Crystal Manufacturing (ICM) manufactures a broad line of custom quartz crystals. Quartz crystals are thin slices of quartz placed between two electrodes, housed in a hermetically sealed package that provides a means of connection to a circuit.
Crystal Custom
Our strength is the fabrication of our own crystal rhinestones which have between 12 and 16 facets that gives them a greatest shine as well as unique colors not available on the market today only exclusive for our company.
Promotional Sunglasses
Post a Comment