Capabilities Question

I am very new to SQL Reporting Services and trying to determine it's
capabilities. I developed a data-entry application. This application has
extensive business logic that summarizies and formats the data from the
database (including many calculations that I would rather not repeat in
another location).
My question is this... Can I tie a Report created with MS Reporting Services
to one of functions in my business logic. Or can I send the data from my
business logic to a reports?
If either is possible what would be the best way to go about implementing
thisREporting Services can consume a web service, data set or XML file as its
data source.
Also an RS report can be called from a URL directly...
I suspect you have or can create a web service to provide the data, and you
will be good to go.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"matchbx" wrote:
> I am very new to SQL Reporting Services and trying to determine it's
> capabilities. I developed a data-entry application. This application has
> extensive business logic that summarizies and formats the data from the
> database (including many calculations that I would rather not repeat in
> another location).
> My question is this... Can I tie a Report created with MS Reporting Services
> to one of functions in my business logic. Or can I send the data from my
> business logic to a reports?
> If either is possible what would be the best way to go about implementing
> this
>|||Thank you for such a fast response.
Just one more quick question. I'm sorry I did refer to a version. Will
this method work for both 2000 and 2005 or just for 2005.
"Wayne Snyder" wrote:
> REporting Services can consume a web service, data set or XML file as its
> data source.
> Also an RS report can be called from a URL directly...
> I suspect you have or can create a web service to provide the data, and you
> will be good to go.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "matchbx" wrote:
> > I am very new to SQL Reporting Services and trying to determine it's
> > capabilities. I developed a data-entry application. This application has
> > extensive business logic that summarizies and formats the data from the
> > database (including many calculations that I would rather not repeat in
> > another location).
> >
> > My question is this... Can I tie a Report created with MS Reporting Services
> > to one of functions in my business logic. Or can I send the data from my
> > business logic to a reports?
> >
> > If either is possible what would be the best way to go about implementing
> > this
> >