Hi!
I am evaluating how far i can go in implementing repoting features of SRS in
my program.
I want to be able to write a Windows form (in C#) that has a grid/list
containing all the reports that I have made. The list may have been
previously enterd into the database along with other information needed to
run the particular report.
I want to be able to select in the grid/list(e.g. using a check box) which
reports to run, and what format to render each individual report, as well as
other parameters.
Is the Report Manager that extensible? Is it possible to create this sort of
replacement for Report Manager from C#?
I am using VS2005 and SRS 2005.
Thanks in advance!It is absolutely possible... I have written a report for a customer which
searches the reporting services met data database and returns a list of
reports which match the search criteria the customer wants.. It creates a
report which displays the report name, directory and description... Each
report name is a hot link to run the report... This was done in a report!~
Using a programming language you can do anything you wish... There is a
ReportViewer control ( Search for ReportViewer in Books on line.) that you
can use..
There are sample programs in the SQL directory /90 subdirectory which will
help get you started...
Reporting Services is also just a DotNet Web service, with an entire API
which can you call from your program as well.. It is the same API that MS
uses in the Report Manager..
--
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.
"PacMan" wrote:
> Hi!
> I am evaluating how far i can go in implementing repoting features of SRS in
> my program.
> I want to be able to write a Windows form (in C#) that has a grid/list
> containing all the reports that I have made. The list may have been
> previously enterd into the database along with other information needed to
> run the particular report.
> I want to be able to select in the grid/list(e.g. using a check box) which
> reports to run, and what format to render each individual report, as well as
> other parameters.
> Is the Report Manager that extensible? Is it possible to create this sort of
> replacement for Report Manager from C#?
> I am using VS2005 and SRS 2005.
> Thanks in advance!
Showing posts with label srs. Show all posts
Showing posts with label srs. Show all posts
Monday, March 26, 2012
Monday, February 20, 2012
rendering reports without a server
Hi,
I read a book (Pro SQL Server Reporting Services) that mentioned that SRS
2005 will give users the capability to render reports without a server.
Well, I now have SRS 2005 but I still cannot see how this is done. How does
one render reports without a server? Is it because of the Report Viewer
control? If so, in what way is it possible to render reports w/o the server?
Here is the text from the book (my apologies to the publisher)
"For many software projects, one of the main limitations of SRS 2000 was
that it required you to have a server running SRS. This made it difficult or
impossible in some environments, and in certain scenarios, to utilize SRS as
the reporting mechanismâ'for example, if you had a user with a laptop who
needed to run reports while disconnected from the network where your SRS
server was located. As a result, users often fell back on technologies such
as Business Objects Crystal Reports or Data Dynamics Active Reports. With SRS
2005, this problem has been solved. The same new rendering controls that make
it easier to render your reports with SRS 2005 make it possible to render
them without a server at all.
These new controls can render reports without the need to have access to an
SRS server. With SRS 2005, you now have a single technology reporting system
that can provide a viable solution across a wide variety of applications and
circumstances. No longer will you have to use one technology for applications
without access to a server and an entirely different and incompatible
technology for those applications with access to a server.
This implementation is well thought out and well implemented in SRS 2005.
The controls use the same RDL as the SRS server and offer the option to
render reports locally without the need for an SRS server. Local report
rendering supports background processing and offline snapshots, thus
providing a very powerful solution for a variety of needs. With local
rendering you can distribute report generation to local systems, provide
reporting capabilities to users while disconnected from the network, and
more. You can also use the same control to view reports rendered by an SRS
server. This gives you a great option to use the same user interface
regardless of whether or not you have an SRS server.
The beauty of this is that the exact same report can be deployed two
different ways depending on your need. You can deploy directly to a desktop
system where connectivity to an SRS server is not desirable or possible, and
to an SRS server when scalability and enterprise features such as report
history, running reports on a schedule, and push delivery are important. This
also offers some great options if you need to generate reports on
applications running on a laptop.PacMan wrote:
> Well, I now have SRS 2005 but I still cannot see how this is done.
> How does one render reports without a server? Is it because of the
> Report Viewer control? If so, in what way is it possible to render
> reports w/o the server?
Add a reference to Microsoft.ReportViewer.WinForms.
Now you'll find in the Microsoft.Reporting.WinForms namespace is a class
called LocalReport. This is what you need to use to do the work.
Generating the report is absolute simplicity. Create your .rdl file using
the SQL Server 2005 Business Intelligence Development Studio (or
alternatively, create an .rdlc file by adding a Report to a standard VS2005
project -- but you'll get no preview window this way, so the BIDS approach
is superior IMO). Then create a LocalReport object and provide it with the
.rdl file (using the LoadReportDefinition method).
Now you need to provide data for each of the DataSources in the .rdl file.
Do this by adding ReportDataSource objects to the LocalReport's DataSources
collection. Each ReportDataSource should be initialised with two parameters:
the name of the DataSource (as defined within your .rdl definition) and a
DataTable object (that contains the data to be included within the report).
Finally, call the Render method as follows:
document = report.Render("PDF", Nothing, Nothing, Nothing, Nothing,
Nothing, Nothing)
This will return a byte-array inside which will be the rendered report.
That's it.
Note however that charts in PDF documents are rendered UNCOMPRESSED. This
results in absolutely huge PDF files (a report I made that contained a
couple of charts that rendered at 70KB on the server was generated at a
little over 7MB by the ReportViewer).
HTH,
--
(O)enone|||One additional thing to note. If you installed sut the Business Intelligence
Development Studio I don't think that the controls come with it. The
controls come with Visual Studio.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oenone" <oenone@.nowhere.com> wrote in message
news:uogWt%23sNGHA.208@.tk2msftngp13.phx.gbl...
> PacMan wrote:
>> Well, I now have SRS 2005 but I still cannot see how this is done.
>> How does one render reports without a server? Is it because of the
>> Report Viewer control? If so, in what way is it possible to render
>> reports w/o the server?
> Add a reference to Microsoft.ReportViewer.WinForms.
> Now you'll find in the Microsoft.Reporting.WinForms namespace is a class
> called LocalReport. This is what you need to use to do the work.
> Generating the report is absolute simplicity. Create your .rdl file using
> the SQL Server 2005 Business Intelligence Development Studio (or
> alternatively, create an .rdlc file by adding a Report to a standard
> VS2005 project -- but you'll get no preview window this way, so the BIDS
> approach is superior IMO). Then create a LocalReport object and provide it
> with the .rdl file (using the LoadReportDefinition method).
> Now you need to provide data for each of the DataSources in the .rdl file.
> Do this by adding ReportDataSource objects to the LocalReport's
> DataSources collection. Each ReportDataSource should be initialised with
> two parameters: the name of the DataSource (as defined within your .rdl
> definition) and a DataTable object (that contains the data to be included
> within the report).
> Finally, call the Render method as follows:
> document = report.Render("PDF", Nothing, Nothing, Nothing, Nothing,
> Nothing, Nothing)
> This will return a byte-array inside which will be the rendered report.
> That's it.
> Note however that charts in PDF documents are rendered UNCOMPRESSED. This
> results in absolutely huge PDF files (a report I made that contained a
> couple of charts that rendered at 70KB on the server was generated at a
> little over 7MB by the ReportViewer).
> HTH,
> --
> (O)enone
>
I read a book (Pro SQL Server Reporting Services) that mentioned that SRS
2005 will give users the capability to render reports without a server.
Well, I now have SRS 2005 but I still cannot see how this is done. How does
one render reports without a server? Is it because of the Report Viewer
control? If so, in what way is it possible to render reports w/o the server?
Here is the text from the book (my apologies to the publisher)
"For many software projects, one of the main limitations of SRS 2000 was
that it required you to have a server running SRS. This made it difficult or
impossible in some environments, and in certain scenarios, to utilize SRS as
the reporting mechanismâ'for example, if you had a user with a laptop who
needed to run reports while disconnected from the network where your SRS
server was located. As a result, users often fell back on technologies such
as Business Objects Crystal Reports or Data Dynamics Active Reports. With SRS
2005, this problem has been solved. The same new rendering controls that make
it easier to render your reports with SRS 2005 make it possible to render
them without a server at all.
These new controls can render reports without the need to have access to an
SRS server. With SRS 2005, you now have a single technology reporting system
that can provide a viable solution across a wide variety of applications and
circumstances. No longer will you have to use one technology for applications
without access to a server and an entirely different and incompatible
technology for those applications with access to a server.
This implementation is well thought out and well implemented in SRS 2005.
The controls use the same RDL as the SRS server and offer the option to
render reports locally without the need for an SRS server. Local report
rendering supports background processing and offline snapshots, thus
providing a very powerful solution for a variety of needs. With local
rendering you can distribute report generation to local systems, provide
reporting capabilities to users while disconnected from the network, and
more. You can also use the same control to view reports rendered by an SRS
server. This gives you a great option to use the same user interface
regardless of whether or not you have an SRS server.
The beauty of this is that the exact same report can be deployed two
different ways depending on your need. You can deploy directly to a desktop
system where connectivity to an SRS server is not desirable or possible, and
to an SRS server when scalability and enterprise features such as report
history, running reports on a schedule, and push delivery are important. This
also offers some great options if you need to generate reports on
applications running on a laptop.PacMan wrote:
> Well, I now have SRS 2005 but I still cannot see how this is done.
> How does one render reports without a server? Is it because of the
> Report Viewer control? If so, in what way is it possible to render
> reports w/o the server?
Add a reference to Microsoft.ReportViewer.WinForms.
Now you'll find in the Microsoft.Reporting.WinForms namespace is a class
called LocalReport. This is what you need to use to do the work.
Generating the report is absolute simplicity. Create your .rdl file using
the SQL Server 2005 Business Intelligence Development Studio (or
alternatively, create an .rdlc file by adding a Report to a standard VS2005
project -- but you'll get no preview window this way, so the BIDS approach
is superior IMO). Then create a LocalReport object and provide it with the
.rdl file (using the LoadReportDefinition method).
Now you need to provide data for each of the DataSources in the .rdl file.
Do this by adding ReportDataSource objects to the LocalReport's DataSources
collection. Each ReportDataSource should be initialised with two parameters:
the name of the DataSource (as defined within your .rdl definition) and a
DataTable object (that contains the data to be included within the report).
Finally, call the Render method as follows:
document = report.Render("PDF", Nothing, Nothing, Nothing, Nothing,
Nothing, Nothing)
This will return a byte-array inside which will be the rendered report.
That's it.
Note however that charts in PDF documents are rendered UNCOMPRESSED. This
results in absolutely huge PDF files (a report I made that contained a
couple of charts that rendered at 70KB on the server was generated at a
little over 7MB by the ReportViewer).
HTH,
--
(O)enone|||One additional thing to note. If you installed sut the Business Intelligence
Development Studio I don't think that the controls come with it. The
controls come with Visual Studio.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oenone" <oenone@.nowhere.com> wrote in message
news:uogWt%23sNGHA.208@.tk2msftngp13.phx.gbl...
> PacMan wrote:
>> Well, I now have SRS 2005 but I still cannot see how this is done.
>> How does one render reports without a server? Is it because of the
>> Report Viewer control? If so, in what way is it possible to render
>> reports w/o the server?
> Add a reference to Microsoft.ReportViewer.WinForms.
> Now you'll find in the Microsoft.Reporting.WinForms namespace is a class
> called LocalReport. This is what you need to use to do the work.
> Generating the report is absolute simplicity. Create your .rdl file using
> the SQL Server 2005 Business Intelligence Development Studio (or
> alternatively, create an .rdlc file by adding a Report to a standard
> VS2005 project -- but you'll get no preview window this way, so the BIDS
> approach is superior IMO). Then create a LocalReport object and provide it
> with the .rdl file (using the LoadReportDefinition method).
> Now you need to provide data for each of the DataSources in the .rdl file.
> Do this by adding ReportDataSource objects to the LocalReport's
> DataSources collection. Each ReportDataSource should be initialised with
> two parameters: the name of the DataSource (as defined within your .rdl
> definition) and a DataTable object (that contains the data to be included
> within the report).
> Finally, call the Render method as follows:
> document = report.Render("PDF", Nothing, Nothing, Nothing, Nothing,
> Nothing, Nothing)
> This will return a byte-array inside which will be the rendered report.
> That's it.
> Note however that charts in PDF documents are rendered UNCOMPRESSED. This
> results in absolutely huge PDF files (a report I made that contained a
> couple of charts that rendered at 70KB on the server was generated at a
> little over 7MB by the ReportViewer).
> HTH,
> --
> (O)enone
>
Rendering Report directly in the MS Excel
Hi,
We have multiple reports created in the SRS 2005. What is the best approach
to directly exporting (rendering) the created reports in Excel without using
any report viewer control or report manager for exporting on click of the
button.
Thanx in advance.You can call the report using the url access, as:
http://<server>/ReportServer?/<report
path>&rs:Command=Render&rs:Format=EXCEL
Jeronimo Vogt
"Parimal" <Parimal@.discussions.microsoft.com> wrote in message
news:3761A0CF-EFA4-4266-8E15-4832D6AF3814@.microsoft.com...
> Hi,
> We have multiple reports created in the SRS 2005. What is the best
approach
> to directly exporting (rendering) the created reports in Excel without
using
> any report viewer control or report manager for exporting on click of the
> button.
> Thanx in advance.|||The new MS Reports tool (an addition to Excel 2003) is worth looking at - it
might meet your requirements. I think it is supposed to be released sometime
in Dec 2005 - anyone has any confirmed information on the release date?
For details on MS Reports:
http://download.microsoft.com/download/d/6/f/d6f66e9b-1b72-4192-b4ae-cecbad1a4903/MSReportsTCS.doc
-K
"Jeronimo Vogt" wrote:
> You can call the report using the url access, as:
> http://<server>/ReportServer?/<report
> path>&rs:Command=Render&rs:Format=EXCEL
> Jeronimo Vogt
> "Parimal" <Parimal@.discussions.microsoft.com> wrote in message
> news:3761A0CF-EFA4-4266-8E15-4832D6AF3814@.microsoft.com...
> > Hi,
> > We have multiple reports created in the SRS 2005. What is the best
> approach
> > to directly exporting (rendering) the created reports in Excel without
> using
> > any report viewer control or report manager for exporting on click of the
> > button.
> > Thanx in advance.
>
>
We have multiple reports created in the SRS 2005. What is the best approach
to directly exporting (rendering) the created reports in Excel without using
any report viewer control or report manager for exporting on click of the
button.
Thanx in advance.You can call the report using the url access, as:
http://<server>/ReportServer?/<report
path>&rs:Command=Render&rs:Format=EXCEL
Jeronimo Vogt
"Parimal" <Parimal@.discussions.microsoft.com> wrote in message
news:3761A0CF-EFA4-4266-8E15-4832D6AF3814@.microsoft.com...
> Hi,
> We have multiple reports created in the SRS 2005. What is the best
approach
> to directly exporting (rendering) the created reports in Excel without
using
> any report viewer control or report manager for exporting on click of the
> button.
> Thanx in advance.|||The new MS Reports tool (an addition to Excel 2003) is worth looking at - it
might meet your requirements. I think it is supposed to be released sometime
in Dec 2005 - anyone has any confirmed information on the release date?
For details on MS Reports:
http://download.microsoft.com/download/d/6/f/d6f66e9b-1b72-4192-b4ae-cecbad1a4903/MSReportsTCS.doc
-K
"Jeronimo Vogt" wrote:
> You can call the report using the url access, as:
> http://<server>/ReportServer?/<report
> path>&rs:Command=Render&rs:Format=EXCEL
> Jeronimo Vogt
> "Parimal" <Parimal@.discussions.microsoft.com> wrote in message
> news:3761A0CF-EFA4-4266-8E15-4832D6AF3814@.microsoft.com...
> > Hi,
> > We have multiple reports created in the SRS 2005. What is the best
> approach
> > to directly exporting (rendering) the created reports in Excel without
> using
> > any report viewer control or report manager for exporting on click of the
> > button.
> > Thanx in advance.
>
>
Subscribe to:
Posts (Atom)