Crystal Report running slow

[former_member1054020]

Hello

We have several crystal reports which are connected to a single SQL database However they are performing really badly. Super Slow. when looking at the sql for the report it shows 10 different queries. the first is the master ones and the rest show as external joins.

there is about 15 tables of data pulled in...so it has merged 6 into a single query

anyone know why it is doing this and how i can get the report to all merge into a single query to save crystal going the data processing itself locally?

Thanks in advance.

[former_member34]

Thank you for visiting SAP Community to get answers to your questions. Since you're new in asking questions here, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question now by selecting Actions, then Edit.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards

Jennifer

SAP Community moderator

[vitaly_izmaylov]

Can you attach a screenshot of the reports tables joins?

What is driver name used to connect to SQL Server?

[former_member1054020]

Hello vitaly.izmaylov ,

i have solved the issue. it was due to having sql commands in the report. i moved them to views in sql server and that has solved the issue.

Thanks