Issue with Running a Crystal Report -- Error Message

SUGGESTED

I am having an issue with a Crystal Report that I have pulling the data from the SQL replicated data.  The data pulls when I run the report in both Crystal Reports and also when I run from within Sage from any of our companies.  Upon having a user try and run the report, it works under 1 of the companies but they are receiving an error upon trying to run in any of the other companies. 

I would think if it was a parameter issue, it wouldn't work in any of the companies for any of the users, which is what is throwing me for a loop.

Parents
  • 0

    I guess I hadn't read your original message as thoroughly as I should have. I would look at your security settings. Perhaps certain users lack security permissions for the companies where the report doesn't function. I would look at both company permission assignments as well as file level security settings for those users.

Reply
  • 0

    I guess I hadn't read your original message as thoroughly as I should have. I would look at your security settings. Perhaps certain users lack security permissions for the companies where the report doesn't function. I would look at both company permission assignments as well as file level security settings for those users.

Children
  • 0 in reply to Art Minds

    I think I may have figured out part of the issue.  Upon looking at her user on the SQL database side, the database role memberships were assigned matching Sage for the one company that was working.  For some reason within the other companies it was not.  The owned schema checkbox on the other companies is checked tying back to her user for some reason unlike the other users.

  • 0 in reply to Curtis Morrow

    Art, upon deleting these user schemas that were tied to the user and marking the correct database role memberships the report is now working for the user.  I'm not quite sure why it decided to create the schema for this particular reason when it hasn't been for other users.