problems with queries

[thefalconduke]

Trying to get reports to work right. Was told by technical support to delete unnessary queries to make report run. That is fine if you have multiple queries but not for single query. We had switched servers and all the shortcuts had to be remapped. Ever since then we have had problems with the reports not finding records or the shortcuts just not working at all. All database tables (master) have been remapped and queries are matching data on the tables. Any ideas??

[kfleming]

If your report has a single query and you remove it and still get a no records found, check your relations and see if any have a Skip failure action. If so the source of the problem may be that no matching records have been found in the related table. If that is the case make sure that the related file index is indeed up to date.____Kathleen__R&R Support

[thefalconduke]

Skip failure is not selected, blank is. If I delete the query, everything in the table is displayed. We have a msg box set up to ask for a date to run the report, so it should display all data matching the date entered. The report did not have an index so I added one. Same reults.

[kfleming]

In place of the query create a logical calculated field that is the equivalent of your query. For example:__ORD_DATE>={06/30/2003}__if this calc is placed on a record band it should print a T for each record where the ORD_DATE field is greater than or equal to June 30 2003.__This can help to diagnose these kind of problems.__Kathleen__R&R Support