Debbie, Not knowing more details about the report, make sure to check the SECTION defined for that particular variable in relation to its location on report section. If the variable is located in PF, for example, then make sure that variable is defined for PF section. To change the variable section accordingly: Variables > Change Section > Highlight that particular variable > Pick New Position > Click on Change. Also, change the expression as following: For Example: vJRNDate = (MAX(JRNDate)) FROM AHISTORY WHERE Policy = Policy Have Fun! Very Best Regards, Razzak. At 01:37 PM 5/9/2001 -0400, Debbie Schooley wrote: > >I am trying to get the maximum value for a variable that >is being listed on a report. The variable is not a column >in the driving table it is a column from another table. >When I define the variable as: > >vjrndate = max jrndate from AHISTORY where policy = policy > >the response that I am getting is 12/31/4000 in all cases > >When I try the same request from an r> prompt, I receive the >correct response - the maximum value for that column for that >policy > >r> select max jrndate from AHISTORY where policy = policy > >Is there any way that I can get the maximum value to show up >in the report for a column which is not actually on the table >that the report is driven from? > ===================================-============================ R:BASE Developers's Conference: http://www.rbase.com/conference Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase2000.com/events R:DCC Members: http://www.rbase2000.com/rdcc ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-=============================
