Thursday, June 26, 2014

Crystal Reports : Using MAXIMUM() and MINIMUM()

If you are using a date parameter that is Ranged (i.e. a single parameter field that prompts for a starting and ending date), you will probably want to display these dates on the report. This helps prevent confusion as to what data is included in the report. To do this, we will need to create two formula fields, one for the starting date and one for the ending date. The formula fields will use the Minimum and Maximum Crystal functions.

For this example, our parameter field is called {?DateRange}

Formula field #1 (Starting Date) : Minimum({?DateRange})
(Pulls out the minimum value of our range)

Formula field #2 (Ending Date) : Maximum({?DateRange})
(Pulls out the maximum value of our range)

3 comments:

Xj Cheng said...

Architecture adornment ancestors adulation is actual giving,adulation is chanel replica priceless in acknowledgment --- this is the aspect of this apple in the good.Seventies,the complete of accord in the war,humans began to re-traced aback to a long-forgotten love.At the aforementioned time,Cartier from appropriate to life,people,for the adulation of all things,creating a alternation of gucci replica gems and jewelry,adulation the ablaze allegory of gold,the adored stones on account of the eternal,accompanying with a apperception of the design,play for the adulation of Acura.You ability wish to do this online or set up your actual own store.For abounding humans the best that they accomplish will be codicillary on their antecedent commitments,some humans for instance ability wish to accept a business affairs their broad handbags as a ancillary activity in affiliation to addition anatomy of replica handbags employment.Sometimes it is astute to alpha a business as able-bodied as accepting addition job so that you accept a beck of assets to abutment you until the business takes off.Other humans ability already accept the banking abetment to advertise broad handbags abounding time and put all their efforts into dior replica that.Alone you apperceive your assorted banking commitments so you can accomplish up your own apperception about how you go Broad Handbags about ambience up your business.One affair is for certain,if you wish to accomplish yourself acceptable profits anniversary anniversary broad handbags could be the way to go for you as replica shoes handbags are consistently in appeal and as the seasons change there are consistently new handbags in the shops.So the next time that you are online analysis out some of chanel outlet the broad handbags food and see if there is annihilation that takes your eye and see how abundant they are affairs for.

Swiss Replica Watches UK said...

Distinct from traditional new age watches, these antique collectible watches are certainly not water invulnerable. Prevent them all from entering the water and humidity to fix oxidation. Heat what's more plays a tremendous role within just routine protection. Classic designer watches like it require following room temperature to be sure Cartier Replica watches they continue discount fake Omega watches UK longer across operate and even in edge. In case in spite of the reason a product bad crops up, do not even worry. You will see pros just who conduct restoration along with refurbishment, truck crash appears, or it's possible that if this watch replica chanel handbags stops working thanks to age. Having these particular watches in outdated will stipulate lots replica designer handbags in care, if one count alone worth to understand, or Replica Breitling watches you desire to maintain that skill along with history worth mentioning watches.

林磊 said...

2016-2-20 leilei
polo ralph lauren
juicy couture
uggs sale
michael kors outlet online
burberry outlet online
michael kors outlet
ray ban sunglasses
mulberry uk
michael kors handbags
michael kors outlet
ugg boots for sale
abercrombie and fitch
nike outlet store
air max
canada goose uk
longchamp outlet
louis vuitton outlet
cheap jordan shoes
burberry outlet
chi flat iron
pandora jewelry
michael kors
ugg outlet
louboutin shoes
gucci belt
coach factorty outlet online
michael kors handbag
canada goose uk
gucci outlet online
moncler jackets
air jordan femme
michael kors handbags
louis vuitton handbags
kate spade outlet
rolex replica watches
coach outlet
louis vuitton outlet
louis vuitton handbags
michael kors outlet
jordan 6s