Here's what seems to work on the details formula:
whileprintingrecords;
stringvar x;
if(OnFirstRecord) then x := totext({TABLE.YEAR}) + "-" else
if onlastrecord then
x := x + totext({TABLE.YEAR},0,"") + "," else
if {TABLE.YEAR} = next({TABLE.YEAR})-1 and
(
{TABLE.MODEL} <>...
Thanks for the help. Unless I misread the posts the first reply comes closest to solving my problem. However, for a range of years such as 1992-2002, 2005-2006 it ends up as: 2002,2005. For a range such as 1993-1999 it seems to work right. This was definetely the help I needed though. Thanks.
I'm doing a vehicle report. The report groups by model id. Each model has a bunch of years. It ends up looking like this:
Toyota Corolla 1992
1993
1994
2000
2005
2006
Acura Integra 1999
I want to be able to list...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.