Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reports too slow

Status
Not open for further replies.

neil2grow

IS-IT--Management
Nov 19, 2003
30
US
Hello everybody,
Wish you all a very happy new year.I have designed some reports in cognos impromptu.I have a couple of reports which wouldnt open up or takes a long time(dont know how long) for a particular input value ,when i try to access data for a particular period.The dataset corressponding to the period is also not big ,because similar sized datasets for other periods open within 5 seconds.And also the access tab of the Report Query has the "Retrieve only the required rows" checkbox unchecked and disabled for all my reports for which i checked the box when i developed them.Any suggestion to speed up my reports
Thanks
Neil
 
Hi Neil

When a report takes a while to open check the SQL. Under Query editor last tab.

What format are you using for your date (??) prompt?



Dreffed
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top