Sage 100

2014 Premium / Crystal reports - Created SQL stored procedure and use it as the data source in a Crystal report. The report runs fine until I add it to the Sage 100 Sales Order, Custom Reports menu... Then I get an error message. See attached.

When it works inside of Crystal are you running it with the sa account or with the account your logged into Windows with? If so Try running it and specify MAS_Reports as the SQL login. See if you get the same error. If so likely a permissions issue.

@AlnoorCassim That's it! My data source was using the sa login. Changed it to MAS_REPORTS and whola it worked. Thanks a million.

@DougHiggs does the MAS_Reports login have a password?

It does now. Not sure if it did before but I changed it last night and used the utility to sync sage 100 with sql.