Problem using crystal report with Visual Foxpro Tables.
Posted on 2004-08-26
I have an application in VB which accesses data from a Visual Foxpro Table ( NAMES.DBF ) using Microsoft Remote Data Control (MSRDC). The application displays a list of names from which the user has to select one. Next I have a report created with crystal RDC which has the same foxpro table (NAMES.DBF) + a linked table (DETAILS.DBF) as data source . Both the Remote Data Control and the Report use DSN less ( connection string based ) ODBC connections. This report displays the details associated with the selected name. My problems are:
1) This arrangement works fine for the first 10 records in the NAMES.DBF table, but if I select
the 11th name or any name with record position > 10 , the report goes blank and does not display
the name or any associated details. Is it due to the two concurrent connections (MSRDC & Report)
to the same table ?
2) When I click on the 'Print' button in CRViewer91 toolbar, It gives an error: " There is not enough
memory for this operation " although the 'Export' button works perfectly fine.
3) Since the application is to be distributed, the location of these tables may depend on end user.
So , instead of hardcoding the data source location, I need it to be specified by the user at
runtime and changes being automatically made to the data source properties of the MSRDC and
Crystal Report . While I have found a way of doing so for the Remote Data Control, I dont know
how to do this for crystal report.
Since I have no knowledge of Visual Foxpro and am a beginner in VB and Crystal Reports, I shall appreciate all your suggestions along with the solutions to my problems. Thanks.