Reporting on a dynamic recordset

I have my first project with reporting services - 2000 not 2005 and the very
first report that I have to generate is based on a dynamic pivot of an SQL
table.
This means at design time, I don't know how many columns there is going to
be - it will vary quite a lot depending on date ranges and time of year and
so on.
Is there any way to create a report at run time using code? - C# preferably
Thanks for any helpCould you use a matrix control? This allows you to have a variable number of
columns.
HTH,
Magendo_man
"ElijaTheGold" wrote:
> I have my first project with reporting services - 2000 not 2005 and the very
> first report that I have to generate is based on a dynamic pivot of an SQL
> table.
> This means at design time, I don't know how many columns there is going to
> be - it will vary quite a lot depending on date ranges and time of year and
> so on.
> Is there any way to create a report at run time using code? - C# preferably
> Thanks for any help|||But what if I don't know what the columns are going to be until the report is
run?
Can a Matrix do that - I couldn't find anything to say it could
"magendo_man" wrote:
> Could you use a matrix control? This allows you to have a variable number of
> columns.
> HTH,
> Magendo_man
> "ElijaTheGold" wrote:
> > I have my first project with reporting services - 2000 not 2005 and the very
> > first report that I have to generate is based on a dynamic pivot of an SQL
> > table.
> >
> > This means at design time, I don't know how many columns there is going to
> > be - it will vary quite a lot depending on date ranges and time of year and
> > so on.
> >
> > Is there any way to create a report at run time using code? - C# preferably
> >
> > Thanks for any help|||I achieved this in a report I was working on today by introducing a field
called ColumnNo in the stored procedure on which my report dataset is
introduced. This allowed me to have as many columns as required depending on
the reports parameters and the underlying data.
HTH,
Magendo_man
"ElijaTheGold" wrote:
> But what if I don't know what the columns are going to be until the report is
> run?
> Can a Matrix do that - I couldn't find anything to say it could
> "magendo_man" wrote:
> > Could you use a matrix control? This allows you to have a variable number of
> > columns.
> >
> > HTH,
> > Magendo_man
> >
> > "ElijaTheGold" wrote:
> >
> > > I have my first project with reporting services - 2000 not 2005 and the very
> > > first report that I have to generate is based on a dynamic pivot of an SQL
> > > table.
> > >
> > > This means at design time, I don't know how many columns there is going to
> > > be - it will vary quite a lot depending on date ranges and time of year and
> > > so on.
> > >
> > > Is there any way to create a report at run time using code? - C# preferably
> > >
> > > Thanks for any help|||Thanks - I'll have a look into it and see how it goes.
I may be back ;)
"magendo_man" wrote:
> I achieved this in a report I was working on today by introducing a field
> called ColumnNo in the stored procedure on which my report dataset is
> introduced. This allowed me to have as many columns as required depending on
> the reports parameters and the underlying data.
> HTH,
> Magendo_man
> "ElijaTheGold" wrote:
> > But what if I don't know what the columns are going to be until the report is
> > run?
> > Can a Matrix do that - I couldn't find anything to say it could
> >
> > "magendo_man" wrote:
> >
> > > Could you use a matrix control? This allows you to have a variable number of
> > > columns.
> > >
> > > HTH,
> > > Magendo_man
> > >
> > > "ElijaTheGold" wrote:
> > >
> > > > I have my first project with reporting services - 2000 not 2005 and the very
> > > > first report that I have to generate is based on a dynamic pivot of an SQL
> > > > table.
> > > >
> > > > This means at design time, I don't know how many columns there is going to
> > > > be - it will vary quite a lot depending on date ranges and time of year and
> > > > so on.
> > > >
> > > > Is there any way to create a report at run time using code? - C# preferably
> > > >
> > > > Thanks for any help