Personalization, Customization and Productivity Tools

[lthiele]

I'm trying to write a report from 4.4 where I have the PO Receipt History Detail table is linked to the Header table with an inner join using the PO # and the Receipt number as the linking fields.  There is other information I need from the CI_Item file so I have it linked with the Item Number and the Item Type fields and using a left outer join.

It takes longer than I think it should.  15 minutes on the server itself and if it is run from a workstation, it seems like it never finishes.  I'm a little impatient so maybe I don't wait long enough.  Running the report for a certain period, it only returns 36 records in all that time.  And that is the correct number.  This same report in 4.3 took only a couple of minutes, if that long, to run.

However, in looking through all the posts I see that I am not the only one having problems and the common theme seems to be the CI_Item table.  Is there something with the table itself that could be causing it?  Or is it just that Crystal XI doesn't like using three tables in this manner?

[connex]

I would guess that it is the LOJ on CI_Item.  For fun try changing it to a equal join to see if it performs more as expected.  If that's the issue then see if you can replace CI_Item fields with a sub report and omitting that table from the main report.

[lthiele]

I did try using the inner join and it doesn't make any difference.  I'll try using the subreport and see if that helps.

Thanks.

[connex]

Also, note that on your subreport there only needs to be a link on ItemCode between Receipt History Detail and CI_Item.

[connex]

How many items in their CI_Item?