Dynamic Colums base on Date Range

[blockertracker]

I am starting to create a Balance Sheet Report. I need to have a dynamic columns with its row data base on date ranges. Let say StartDate='10-03-2012' and EndDate='03-25-2013', It should create a columns like below with its row data. (Notice that all previous columns move its month date to its end date and the last month it stick to what the user has given) :

The result should be something like this:

[b]Account Name             Oct 31, 2012   Nov 30, 2012   Dec 31, 2012   Jan 31, 2013   Feb 28, 2013   March 25, 2013[/b] 
Cash on Hand               56, 678.89     45, 678.90      23,456.78      12,304,75     12, 456.78       32, 345.12
Cash on Bank              34, 673.11     21, 638.23      59,421.31      13,334,89     10, 089.05       90, 213.14
....and....so on.....

Ive already set-up two parameter for date(StartDate and Enddate). But I do not know how to generate the dynamic columns base on the parameter dates. I already have started this so far and here is my screen shoot.

http://i.imgur.com/nIi7zV5.png?1[/IMG]]
I believe I am still a newbie, so please give a clear solution.

Thank you for helping!

 

[blockertracker]

anybody take time to suggest if this is possible? I do not know how to start but maybe creating a loop in the formula fields?

 

[PeterDimitrov]

Use a cross-tab.

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports and SSRS.

 

[blockertracker]

thank you PeterDimitrov!

But, can I used formulas & parameters to generate the columns?