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 ?

[JWiseman]

Hi ghevia99, the Links tab will show up if there's more than 1 database object utilized on a report. If you are using a single Command object then there shouldn't be a Links tab.

Questions:

1. What happens when you run the report directly in the Launchpad? (i.e. Not a schedule.)
2. What happens with a brand new report based on the same Command object SQL and parameters?