cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report always requires sa logon and password

Former Member
0 Kudos

I have created a simple crystal report, with two parameters (date range) and added it to the main menu using the Report and Layout Manager, in 8.8 PL19 HF. The first time I run the report, after each logon, I am prompted for the sa password. How can I avoid this? Not only do I not want to give all of my users the sa password, but I don't want them to have to deal with the hassle of entering it. The report works fine otherwise.

I saw some notes similar to this, but never really saw an actual fix provided.

Thanks for any help

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

1. Are you using the SAP connection? If you have, but problem persist, try the following steps.

2. If you are using ODBC connection, then try OLEDB connection.

3. If you have created the report on your laptop (eg: ABC) with connection to (eg:ABC) and then you import the report to SAP server (eg: named SAP), then open the report in Crystal and reset location to SAP.

former_member184708
Participant
0 Kudos

Hi Shwu

Thanks for your reply but these reports are in the standard "Supplied by SAP" pack and they should work - I should never have to rewrite or do anything for them to if SAP has written the reports correctly and supplied the right layouts.

Rgds

marilyn

Former Member
0 Kudos

Hi,

This is a known bug for pre PL 21 versions. You need to upgrade to the latest PL.

Thanks,

Gordon

former_member184708
Participant
0 Kudos

Hi there

I'm running Version 8.82 PL3 with PL10 of the Crystal Pack and still receiving this error on some of the reports...........is there an updated SQL Crystal reports pack that actually works on ALL reports???

Former Member
0 Kudos

Bug,

update to PL 21 at least to make it work.

Regards,

Daniel