sql server reporting services: Report referencing dynamic table -- sql server reporting services

Report referencing dynamic table

_george
7/6/2007 12:00:00 AM

sql server reporting services: 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

Re: Report referencing dynamic table

EMartinez
7/6/2007 12:44:42 AM

[quoted text, click to view]

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