Hi All, I have report with the following query... SELECT a.invoice_amount ,a.exchange_rate ,a.tax ,a.gl_date ,(a.invoice_amount+a.tax) total_inv_amt ,a.exchange_rate*a.invoice_amount acct_inv_amt ,a.exchange_rate*a.tax acct_tax ,((a.exchange_rate*a.invoice_amount)+(a.exchange_rate*a.tax)) total_acct_inv_amt FROM (SELECT aia.invoice_amount ,aia.exchange_rate ,(sub query) tax ,(sub query) gl_date FROM ap_invoices_all aia WHERE 1=1 AND aia.org_id=nvlP_ORG_ID,aia.org_id) ) a WHERE 1=1 AND a.gl_date between _FROM_GL_DATE and _TO_GL_DATE ; this is sample query. So because of subquery and calculations report taking longtime to run. So if I use formula columns instead of subqueries and calculation, will it increase performance? Please give suggestions to increase performance.