Which db connection did you use when you created the report?

I used ODBC (RDO) to connect to the SQL Server

Does your report use any custom views or reference databases outside of your current Sage 300 database?

Also - when you authored your report, please consider the authentication method used. I would suggest NOT using trusted for reports needing to be run from within Sage 300.

Finally, please ensure that the option to Save Data with Report is de-selected.

One more thing - as a last resort, please ensure that Data Execution Prevention is set to the lower of the two levels available.

Does your report use any custom views or reference databases outside of your current Sage 300 database?

Also - when you authored your report, please consider the authentication method used. I would suggest NOT using trusted for reports needing to be run from within Sage 300.

Finally, please ensure that the option to Save Data with Report is de-selected.

One more thing - as a last resort, please ensure that Data Execution Prevention is set to the lower of the two levels available.

The report is using the tables directly from the Sage 300 database (OEINVH, OEINVD for e.g)

I have tried again with the Trusted Connection turned off with no luck

The Save Data with Report is also off

Where is the Data Execution Prevention located?

Can you also tell me how to prompt for parameters for my crystal report from the Sage UI?

Thanks :)

Hi,

If the custom report is referencing database outside SAGE 300, can we still use AccpacCOMAPI.AccpacReport object?