Report - index tag error

[fjagdis]

I would like some help with this please :
I created a report using the wizard (VFP7). It runs perfectly in my development computer. However when I deploy on a client machine, running the report produces an Index tag not found error. At this point the table has been selected and the indexes are in use. I am grouping the records using a field that is not in the index. I can only think of two possibilities :
1. Perhaps I need to create an index based on the grouping field OR
2. Is there a runtime module that I need to include (using ISE to create distributable) to make reports run on the client machine ?
THANKS

 

[EzLogic]

When you did the report Wizar, the Report generated an index expression in your 'development' tables. However, it seems like your client tables do not have the index key. What you can do, is open the tables on your computer and find out what the index express is and then make sure you do the same @ the client's computer.



Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan

 

[fjagdis]

Thanks tecknoSDS I will try that.

 

[fjagdis]

Follow up :
TecknoDS is correct...the report wizard did create a .CDX file for the table. Moving this to the client machine did allow the report to run. I was still not happy with the results so I did the following :

1. I needed the table sorted by a field to produce sub totals. So I sorted the records to a temporary file. The result was that the records were now in the desired order.

2. I created a new report using the report designer (not the wizard). Be careful at the end of the process not to 'associate' it with the wizard. I ran the report using the temporary (sorted) file as the data source. My report is now sorted and sub-totalled correctly.

Hope that this is of use to others.