0Hi Friends,
You can improve you report performance using below tip-
1. Let say if you have 4 list object to show data on report. You normally create 4 seprate queries in cognos query explorer. now when you run your report 4 seprate queries will go and hit database.
If you create one master query for all required columns and derive new queries from the master query then at run time only one query will go to database so it will reduce to the traffic on network and will enhance database performance as it has to bring all data in one time.
