Notifications
Clear all
Topic starter
Happy Friday Chuggers:
I have created a report in Crystal Reports Designer and get the results I want running it directly in Crystal. When I attach this report into my CPS system, I get the following error. Any ideas?
An error occurred while running the report file 'xxxxxxx.rpt":
Any one ever run into this situation? I am pulling out my hair and am going crazy.
Posted : November 18, 2016 6:11 am
Topic starter
Uggh It appears that the original posting has dropped half my message off.
An error occurred while running the report file "xxxx.rpt"
Cannot set the record selection formula
Crystal Reports returned this error
This field name is not known
Posted : November 18, 2016 6:13 am
Post the record selection formula.
Posted : November 18, 2016 6:17 am
This often happens to me when a table or view is not accessible via the report user. I use Oracle but I am sure it would be similar in SQL server.
Do you write your reports in crystal using the Report user/pass or do you use a database admin user/pass? You should be using the report user if you are not. One example in CEMR of a table that would cause this issue is the USR table. (or any table that contains a password hash) In CEMR you have to use the view USRINFO instead of the table USR within Crystal reports.
Posted : November 21, 2016 3:46 am
