Age Analysis Report Generation in BIC

My question is i cant find a way to generate an age analysis report in BIC. I tried to add the table for age analysis to ODBC sql server. and tried some ms sql scripts to show the past 30, 60 and 90 days data from the current date but it couldn't work well. I want the report more likely same as evolution age analysis report. So can you give me solution for how to customize age analysis report step by step from evolution report manager as well from Excel Genie. Waiting for the solution as soon as possible. Thanks in advance.