Hi, I am having a trouble with a report I am trying generate. I have some experiences with crystal reports, but this report I am trying to pull has gotten me stump. Any help/advice is very much appreciated.
We have a database that data gets enter on a daily basis. I connect to crystal reports through OLE DB (ADO). The following fields are fields that I need to show in the report.
Table name: FEES
LastName_
FirstName_
State_
Month_
Date_Created
A total of 646 people are in the database.
The field name "Date_created" (located in the same FEES table) which records the date and time that the record was recorded.
The report that I need to generate needs to pull data (lastname, firstname, state, and month, Date_Created) that did not report at the end of the month.
So, if John Smith did not reported his data for the month of October, I need his information (lastname, firstname, state, month, Date_Created) to pull from the data.
Thanks!
IP Logged
