I am just learning to use the Command SQL function Crystal reports. Will this new functionality have any affect on the report viewer in Dynamics GP. Are there any pitfalls I should be aware of?
Date
Votes
1 comment
-
Mickie Stamm Hi Pat,
Thank you for posting a question in our Community Help forum. Depending on what you are doing with the SQL Commands, it may not be supported with GP Reports Viewer.
Here is one case that has been documented in our knowledge base where a SQL Command based on a stored procedure does not work properly and had to be pointed directly at the stored procedure instead: http://support.flex-solutions.com/entries/20942812--This-field-name-is-not-known-error-when-running-report
In addition, if you use a parameter in your SQL Command it will be brought into the Report Maintenance screen in GP and you can map a value to it, however the Crystal Runtime files may prompt you to provide a parameter value when the report is run with GP Reports Viewer.
It might be a good idea to create a test report with the functionality you are looking to use with the SQL Commands and test it with GP Reports Viewer before going to far with using them.
Regards,
- Mickie
Please sign in to leave a comment.