Wednesday, October 3, 2012

Crystal Reports : Using a Date Range Parameter

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:

Anonymous said...

Hi,

Here, in my scenario the "date range" is of calendar month like MM/YYYY.

In this case if wanted to find the max year from "date range" parameter, how the formula need to be written.

For example, if I have entered 10/2012 - 09/2013, I would like to see '2013' as my output.

Anonymous said...

Other individuals get regarding green dependable elegance included. replica cartier It is actually some sort of device what are the real truly appreciate that will dress in also to the dive trip utilizing mates and to all exceptional periods. prada replica Titan Business is definitely outdoor patio umbrella for numerous types that have already several bunch of pieces the fact that feature any richness together with exclusivity provided by him or her. replica prada During the endless rush for beginning different together with alluring varieties fashionable pieces by just nationalized together with world types, Titan has established a niche meant for again during the Of india promote. fake hublot There is highly sought after structure galleries that will always innovate over the variations together with systems that this gives you. hublot replica uk Any guardian type Titan economies a products and services in numerous sub brands- Fastrack, Sonata, Helios together with Xylys.

Silvia Jacinto said...

I really love your blog there's a lot to share. Keep it up.Visit my site too.

n8fan.net

www.n8fan.net