Notifications
Clear all
Topic starter
I have a copy of crystal reports so I decided to try to make some of the edits that our practice is desperately teething for. I am not very familiar with crystal.
I can open a canned .rpt file just fine. I can edit it, save it, works fine.
When I need to add new fields, I have to connect to the database via database expert and add tables. The only account I know is our sa SQL account. When I connect with this, I get everything I need.
The problem is, when I save the report and then run it from CPS, I get a "logon failed" message. I dont know how to find what account the canned reports are using when I open them in crystal.
So I guess what I am asking is - what account should I use to connect to the database when editing the default reports that I want to save and run? Or, how should I be setting crystal reports up? I called GE and they were very unhelpful simply stating they cannot help with custom report editing.
Thank you for any help.
Posted : September 20, 2013 7:11 am
In the Oracle version, you use the "report" account. You can find this username/password in the GE issued documentation. I would be surprised if this wasn't in the CPS info too.
GE should have this information for you – perhaps just give them another call and see if you reach someone more helpful, or you might be able to log into your DB as sa, and view the DB accounts. You may find it there.
Posted : October 8, 2013 3:01 pm
