PFXcrystal FAQ
How can Crystal Reports 9, 10 and XI work with PFXplus data?
Crystal Reports can access Powerflex database directly, connecting via PFXcrystal; or through ODBC, connecting via PFXodbc.
PFXcrystal 5.1 is validated for Crystal Reports 9, 10 and XI. It is a native driver supported by all editions of Crystal Reports 9, 10 and XI, including Standard and Professional.
PFXodbc 5.0 will allow Powerflex and compatible data files to work with Crystal Reports 9.0, 10 and XI, Professional Editions.
Please note that Crystal Reports Standard Editions do not support accessing data via ODBC.
Why are blank date fields in Crystal Reports 9.0 displaying 12/30/1899?
This is known bug in Crystal Reports 9. Check the Crystal Decisions website to see how to fix this problem.
Can the default for Auto-Link Tables be set to use 'By Key' for all reports?
In the Crystal Reports (CR) 9 Designer Database Expert, Links tab, the default setting for Auto-Link Tables is always 'By Name' for all reports. Is it possible to set the default to use linking 'By Key' for all reports. See Crystal Reports technical support for KBase Article ID:c2012286.
Does the PFXcrystal Driver support Crystal Reports version 8.5?
Yes, PFXcrystal 5.0 will allow Powerflex and compatible data files to work with Crystal Reports 6.0, 7.0, 8.0 and 8.5
Do I need PFXcrystal driver or PFXodbc driver?
PFXcrystal provides native access to PFXplus and compatible data files. If you wished to use SQL access to the .dat files, you would need to access your data through PFXodbc.
To create reports from PFXplus data files with Crystal Reports - use PFXcrystal.
To facilitate use of PFXplus data files with Crystal SQL Designer - use PFXodbc.
Can I use PFXcrystal with languages other than English?
Yes, PFXcrystal 5.0 supports other languages. You need to include the relevant collating sequence in the appropriate configuration files.
What causes "Physical Database not Found"?
The error "Physical database not found" or "unable to locate physical database", reported in Crystal Reports 7, 8 or 8.5 can be prevented by the following:
- Ensure that the Database Location has been saved as "Same As Report" when you create an executable (.EXE). *This also means that the EXE needs to be located in the same directory as the database, when you run it.
- If the report continues to display the same error message, you need to copy the PFXcrystal DLL (i.e. P2BPFX.DLL) into the report directory.
- If it then displays an "unregistered" message, copy the PFXcrystal INI file (i.e. P2BPFX.INI) there too.
What causes "Failed to load database information"?
If Crystal Reports 9, 10 or XI report the above or "The database connector crdb_p2bpfx.dll could not be loaded" error, check that PFXcrystal 5.1 was installed as described in the installation instructions included with the product. Alternatively, see PFXplus data files and Crystal Reports.