Tuesday, December 29, 2009

Crystal Reports : The Perils of Double Bucketing Continued

Double bucketing; it is a scourge upon the hapless Crystal Reporter!

Another technique to use when bucketing is to force Crystal to use mutually exclusive "automagical" functions. A good example of this is to use the YEAR() function to group any date by it's corresponding year.

So, if we break out INVOICES.DATE by grouping by YEAR(INVOICES.DATE), we can be assured that any one invoice can only belong to one specific year. Therefore we avoid double bucketing.

But the needs of the client are paramount; some businesses like "strange logic" to be applied to their buckets, depending on usage requirements.

An example: a client needs all invoices cut in December 2009 to belong to year 2010, yet anything previous should belong to year 2009.

So:

2010 Bucket:
YEAR(INVOICES.DATE) = 2010 OR (YEAR(INVOICES.DATE) = 2009 AND MONTH(INVOICES.DATE) = 12)

This code above includes all invoices with a year of 2010 AND also the ones from December 2009.

So we can see that sometimes the "automagical" crystal date function do not always meet the expectations of the client.

Know your manual date math! And beware the perils of double bucketing!

6 comments:

Sadia said...

The only way to achieving this is by providing essay writing service ineedessayhelp quality education to the population of learners at all levels.

Anonymous said...

lucky patcher apk

Simon Hog said...

Lucky patcher app is used for removing ads from various application and we can also hack apps for in-app purchase. Download lucky patcher 6.4.1 | Lucky Patcher latest version download

Thomas pedro said...

On the off chance that it's a great opportunity to overhaul the wheels however you don't have the money forthright, an individual credit is a fabulous approach to get what you need. Be reasonable about the reimbursements you'll need to make however- - you have to calculate the running expenses of the auto, the protection you'll need to fork out and the enlistment and overhauling every year. payday loans chicago

Anonymous said...

Lucky Patcher apk

marko said...

You may surmise that house chasing takes a while, however handling the printed material for a home credit takes longer. So you need to do all that you can to prepare yourself for it, even as you're chasing for a home. Payday Loans Chicago