Topic: Report on content of one field in a table
Hi Everyone,
I have table with a field called spare
That field has 2 values Installed and Spare
.
I would like to print 2 reports - one with only records containing Installed and another with only records containing Spare.
Basically I would like to be able to filter a record in a table for the value in the field. I'm thinking that this ability to filter data could be useful going forward.
.
I have been told to use Report(SQL) but I have been unable to write a query that will do that for me. My coding skills are limited :(
.
I have tried to do it using REPORT and REPORT(SQL) without success.
-------------------
One more comment, I have been able to use the filter option in a tableGrid to get only the records I referenced above, however I have not been able to transfer those records to a report.
.
Thoughts will be appreciated.
Thanks, Frank