Bundling Reports & Dynamic DataSource.

I am currently evaluating reporting services. I haven't been able to find any
information of the following subjects.
Can Multiple Reports be dynamically combined into one at run time? I need to
allow users to select which reports to run (all which can be run individually
else where) and if they want a continuous page numbering or individual page
number on a report basis.
Also, the data sources for the reports are generated in .NET code. There are
allot of calculations which are too difficult to do in SQL. It is possible,
but simply too difficult. Can a report be created in the designer with no
data source? Or can I make a data source placeholder which only contains the
structure I want to implement? Then at run time stuff the data source in.
How can a chart be feed into a report at run time. I wish to use a third
part charting component.
We need to run these reports from code, with out the use of the Reporting
Management tool so that the reports seamlessly integrate.
Thanks!Much of this you can get with RS 2005 reporting controls that come with VS
2005. You can run in local mode (has some limitations, for instance you
cannot subscribe to reports - which makes sense, there is no server to
handle that). In local mode you give the control the report and the dataset.
There is a winform and webform control. Starting off there is the bundled
charting component but RS 2005 does have extensibility. I would think Dundas
will support it but I don't know for sure. These controls will work with the
server if it is there. They use webservices to do this and hence are secure
(versus using URL integration).
Dynamically combining reports. You would have to do this but it should be
possible. RS has the concept of subreports. You could have a report you
create on the fly that combines these subreports into one report but it
would take some work on your part.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"skynet" <skynet@.discussions.microsoft.com> wrote in message
news:409B4C48-46FB-477B-BAF0-B06B5A670364@.microsoft.com...
>I am currently evaluating reporting services. I haven't been able to find
>any
> information of the following subjects.
> Can Multiple Reports be dynamically combined into one at run time? I need
> to
> allow users to select which reports to run (all which can be run
> individually
> else where) and if they want a continuous page numbering or individual
> page
> number on a report basis.
> Also, the data sources for the reports are generated in .NET code. There
> are
> allot of calculations which are too difficult to do in SQL. It is
> possible,
> but simply too difficult. Can a report be created in the designer with no
> data source? Or can I make a data source placeholder which only contains
> the
> structure I want to implement? Then at run time stuff the data source in.
> How can a chart be feed into a report at run time. I wish to use a third
> part charting component.
> We need to run these reports from code, with out the use of the Reporting
> Management tool so that the reports seamlessly integrate.
> Thanks!
>