Crystal Report Windows Forms Viewer Error : Invalid Argument Provided

[Former Member]

We have created a report which joins SBO tables with a u2018Commandu2019 (SQL Query). The report is run from within the SBO client. On the server everything works perfectly, but when it is ran on the workstations the report can be previewed only once and when the report is refreshed, an error appears:

Crystal Report Windows Forms Viewer

Invalid Argument provided. Error in File xxx.rpt: Invalid argument for database.

We have followed the installation instructions and installed: Crystal 2008 for SAP B1, .Net Framework 3.5, Crystal Add-On (Ver 2.0.0.7) and the Crystal Runtime_12_0_mlb on the server and .Net Framework 3.5, Crystal Add-On (Ver 2.0.0.7) and the Crystal Runtime_12_0_mlb on the workstations.

Has anyone experienced this problem before, is there a solution for this problem?

[Former Member]

1. When you go to database expert, go to the link tab, Right cick on the link between table and the Command, you will see below a box next to "Return all rows before linking".

If it is checked, try uncheck it and see if it resolves the problem and vice versa.

2. If it does not work, go to Database--> Show SQL Query, you will see the SQL syntax sent to the database server for retrieving data back to your report.

If there is no proper link and there is not much in the where clause, the chances is that there are too many records sent back to Crystal report before your filter in record selection is even processed.

if that is the case, you might want to use SQL views instead of SQL command. Of course, use the Database--> Show SQL Query to ensur that limited records are returned.