What are the steps to be taken care to improve the Report performance? - BO Designer

What are the steps to be taken care to improve the Report performance?

The report performance can be improved by the following steps;

At Designer Level

- Remove Unnecessary joins.

- Utilize condition as necessary as possible, at the database level.

- Supply the SQL query in the Query Panel as per the requirement.

At Reporter Level

- Eliminate the filters as many as possible.

- Reduce the user variables.