anyone here use crystal reports?
#1
Scooby Regular
Thread Starter
Join Date: Sep 2001
Location: Bangor, Northern Ireland
Posts: 2,033
Likes: 0
Received 0 Likes
on
0 Posts
anyone here use crystal reports?
boring fri afternoon question...
example,
i have a report pulling data from one table. now, i only want to pull records with the last 3 years (but to make this a rolling report i dont want to hardcode the criteria). there is a year table so what i want is a join on where the year is within the last 3 years (i know this is a bad example as you might use some date function but it's actually periods i'm using...)
normally i would just use something like (in SQL)
table.field in (select max(period), max(period)-1, max(period)-2 from period)
but how the hell do you use the function wizard thing to do this? i can't suss it out
cheers!
steven
example,
i have a report pulling data from one table. now, i only want to pull records with the last 3 years (but to make this a rolling report i dont want to hardcode the criteria). there is a year table so what i want is a join on where the year is within the last 3 years (i know this is a bad example as you might use some date function but it's actually periods i'm using...)
normally i would just use something like (in SQL)
table.field in (select max(period), max(period)-1, max(period)-2 from period)
but how the hell do you use the function wizard thing to do this? i can't suss it out
cheers!
steven