Data Access Worldwide Knowledge Base
Article Text
QUESTION:
I have 600+ reports in my company and the database driver used is the old p2dbflex driver. I was still using CRW 7 and VDF7, but now I am going to use VDF11.1, Crystal XI and the current Crystal Connectivity Kit p2bdfapi. How do I update all my reports to the newest driver? Do I need to do it by hand or do you know of a tool I can use?
ANSWER:
With revision 11.1 of Visual DataFlex we support the use of Crystal Reports via RDC (Report Designer Component). This is a COM interface. The interface can be used to simply run your reports but it can also be used to alter reports. For altering reports you need to have a developer license of Crystal Reports and, if the program written runs at customer site, they need a developer license as well.
The enclosed view has two functions:
- Change the driver from p2dbflex to p2bdfapi
- Verify database
Modified reports are stored in a directory that you can specify in the dialog.
During the process the status information is written to a text editor window.
Remarks:
For every table that is being verified (with ComVerify) Crystal reports two or three messages which YOU have to OK yourself. There is no silent mode, so changing 600+ reports require 1200-1800 clicks on a popup window. Prepare yourself for this.
Contributed By:
Vincent Oorsprong
Company: Data Access Worldwide
email: vincent.oorsprong@dataaccess.eu
Web Site: http://www.dataaccess.eu
Web Links Related to this Article
File Convert.zip
URL=http://www.dataaccess.com/KBasePublic/Files/2221.Convert.zip
Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2010 Data Access Corporation. All rights reserved.
| The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply. |