QuarterToDate Function

[ashark]

Hi Group,
I have a doubt.
In CrystalReport 8.5 there are functions for YearToDate and MonthToDate.
I need functions for QuarterToDate and DayToDate.
Do I have to create formulas for them or are they available in some other format.

Please help.

 

[Naith]

In 8.5 there are some functions called Calendar1stQtr to Calendar4thQtr. If you don't have data postdated to future dates, you can use them for quarterly data manipulation as you would use Year/MonthToDate.

Otherwise a simple formula will do the same thing.

Naith

 

[123ASP]

hi, can you please show me how to use CR 8.5 function for the Calendar1stQtr.
I have a table that contains date|amount|runningtotal
and need to run a report that generate sum each quarter. I am not sure how to use the above function.
thanks for your help
Al

 

[Naith]

Like this:

If {YourDate} in Calendar1stQtr
Then {YourAmount}
Else 0;

(If you're ever unsure about any of the functions mentioned in the forum, if you go into your copy of Crystal Reports, and press F1, the help files should give you quite a good breakdown.)

If you want to use your formula all year round, but are only interested in the current quarter, then you could use a formula to say:

If CurrentDate in Calendar1stQtr
Then 
If {YourDate} in Calendar1stQtr
Then {YourAmount}
Else 0
Else
If CurrentDate in Calendar2ndQtr
Then 
If {YourDate} in Calendar2ndQtr
Then {YourAmount}
Else 0

...and repeat until you have all four quarters accounted for.

All the best with your report,

Naith