I have a report in CR XI, which generates approximately 31,000 records. If I do not use parameters, the report runs within several seconds.
If I use parameters to narrow down the number of records I return, the report slows down, and takes approximately 15 minutes to generate.
Any idea why this is happening? I do not understand why the report slows down when I try to narrow down the number of results I want to return?
I am using CRXI, and am connected to a SQL database through an ODBC connection. I am using 3 parameters, and using them dynamically-
So, I select a 'department,' which then determines the 'unit,' I can selected, and based on that selection will determine which 'type' I can select.
Thanks. Kelly
If I use parameters to narrow down the number of records I return, the report slows down, and takes approximately 15 minutes to generate.
Any idea why this is happening? I do not understand why the report slows down when I try to narrow down the number of results I want to return?
I am using CRXI, and am connected to a SQL database through an ODBC connection. I am using 3 parameters, and using them dynamically-
So, I select a 'department,' which then determines the 'unit,' I can selected, and based on that selection will determine which 'type' I can select.
Thanks. Kelly