vYear = (IYR4(Quotedate)) Dennis McGrath ________________________________________ From: [email protected] [[email protected]] On Behalf Of Jim Belisle [[email protected]] Sent: Saturday, February 06, 2010 2:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - year comparisons in report
I am beginning to think I have lost my ability to create simple reports. I am making a simple report that compares information between two years. I create these vars vYear = (IYR(Quotedate)) vQ2009 = (IFEQ(.vYear,2009,Quotesubtotal,0)) vQ2010 = (IFEQ(.vYear,2010,Quotesubtotal,0)) vSumSt2009 = SUM OF .vQ2009 vSumSt2010 = SUM OF .vQ2010 the WHERE clause used is: Quotedate BETWEEN 01012009 AND 01312009 OR Quotedate BETWEEN 01012010 and 01312010 All I get are NULLS in the var fields vSumst2009 and vSumst2010 I checked RSTYLE and that was fine. The variables for the dates at the start of the EEP come up with the proper dates because they print on the report and the detail of the actual quotes show the Quotesubtotal field. The var are set in a break on the field shiptostate and are calculated on the detail section. The report is based on the proper table. Jim
