could you please show the table-scheme you are using?
The fact table, where you want to get the data from and the calendar table and the relations between those tables.
Actually, dependent from your application design you don't need to make any further selections or scriptings.
Example: sum(revenue) may always show the summation of the time-range you selected, if the date-fields are linked to the table where the revenue values are.
I HAVE A TABLE REPORT WHICH HAVE SEVERAL COLUMN. I HAVE TO GET DATA OF THIS REPORT BASED ON THE SELECTED DATED. THIS SELECTED DATE WILL BE THE CREATED DATE COLUMN OF THE REPORT TABLE. sO WE HAVE WHERE CONDITION IN WHICH WE WILL GIVE THE DATE RANGE.
Is this clear or i need to put some more information.