Report referencing dynamic table

Hi all
Just wondering how one would approach buidling an RS report based on a
dynamic table ie. Each time the report is run, the table may have a
different number of columns.
Here is what I'm trying to acheive:
The user enters a date range for the report. The report then calls a SQL
stored proc which generates a table containing columns for each day in the
date range. That table is then used as a datasource in the report.
Any assistance guidance will be appreciated
Thanks in advance
GeorgeOn Jul 5, 6:23 pm, "_george" <none@.nojne@.none> wrote:
> Hi all
> Just wondering how one would approach buidling an RS report based on a
> dynamic table ie. Each time the report is run, the table may have a
> different number of columns.
> Here is what I'm trying to acheive:
> The user enters a date range for the report. The report then calls a SQL
> stored proc which generates a table containing columns for each day in the
> date range. That table is then used as a datasource in the report.
> Any assistance guidance will be appreciated
> Thanks in advance
> George
The best way to handle this is to use a matrix report. The days would
appear as columns in the matrix report; of course, it supports dynamic
pivoted columns. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant