Dynamic Columns

Hi there
I have a problem with displaying the columns of my report. I have a stored
proc that creates my columns dynamically based on the data, eg
TonsHarvested1998, TonsHarvested2000, etc. These are sample column headers
returned by my proc.
I have no idea as to how I can display this data as the columns dont appear
on the fields designer so I cant figure out how I can display them in my
table and put them into my textboxes.
Can anyone give me an idea as to how I can go about doing this.
ThanksI worked on a project a while back that was like this... The result set was
ONLY returned when the proper parameters were sent, and the app didn't send
any parameters so none of the intelligent stuff worked... Perhaps RS is
using the returned result set (using reflection) to show the column names,
etc... What we did was provide default values for the parameters that caused
the type of result set we wanted to use at design time... In the SP , if
@.param=1 select yaada,...
What I suspect will NOT work is variable number or names for parameters,
because the mappings to fields etc is done at design time.. ( although I
could easily be mistaken)...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kershni Chetty" <support@.sqrsoftware.com> wrote in message
news:ettdSnHeEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Hi there
> I have a problem with displaying the columns of my report. I have a stored
> proc that creates my columns dynamically based on the data, eg
> TonsHarvested1998, TonsHarvested2000, etc. These are sample column headers
> returned by my proc.
> I have no idea as to how I can display this data as the columns dont
appear
> on the fields designer so I cant figure out how I can display them in my
> table and put them into my textboxes.
> Can anyone give me an idea as to how I can go about doing this.
> Thanks
>