Display Columns dynamically in the report based on search criteria

Hi,

I have search criteria:
Start Date : Month and Year
End Date : Month and Year

If Start Date is : 1st Jan 2011 and End Date is 31st May 2011, I should get 5 columns i.e Jan to May in my report.
How can I achieve this. Any help on this will be appreciated, as this is quiet critical.

Find more posts tagged with

Comments

mwilliams

Hi ravips4u,

This looks like the perfect place to use a dataCube and crosstab using your date as the column dimension. It dynamically sizes itself depending on your data. Let me know if you have questions on where to get started with this.