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]

And this is what I have in the report  when I click on Database Fields and  Database Expert, 

Then, inside  MFGDEV and all in Production is the same , I have this kind of Data Structure :

The Tables I need are in that list, but still I need to  re-added ?,

Then, should I replace the whole  folder  MFGDEV, and then do the same with all the others ?