X hits on this document





94 / 96

Flexible Solutions, Inc. – GP Reports Viewer


  • Are there spaces in any of the objects used in the report? Crystal reports will not typically work when there are spaces in any names. This includes tables, stored procedures, views or any of the fields in them.

  • Are you using the Optional Parameters and/or ‘hasValue’ function new to Crystal Reports 2008? The Crystal Viewer within GP Reports Viewer is not able to interpret these correctly and may cause the following error: A number, currency, amount, Boolean, date, time, date-time, or string is expected here.

  • To rule out SQL Server permissions issues, test printing the report with ‘sa’ set up for the Optional SQL Login (please see Setup Options for more detail). When testing this, make sure that the Use Default SQL Login and Password from Setup Options Window option on the Report Maintenance window is checked. Often incorrect permissions will result in an error similar to The table ‘’ could not be found.

  • If a table, view or stored procedure that you Crystal Report is based on has been changed, you may receive an error about unknown field names (for example, The field name is not known). Any time there are changes to the underlying tables, views or stored procedures a one-time update needs to be performed directly in Crystal. The steps for this are below:

    • o

      Open your report in Crystal Reports.

      • o

        Go to Database >> Verify Database.

      • o

        You may be asked for a SQL Server login at this point.

      • o

        Once completed you will receive a message saying The database is up to date.

      • o

        Save the report.

Crystal Reports setup –report prints, but to the wrong printer or margins are off

If the report prints to the screen correctly but is not printing to the correct printer, or if the margins of the report are not what you are expecting, check the Page Setup options in Crystal Reports (under File > Page Setup). If the report will be printed to multiple printers, check the No Printer checkbox. If you are seeing an issue with margins, make sure the Adjust Automatically box is unchecked and that your printer allows the margins specified on the report.

Document info
Document views521
Page views521
Page last viewedWed Jan 18 22:34:26 UTC 2017