Help needed to design Accounts report block.

[sara_23apr]

Dear Friends

I am using asp.net and SSRS

what is the right approach to build the following reporting structure ?

1) should i asp.net page with grid view and give individual reports
2) or use the SSRS completely

how can i effieciantly code this without duplicating hte queries. I am totally lost!!


duration e.g. From Date - To date ( 1-1-08 to 1-1-09)


1. one consolidated record per account for the duration (there are abt 25 accounts)
format --- opening balance , debit, credit , Closing balance

2. one consolidated record per month of the duration (for each account)
format --- opening balance , debit, credit , Closing balance

3. one consolidated record per day (for each account)
format --- opening balance , debit, credit , Closing balance

4. complete drill down, which will open individual record
format --- complete data of the individual record.


Kindly guide me
Sara