Gary,
Somehow three of my settings got changed. Though I do the maintenance on the database, I have not been given the permission to limit others access to these settings. It looks like someone changed not only the zero setting, but also the date settings. After resetting these items, the report worked just fine. Is the default setting for ZERO always ON? I need it on for this report. I realize I can change it on the fly but forget now what the default is when one first gets RBASE. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: Saturday, February 06, 2010 5:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: year comparisons in report Jim, did you set zero on before running the report? Gary ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Saturday, February 06, 2010 2:53 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
