I am finding lot of problem generating reports using Visual Basic 6.0 data report with Ms-Access 97 as backend.
1. I have generated few reports using Data Report control. The report gets all records when generated for the first time (Filtered by a value). The same report generated second time displays a all records except the last record. The filter value generated are correct only the last record is missing.
What can be the problem and solution for it.
2. Some times the recordset is cleared when the report is generated for the second time to clear the first time recordset. But it does not clear the recordset always. What can be the problem and solution for it.