Dynamic Query

Hi there
I am trying to create a report with a proc that has dynamic column headers.
eg TonsHarvested1998, TonsHarvested2000, etc.
The problem I am experiencing is that these columns are not displayed in the
fields editor box and I have no idea as to how I can get them displayed in
my textboxes.
Can anyone give me any ideas as to how I can sort this out.
Thanks
KershniFirst run the static version of the query which will populate the fields
list and then replace the query with the dynamic version. You can also
populate the fields list manually (Dataset dialog box -> Fields tab.)
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kershni Chetty" <support@.sqrsoftware.com> wrote in message
news:%23xwvy6GeEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Hi there
> I am trying to create a report with a proc that has dynamic column
headers.
> eg TonsHarvested1998, TonsHarvested2000, etc.
> The problem I am experiencing is that these columns are not displayed in
the
> fields editor box and I have no idea as to how I can get them displayed in
> my textboxes.
> Can anyone give me any ideas as to how I can sort this out.
> Thanks
> Kershni
>sql