Topic: Report Help
Hi All,
I'm moving right along with my project, thanks to the outstanding support I've been receiving from folks on the forum.
.
I'm trying to print a one page form with the information on my Equipment form. See the attached PDF file.
.
Everything works fine until I get to the bottom of the form with the Service information.
The Table on the bottom shows ALL of the service records for this piece of equipment. However I would like to show only the latest service record info.
.
I found a code section on the Report Writer and it looks to me like this is where you might put in some Pascal code to select only certain records. I tried putting the following into the code section:
strftime('%m/%d/%Y',date(julianday((select max(SvcDate) from tbl_Service
where tbl_Service.id_tbl_Equip = tbl_Equip.id)));, but it doesn't like it. It's telling me that it wants a ")" just before the "max"
.
If I run the report WITHOUT the code above, it works but it returns a separate page for each one of the Services in the table. As I mentioned, I only would like the latest record info.
.
I've never tried anything like this in the Report Writer so I basically have no idea what I'm doing.
.
Any thoughts will be appreciated.
Thanks, Frank