Hi All
Last question for now:
I have to add a SQL statement (below) to my Crystal Report as this does not exist as an actual record. So I have two questions:
1. What is the best way to do this? and
2. The field highlighted (which is an inventory item ref) is actually on my report. But how do I populate this field with the correct reference i.e 00001.
(select min(pm_maintsched.mntsched_date)
from pm_maintsched, pm_maintplan_ivtitems, pm_mntplan
where pm_maintsched.mntplan_number =
pm_maintplan_ivtitems.mntplan_number
and pm_mntplan.mntplan_number =
pm_maintplan_ivtitems.mntplan_number
and pm_maintplan_ivtitems.ivt_ref = IM_INVITEM.IVT_REF
and pm_mntplan.reason_code is null
and pm_maintsched.mntsched_date >= GETDATE())
IP Logged
