Wednesday, September 30, 2015

Crystal Reports : Use Fornulas to Group

One of the most effective techniques I've learned is how to group on a formula.
Think of it this way: the logic of the formula can be whatever you want it to be. So, any "high-level" corporate logic can be expressed here.
Take for example a table called HISTORY in which are listed history items per user.
Let us create a formula that will "kick-out" a value based on HISTORY.DATE.

IF {HISTORY.DATE} > CURRENTDATE - 30 THEN "History within 30 Days" ELSE
IF {HISTORY.DATE} < CURRENTDATE - 30 THEN "History beyond 30 Days" ELSE
{HISTORY.DATE}

Now this formula can be used as a Group.

You will notice that the last line is an ELSE {HISTORY.DATE}. This is because if a {HISTORY.DATE} does NOT fall into our formula criteria, then it will be "skipped". The final ELSE works as a "catch-all".

1 comment:

Viora care said...

When i took the Louis Vuitton Damier Swift by himself towards chanel replica sale in addition to came to the realization of which as a legitimate oh Talk about admirer I needed some sort of tote having workforce colorings. awarded that case isn't a where by next to the regular radar, this can be a sensible case choice to take as soon as cheering with Oh Talk about. This chanel replica sale manufactured having healthy canvas human body in addition to reddish colored patent household leather within the entry buckles, connectors, in addition to outlining. This big form a contrast is usually colorings is usually a little considerably intended for the usual palette, We have a hold buckling under the entry flap closure. Some gals that could steel reddish colored chanel replica sale and so amazingly well, Christina Aguilera seemed to be viewed causing trendy Hyde rockin' available the woman edgy in addition to vibrant glimpse. Christina in addition to I should chanel replica sale chill sometimes, employ a young child communicate, then your lover can certainly indicate everyone the woman makeup foundation regime. Plainly put on this colorings in addition to volumes your lover may, I had appear like some sort of clown.