Welcome, Guest. Please Login.
05/06/24 at 09:18:46
News:
Home Help Search Login


Pages: 1
Send Topic Print
LYTD and CYTD (Read 819 times)
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
LYTD and CYTD
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.
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: LYTD and CYTD
Reply #1 - 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
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
Pages: 1
Send Topic Print