Hello,
has anyone experienced performance issues when conditionally rendering report pages (Excel 2007 output) based on user selected values in a list? We recently added this conditional rendering function to a prompt page so that users could select one or more of the available report pages to render rather than having all the pages returned. Now, when a user selects the report page with the largest output in conjunction with a limit on Open Quantity > 0, the query times out. However, using the same criteria in the original report without page rendering, the query returns all pages including the page with the largest result set. The only diffence between the queries is the conditional page rendering, which was designed to increase performance by reducing the query output but seems to be having the opposite effect. Any ideas why this is happening?