Year To Date-Month To Date-Week To Date Field

[ChiTownDiva]

I have a cross-tab report that I need to add Year-To-Date, etc to the report.

How do I do that?

 

[kenhamady]

You may not be able to add them to the cross-tab.
What version of CR?
What are the fields used in the cross-tab?

Row
Column
Summarized Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[ChiTownDiva]

Hi kemhandy. Thanks for responding. The report is for a Marketing Leads report.

It's the 8.0 version of Crystal.

The rows are State and City.

The column is a Campaign ID

The summarized field is a count of the Lead ID.

There is also a field in the database called "Date_Received" which is what the Year-to-Date, etc. is based on.

I hope this answers you question.

Thanks for your time.

 

[dcm]

ChiTownDiva: If you were to restrict records in your cross tab through a parameter or selection formula so that they only included records where Date_Received in Date(Year(Currentdate),1,1) to Currentdate then your figures in your cross tab would in effect be YTD David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[kenhamady]

Add a formula called YTD to the report with the following formula:

If {Date_Received} in YearToDate
then 1 else 0


Now make this a summarized field in the cross-tab. This will add YTD in every summary cell of the Cross-tab. You can do the same with MonthToDate or any other date function. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal