Tuesday, April 27, 2010

Crystal Reports : Displaying Parameters on your Report (Part 1)

We've covered these items before but I thought it would be nice to collect all the parameter tips in one place. It is extremely useful to display parameters on your report; more so while developing a report. Being able to tell at-a-glance what selection criteria is in use can be handy.

So let's talk about Parameter Data Types. When using a simple string or date, you may simply drag the parameter field onto the report within the designer. Even better, drag it into a Text Object to provide an identifier next to it.

Where you run into problems is here: when using a parameter that holds multiple values.

The first instance of this is when using a single date parameter that prompts for a Range.

Our Date Field : {?Date_Range}

Because the range is expressed with one fieldname, we must use some special functions to return the "start" and "end" of the range.

Create a formula field named {@Start_Date} and insert the following text:
MINIMUM({?Date_Range}
This will return the Minimum value in the range, or the Starting Date.

Create another formula called {@End_Date} and insert the following text:
MAXIMUM({?Date_Range})
This will return the Maximum value in the range, or the Ending Date.

You can now use these two formulas as simple fields to drag onto the report within the designer.

2 comments:

Ajascopee said...

That is good stuff. The parameter field worked ok just that al report the selection includes values outside the range and also i do not want to use the pop-up from crystal report. How can i do that?

Coco Ada said...

Omega Watches Swiss Watches accept been the dream watch for omega replica those who apperceive a bit about watches. The sole agitation is that not anybody can pay for to acquirement it. The abatement Franck Mueller watches at www.online abundance are of breitling replica the incomparable top superior which accept the ability to endure best at a decidedly bargain rates.The awfully to activate with Omega watch was produced in 1983 and was referred to hublot replica as Tourbillon. Each of the movements aural the Omega watches are developed by Omega alone, and they may be one of its sorts back in the accomplished crafted appearance and actions.Nonetheless, there appear to be a abundant amount of cartier replica additions to the watch anon afterwards it was launched in 1983 about the a lot of cogent 1 would be the abiding agenda & minute repeater. Aural just a abbreviate amount of time Cartier has advised a name for rolex replica abandoned and is been admired as the baton while in the industry. As a aftereffect of its technology and incomparable craftsmanship, Omega watches has been a accepted central the celebrity and appearance collectors. It is aswell admired for its abnormally advised dials and its ultra avant-garde cases.Adding jewels to the acme Omega Speedmaster of louis vuitton replica the Cartier band of watches could be the Casablanca which comes with an automated movement in a stainless animate case. This abnormally advised watch from Switzerland can be beat accidentally or on a dress too, as it fits both scenes actual appropriately and nicely.