Share
ReportWhen using Microsoft Dynamics SL to view a custom report that is linked to a custom view, table, or stored procedure and you get this error message...
Cannot start print job. Report: C:\Program Files\Solomon\Usr_Rpts\CUSTOM.RPT Crystal Print Engine Error: 723 - Error in File C:\Program Files\Solomon\Usr_Rpts\CUSTOM.RPT: Failed to open a rowset.
...check to make sure you have set the correct permissions for access to your custom view, table, or stored procedure.
You can run this SQL script (make sure you have proper backups in case you make an error) to set the permissions correctly after you change the object name to the name of your custom view, table, or stored procedure and change the long user name shown in the first line of the script.
--I removed some the middle charactors from the user that Dynamics SL uses to select records but left enough to give you an example.
GRANT SELECT ON [dbo].[TableOrView] TO [E7F57.......DD7CE]
GO
GRANT CONTROL ON [dbo].[TableOrView] TO [MSDSL]
Tip: A simple way to get your correct permission settings is to ...
1. Right-click on a view/table that you know works with Dynamics SL.
2. Click Script View/Table as - Create to - New Query Editor Window
3. Look for the two lines of script as posted in the example above clear at the bottom of the script
4. Copy/Paste these few bottom lines to new query window
5. Change the table/view name as mentioned above and run the script
I have run into this several times now that I have created a new view and then linked to my report (Crystal Report) with no problems. But when I try to run it in Dynamics SL I got the error that I mentioned above and could not remember what I did wrong. So I went online to CustomerSource but all the links there refer to other issues. Then, finally, sometimes by the help of my colleagues, I discover it is a problem with my permissions in the SQL 2005 database.
I hope can be helpful to someone else who has the same error.
*This post is locked for comments
All responses (
Answers (
5
