Apex Code Development You need to sign in to do that
Don't have an account?
Westwind Failure to connect via Crystal Reports
We're evaluating Crystal Reports and CrystalReports.com for generating reports from SF objects. I have properly installed CrystalReports.com within SF. I've downloaded and installed (separately) both CR XI (with SF Driver 3.0) and 2008 (without driver per CR's tech support) for developing reports.
When I attempt to Create New Connection/Salesforce.com, a pop-up window appears pointed to www.salesforce.com and prompting for my SF userID and password. I have several valid SF accounts. No matter which account I try, CR returns a "Login error: invalid UserID or Password."
After two hours waiting to talk to a CR tech support person, they had virtually nothing useful to say ... basically they told me to get an SAP/BO tech support account which requires submitting an application. Their forums were impossible to navigate. CR looks like a great solution, but I'm underwhelmed with their tech support.
Is anyone using CR XI or 2008 to access SF objects? If so, any suggestions/advice re: connecting to SF?
Thanks,
Mark
Good news, there is a fix pack that can be installed after upgrading to Crystal 2008 SP2. To see the thread at sap.com visit: https://forums.sdn.sap.com/thread.jspa?threadID=1431217&tstart=0
To download the fix pack visit: https://smpdl.sap-ag.de/~sapidp/012002523100015097962009E/cr2008_fp22.exe
All Answers
I have tried the suggested fix by appending my password with the security token but it replaces one error with another.
Logon failed.
Details: Unexpecteed error; nested exception is:
org.xml.sax.saxexception: invalid element in com.sforce.soap.partner.loginresult - metadataServerUrl
Am I using the wrong URL of www.salesforce.com?
Crystal Reports 2008 CR Developer version 12.2.0.290 Product Type: Full
Thanks
I can confirm that I too am having the same error with Crystal Reports 2008 CR Developer version 12.2.0.290 connecting to Salesforce.com.
This is the built in connector.
The last time this worked was 9/9/2009. Only variables that I *know* have changed is the recent service pack 2 was applied to Crystal.
Has anyone solved this or gotten the current version of Crystal 2008 with all of the latest service packs to connect to Salesforce.com?
Have you tried posting a note on the SAP Crystal Reports forum? I did some searching there but didn't find any obvious solution for what you're describing.
http://forumsa.sdn.sap.com/forum.jspa?forumID=300
All,
Here is what I found. The issue relates to service pack 2 for Crystal Reports 2008. By downgrading (i.e. uninstalling/ reinstalling) to Crystal 2008 with service pack 1 everything is working fine.
Forums at SAP indicate this is a known issue and that a patch is being worked on. Nothing more at this point.
Thanks,
Josh
Just an FYI - I installed SP2 today and received the same errors. I scoured the Crystal forums for two hours to no avail. This problem still exists with no known patch as far as I can tell...
Does anyone know of a fix other than downgrading?
I just upgraded to SP2, and I'm now receiving the same error, as well. Anyone find a solution to this? Looks like it's been a few months.
I'd prefer not to downgrade back to SP1 because I was under the impression that SP2 was required for connecting to objects with multiple parents (per this page: http://forumsa.sdn.sap.com/thread.jspa?messageID=8354805#8354805).
Good news, there is a fix pack that can be installed after upgrading to Crystal 2008 SP2. To see the thread at sap.com visit: https://forums.sdn.sap.com/thread.jspa?threadID=1431217&tstart=0
To download the fix pack visit: https://smpdl.sap-ag.de/~sapidp/012002523100015097962009E/cr2008_fp22.exe