When I add more than one table to a report the program gives me an message Crystal Reports has stopped working. I chatted with SAP tech support, they upgraded me to the latest version and when that didn't work they told me to post in here... Any ideas?
Hi,
Change the Crystal Report Version in 2008.
Thanks,
Nithi
Are you saying to switch to crystal reports 2008?
Hi Eric,
Need more information -
- Abhilash
Follow us on Twitter
Got Enhancement ideas? Try the SAP Idea Place
I'm not sure exactly what the database server is as soon as I find out I will post it here. I'm thinking that it is as400
The drivers I am using are iSeries access
The version is 14.0.4.738 RTM
The only one that we have been able to get to work was ODBC (RDO)
Thank you for your help
That's really not an option...
Thanks
Hi Eric
- Did SAP check your platform details (Supported OS/Info about admin rights etc.)?
- Does it work on other machines or yours is the only one which does not work?
- Do you see any error logged in Event Viewer of the system?
- Have you tried to use a command object to add the second table using "Select * from table"? I faced a similar issue with one of my customers and a workaround of calling table using the command worked as a workaround.
- Additionally you might want to try re-installing Crystal on your system.
Let me know if this helps.
Regards
Nikhil Sabnis
-No they did not but I am on the admin account on my PC.
-I tested it on one other machine (new install) and it does the same thing.
- I do see and error in the event logs: Event ID 1000
- I will have to try that work around and see if I can at least make it through.
- I reinstalled with SAP and it still does the same thing.
Thank you for your help
Hi Eric,
Please refer to this thread for the resolution:
http://scn.sap.com/thread/3196928
Hope this helps!
- Abhilash
Follow us on Twitter
Got Enhancement ideas? Try the SAP Idea Place
Unfortunately the problem has started again. I have redone this solution and it does not fix the problem now. Any suggestions?
We have a couple AS400's at our location also. I tried linking a couple tables after the 'Registry fix' and it didn't work for me either...until I checked the 'iSeries Access for Windows ODBC Driver'. Mine was still set to Read Only. After I changed it to Read/Call it then worked.
Are you using "ODBC access mode, call allowed" or "Limit to Read/Call (Select and call statements allowed)"
Eric,
Mine is set for Read/Call (Select and Call statements allowed)
That didn't work for me. Also my screen is different...
I would to add that I'm having the same exact problem.
Thanks!
Mark- Follow the link that Abhilash posted. It fixed mine
This fixed mine also...with one additional exception. We were having the same problem with an OpenEdge Progress ODBC. The access violation to the ODBC DSN was the culprit. Problem was resolved when rolling back the OpenEdge Progress dll's to a previous version. This was accomplished by modifying a couple additional OpenEdge Progress Registry Keys. Thanks to all the input here, it led me to a solution for our problem!
