Friday, November 30, 2012

Crystal Reports : Providing Custom Parameter Choices

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:

Patricia Pabustan said...

This is very good. Thanks for shared..........

Crystal Custom

Dhiman Sarkar said...

It is very helpful.

Crystal Custom

Sanjida Akhter said...

Nice looking

Crystal Custom

jannati jahan said...

Take introductory programming classes at a college or extension college offering C#.

http://www.dotnetobject.com/

amar jan said...

Awesome
Crystal Custom

Nomita Biswas said...

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

productsb softsolutions limited said...

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