Hello...
I created two SQL Commands on Crystal Reports 2008. One for the CLIENTS table and one for the YEARS table. The YEARS table only stores the current year. I mean, I have thousands on rows on the CLIENTS table and only one row on the YEARS table.
I wanted to create a filter on my report only to retrieve the CLIENTS that where created on a particular year (the year stored in the YEARS table, wich will be changing dinamically).
The CLIENT table has a CREATION_YEAR column and it has an index.
I created the following filter in my report, using the Formula Editor:
{CLIENTS.CREATION_YEAR} = {YEARS.year}
The report takes too much time to generate, altough as I said, the CLIENTS table has an index on CREATION_YEAR.
My question is if Crystal not uses tables indexes when combining fields from differents Commands on a filter.
Thanks!
IP Logged
