ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> LYTD and CYTD
http://www.istechforum.com/YaBB.pl?num=1219349257

Message started by Dawn on 08/21/08 at 13:07:37

Title: LYTD and CYTD
Post by Dawn on 08/21/08 at 13:07:37

I am trying to write a Cyrstal Report (v11) with Last Year to Date totals in one column and Current Year to Date in another Column within the same report. I can get both LYTD and CYTD but not in the same report. I also want to put in Historical data by the month in that same report. Again I can get it but not as an all in one report.

Title: Re: LYTD and CYTD
Post by dameng on 08/24/08 at 13:23:07

you need to have the record selection for both years, but do not put the fields themselves in the detail section

instead, create a formula, such that, "if part date in period lastyearYTD then part quantity field else 0" and same for the current year formula " if part date field in period currentyearYTD then part quantity field else o".

then place those in the detail section. create a group on your part number and subtotal your formulas.

there are other ways as well, depends on the complexity being created.

hth