cancel
Showing results for 
Search instead for 
Did you mean: 

Couldn' preview crystal reports in SAP B1 v10

former_member5155
Discoverer
0 Kudos

Hi,

i have recently upgrade SAP b1 server from v9.3 to v10.00.140 FP 2011

i did uninstall v9.3 from all users computer,

and after installed SAP B1 client to user's computer, 7 out of 10 users complaint they couldn't preview all crystal reports (layouts and reports), when generate reports or layouts, screen show [database login] window to ask for credential.

server field is correct, but database field was empty, login-id was tied with SLD auto-created SQL user-id, start with B1_numbers and end with "RW". and the password field is empty.

i've tried change the report's datasource from native client to ODBC. then it works. but it is such a pain to edit remaining reports, therefore i'm here to seek help, anyone have better solution?

Accepted Solutions (0)

Answers (1)

Answers (1)

msundararaja_perumal
Active Contributor
0 Kudos

austin-powder,

If you have a backup of the database export the crystal reports as package and reimport, it should work.

Thanks.

former_member5155
Discoverer
0 Kudos

Hi Mr. Sundararaja,

Thank you for your reply,

may i know it is export from 9.3 or v10?

do you mean [Implementation Tasks] at Implementation Center?

or DTW?

or ... ?

msundararaja_perumal
Active Contributor
0 Kudos

austin-powder,

From 9.3/10 version, Open the Report Layout Manager screen, expand and select the respective layout that need to export and choose next, name the package and save. Then import the package all the layouts will be imported.

0 Kudos

Hello.

Havbe you fix this issue?