I have a similar issue.I started using a report was already

[ghevia99]

I started absed on one Crystal report was already created, and I reomved all the associated tables, and created the new ones, and I used I COMMAND, just to have a simple query.

Then, If I run the Report connected to DEV or  PROD, it works and very fast, around  1.6 secs.

I have created three Input Paremeters:

1. Plant #  ;  2 Initial_Date   ; 3. Final_Date.

Running the report locally on my PC, I used   Plant # = 02 ; Initial_Date = 04/01/2023 ; Final_Date = 04/30/2023  ( means 1 month ), where I know there are 25 records involved, and it takes  1.6 secs, but If I run from SAP BI, making the Schedule, and running right now, it takes more 40 minutes.  What I am missing here ?

I compared this report, and I noticed that as others reports, I have something in the TAB links in Database Expert, but in this one, I don't even have the TAB Links,  could be that the issue ?

If so, how can I fix it ?

[ghevia99]

Ok. I believe, It makes sense.

So, I am referencing 5 tables in my query, then I need to add each one of these table following the procedure :

1. In Crystal Reports, open the report.
2. Under the menu 'Database', select: 'Set Datasource Location'   
3. In the 'Current Data Source' section, click the data source to be changed.   
4. In the 'Replace with' section, click the data source you want the report to use.
5. Click 'Update'. 
6. Close the 'Set Datasource Location' window.
7. Save the report.