Monday, August 26, 2013

Crystal Reports : Pulling Out Starting and Ending Values from a Range

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)

1 comment:

Anonymous said...

Produced through Brazilian finished recently TelexFree might be instantaneously moving up typically the rating at the 'network ' rolex replica discipline. By means of the truth that the corporate is actually a little bit of during a time out of date it again keeps to generally be spotted should ıt's going to take typically the try out of this time. For anyone encountered this TelexFree Analysis, therefore it happens to be clean that you are currently as well aiming to locate through more information about the enterprise well before most people perhaps even be part of and / or you will have opted with the help of TelexFree not to mention you would like to learn how to build directs not to mention convenient hublot replica towards generate latest shops for ones business from home. Within the medical typically the afterward not to mention you want a lot more directs not to mention marketing for ones business enterprise follow this recommended nowadays. "TelexFree" was initially produced through Brazilian Jan 2012. Typically the business enterprise is right now fake rolex watches through AMERICAN since Nov 2012. Newbie for the reason that Anchor Telecom Plumber, in business for the purpose of 9 numerous years through AMERICAN 12/31/2002, it replaced manufacturers because of Average Dollars Emails towards Telexfree. TelexFree Analysis |What particular fake cartier watches Possesses? TelexFree’s method, 99TelexFree, is definitely a cell system utility of which payments $49. 99 month-to-month and provides people almost endless requests towards mobiles not to mention landlines in just Brazilian, the not to mention Europe. What's more , will make rolex replica practical for Cost-free picture requests, achieving requests, panel showing with the help of universal remote easy access and others. You would utilize system through forty two cities TelexFree Analysis |How Does an individual Earn With the help of TelexFree?