Data Access Worldwide Knowledge Base
Article ID 2036 Article Title PROBLEM: Crystal Wizard doesn't display fields for reports using ODBC Article URL http://www.dataaccess.com/kbasepublic/kbprint.asp?ArticleID=2036 KBase Category VDF10 Date Created 09/10/2004 Last Edit Date 09/10/2004
Article Text
PROBLEM:
For Crystal reports based on Crystal ODBC driver the Crystal Report Wizard in Visual DataFlex 9.0 seems to work fine until the dialog for field selections. This dialog and the next dialog (on Sort order) are blank; no fields are displayed.
The Wizard finishes and the report runs from the generated report view.
What could be causing the problem?
SOLUTION:
In Visual DataFlex 9.0 and 9.1, the wizard will not get the fields from the report if the report is not based on DataFlex files.
In Visual DataFlex 10.0, the wizard tries to match the root name of the files in the filelist (excluding possible prefix and postfix) with the name of the table in Crystal (this could be the alias name). If a match is found, the fields will be displayed in both the selection and sort dialogs.
Contributed By:
Ulbe Stellema
Company: Data Access Worldwide
email: ulbe.stellema@dataaccess.eu
Web Site: http://www.dataaccess.eu
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.