Hi all,
Quick Question-
Is it possible to have two websites on the same report server for reporting
services?
Example: I have one website, lets say for internal reports (employee time,
job info etc.) and another one for customer info (how a customer product is
coming along, how many product support cases we have out there).
http://cmbsssmsrs/personaltime/reports and http://cmbsssmsrs/vantive/reports
I hope someone can help or point me in the right direction.
Thanks in advanced,
Kerrie
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200508/1I installed a named instance of SQL 2005 with reporting services and it
installed a second reporting services virtual directory on my server... I
suspect that it can be done, but do not know if it is supported... remember
that reporting services is just a dot net app. You probably have to have a
different pair of DBs to support it..
Can you possibly use different directories on a single instance, with
different permissions?
--
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
"Kerrie S via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:52B1C7ACAA5B4@.SQLMonster.com...
> Hi all,
> Quick Question-
> Is it possible to have two websites on the same report server for
> reporting
> services?
> Example: I have one website, lets say for internal reports (employee time,
> job info etc.) and another one for customer info (how a customer product
> is
> coming along, how many product support cases we have out there).
> http://cmbsssmsrs/personaltime/reports and
> http://cmbsssmsrs/vantive/reports
> I hope someone can help or point me in the right direction.
> Thanks in advanced,
> Kerrie
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200508/1
Showing posts with label website. Show all posts
Showing posts with label website. Show all posts
Wednesday, March 28, 2012
Report Viewer trying to get it running and having problems
I have a website with two textboxes. I am passing those text boxes as parameters into the Report Viewer. I receive this error: "An error has occurred during report processing. ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'GetData' that has no parameters."
I thought I had the xsd and rdlc set up properly but obviously I am missing something. If you can step me through this I would appreciate it.
Look in the control ObjectDataSource this control have the Property Select Method and Select Parmaters .
The Select Method must be with the parameters EJ: GetData(idcity)
In Select Parameters you have to add the parameter -- one for each textbox
You can send me the code for more help :victormartineze@.gmail.com
Sorry i dont speack english
Monday, March 26, 2012
Report Viewer on Internet Site
Hi, I am developing a website that will use the VS Report Viewer control to display some business reports.....The website will be on the internet, but the report viewer will need to access an internal report server that the internet users don't have access to? Is this possible, or the correct way to do this? Any ideas / suggestions would be appreciated!
Cheers
Chris
If you use anonymous access then the user who is accessing the report from the internet does not have to authenticate any type of username to the server.
However, you probably don't want just ANYONE to see your reports, so you may want to develop a secure front-end with Visual Studio to authenticate the user in that fashion. Sort of like a portal on a website. If you go this route, be sure to use a stored procedure and possibly encryption for your password I/O.
Friday, March 9, 2012
Report Server website - button presses ignored
I'm seeing a strange problem on my production Reportng Services (SQL 2000)
server.
Some of the website buttons, like OK & CANCEL when attempting to create a
new site-wide Schedule, don't function. No error reported when you press
them, they're just ignored, it's as if the installation failed to complete
properly.
My development server, also running SQL 2000 and Reporting Services, doesn't
have the issue.Have you got activeX disabled?
Are you running sp2?
SimonN wrote:
> I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> server.
> Some of the website buttons, like OK & CANCEL when attempting to create a
> new site-wide Schedule, don't function. No error reported when you press
> them, they're just ignored, it's as if the installation failed to complete
> properly.
> My development server, also running SQL 2000 and Reporting Services, doesn't
> have the issue.|||HI. Tks for the reply.
No ActiveX is not disabled, and client PC is running SP2.
Browsing the two installations from the same client, so i can bring up two
IEs one pointing to an RS website that works and the other to the one that is
faulty.
"SmartbizAustralia" wrote:
> Have you got activeX disabled?
> Are you running sp2?
> SimonN wrote:
> > I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> > server.
> >
> > Some of the website buttons, like OK & CANCEL when attempting to create a
> > new site-wide Schedule, don't function. No error reported when you press
> > them, they're just ignored, it's as if the installation failed to complete
> > properly.
> >
> > My development server, also running SQL 2000 and Reporting Services, doesn't
> > have the issue.
>|||Simon,
Look in the Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config file for a <ReportServerURL>
and <ReportServerExternalURL> config values. Many times these reference the
machine name instead of the URL used to access the reporting services. I've
found if these these entries don't match the domain name in the URL used to
access report manager, many of the buttons simply don't do anything when
clicked.
- Chris
"SimonN" <SimonN@.discussions.microsoft.com> wrote in message
news:63A63397-D966-4A70-8D5A-24AD9054E50B@.microsoft.com...
> I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> server.
> Some of the website buttons, like OK & CANCEL when attempting to create a
> new site-wide Schedule, don't function. No error reported when you press
> them, they're just ignored, it's as if the installation failed to complete
> properly.
> My development server, also running SQL 2000 and Reporting Services,
> doesn't
> have the issue.|||Chris,
Thanks for the reply.
I checked the value of ReportServerURL in the RSWebApplication.config, it's
set to the correct name of the server. I have a DNS alias that user will use
to run reports, but for all administration I'll stick to using the actual
server in the URL.
I don't have an entry for ReportServerExternalURL, but it sounds like this
is a 2005 feature when accessing the Report Server through a firewall. I'm
only running the 2000 version.
Unfortunately, I'm still seeing the same issue even when I browse with the
serve name identified by the ReportServerURL config element.
"Chris Walls" wrote:
> Simon,
> Look in the Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config file for a <ReportServerURL>
> and <ReportServerExternalURL> config values. Many times these reference the
> machine name instead of the URL used to access the reporting services. I've
> found if these these entries don't match the domain name in the URL used to
> access report manager, many of the buttons simply don't do anything when
> clicked.
> - Chris
> "SimonN" <SimonN@.discussions.microsoft.com> wrote in message
> news:63A63397-D966-4A70-8D5A-24AD9054E50B@.microsoft.com...
> > I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> > server.
> >
> > Some of the website buttons, like OK & CANCEL when attempting to create a
> > new site-wide Schedule, don't function. No error reported when you press
> > them, they're just ignored, it's as if the installation failed to complete
> > properly.
> >
> > My development server, also running SQL 2000 and Reporting Services,
> > doesn't
> > have the issue.
>
>
server.
Some of the website buttons, like OK & CANCEL when attempting to create a
new site-wide Schedule, don't function. No error reported when you press
them, they're just ignored, it's as if the installation failed to complete
properly.
My development server, also running SQL 2000 and Reporting Services, doesn't
have the issue.Have you got activeX disabled?
Are you running sp2?
SimonN wrote:
> I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> server.
> Some of the website buttons, like OK & CANCEL when attempting to create a
> new site-wide Schedule, don't function. No error reported when you press
> them, they're just ignored, it's as if the installation failed to complete
> properly.
> My development server, also running SQL 2000 and Reporting Services, doesn't
> have the issue.|||HI. Tks for the reply.
No ActiveX is not disabled, and client PC is running SP2.
Browsing the two installations from the same client, so i can bring up two
IEs one pointing to an RS website that works and the other to the one that is
faulty.
"SmartbizAustralia" wrote:
> Have you got activeX disabled?
> Are you running sp2?
> SimonN wrote:
> > I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> > server.
> >
> > Some of the website buttons, like OK & CANCEL when attempting to create a
> > new site-wide Schedule, don't function. No error reported when you press
> > them, they're just ignored, it's as if the installation failed to complete
> > properly.
> >
> > My development server, also running SQL 2000 and Reporting Services, doesn't
> > have the issue.
>|||Simon,
Look in the Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config file for a <ReportServerURL>
and <ReportServerExternalURL> config values. Many times these reference the
machine name instead of the URL used to access the reporting services. I've
found if these these entries don't match the domain name in the URL used to
access report manager, many of the buttons simply don't do anything when
clicked.
- Chris
"SimonN" <SimonN@.discussions.microsoft.com> wrote in message
news:63A63397-D966-4A70-8D5A-24AD9054E50B@.microsoft.com...
> I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> server.
> Some of the website buttons, like OK & CANCEL when attempting to create a
> new site-wide Schedule, don't function. No error reported when you press
> them, they're just ignored, it's as if the installation failed to complete
> properly.
> My development server, also running SQL 2000 and Reporting Services,
> doesn't
> have the issue.|||Chris,
Thanks for the reply.
I checked the value of ReportServerURL in the RSWebApplication.config, it's
set to the correct name of the server. I have a DNS alias that user will use
to run reports, but for all administration I'll stick to using the actual
server in the URL.
I don't have an entry for ReportServerExternalURL, but it sounds like this
is a 2005 feature when accessing the Report Server through a firewall. I'm
only running the 2000 version.
Unfortunately, I'm still seeing the same issue even when I browse with the
serve name identified by the ReportServerURL config element.
"Chris Walls" wrote:
> Simon,
> Look in the Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config file for a <ReportServerURL>
> and <ReportServerExternalURL> config values. Many times these reference the
> machine name instead of the URL used to access the reporting services. I've
> found if these these entries don't match the domain name in the URL used to
> access report manager, many of the buttons simply don't do anything when
> clicked.
> - Chris
> "SimonN" <SimonN@.discussions.microsoft.com> wrote in message
> news:63A63397-D966-4A70-8D5A-24AD9054E50B@.microsoft.com...
> > I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> > server.
> >
> > Some of the website buttons, like OK & CANCEL when attempting to create a
> > new site-wide Schedule, don't function. No error reported when you press
> > them, they're just ignored, it's as if the installation failed to complete
> > properly.
> >
> > My development server, also running SQL 2000 and Reporting Services,
> > doesn't
> > have the issue.
>
>
Report Server Security
I have been playing around with the security on my SQL Reporting Server and
want to make sure I have reset it correctly.
Under my default website I have \Reports (http://server/reports). When I
Right Click the virtual and go into the Properties/Directory Security
Tab/Edit button on the Authentication and Access control what should I have
checked for "Enable Anonomous" checkbox and and "Integrated Security"
checkbox? Same goes for default website\ReportServer. What would happen
if only Anonomous is checked?
When I have only Integrated checked on \ReportServer I get just a plain page
giving me the Reporting server name and a MSRS version of 9.00.3042.00 But
nothing else. Does this virtual directory do nothing and only used by the
configuration manager?
Thanks
-Richard KFirst, a suggestion, do not ever go outside of RS and set security on the
websites. Set security from within RS and let it do what it needs to. I have
never touched the websites from IIS.
Second, if you set anonymous then you lose all admin rights (because you are
anonymous, RS does not know you are an admin).
RS consists of two applications. ReportServer is the site for Reporting
Services. Reports is the portal that ships with RS. Some people use it some
don't. With ReportServer website all you see are directories (which if you
have not deployed anything yet you would not have any directories listed).
Report Manager (what the portal is called) uses webservices with
ReportServer for all it does.
Go to http://yourseverhere/Reports/Pages/Folder.aspx
for Report Manager website. If you do not have anonymous set and you are an
admin on the server box then you will automatically be admin in RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard K" <Rkokoski@.gmail.com> wrote in message
news:uZNFcggYIHA.3964@.TK2MSFTNGP03.phx.gbl...
>I have been playing around with the security on my SQL Reporting Server and
>want to make sure I have reset it correctly.
> Under my default website I have \Reports (http://server/reports). When I
> Right Click the virtual and go into the Properties/Directory Security
> Tab/Edit button on the Authentication and Access control what should I
> have checked for "Enable Anonomous" checkbox and and "Integrated Security"
> checkbox? Same goes for default website\ReportServer. What would happen
> if only Anonomous is checked?
> When I have only Integrated checked on \ReportServer I get just a plain
> page giving me the Reporting server name and a MSRS version of
> 9.00.3042.00 But nothing else. Does this virtual directory do nothing
> and only used by the configuration manager?
> Thanks
> -Richard K
>|||Thanks for the reply and confirmation of what I have been seeing.
Somestimes curiousity "killed the cat" with looking at the IIS side of the
world. I'm very good with SQL but a newbie to Report Services so just
trying to learn.
-Richard K
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OMnCCdoYIHA.1132@.TK2MSFTNGP06.phx.gbl...
> First, a suggestion, do not ever go outside of RS and set security on the
> websites. Set security from within RS and let it do what it needs to. I
> have never touched the websites from IIS.
> Second, if you set anonymous then you lose all admin rights (because you
> are anonymous, RS does not know you are an admin).
> RS consists of two applications. ReportServer is the site for Reporting
> Services. Reports is the portal that ships with RS. Some people use it
> some don't. With ReportServer website all you see are directories (which
> if you have not deployed anything yet you would not have any directories
> listed). Report Manager (what the portal is called) uses webservices with
> ReportServer for all it does.
> Go to http://yourseverhere/Reports/Pages/Folder.aspx
> for Report Manager website. If you do not have anonymous set and you are
> an admin on the server box then you will automatically be admin in RS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Richard K" <Rkokoski@.gmail.com> wrote in message
> news:uZNFcggYIHA.3964@.TK2MSFTNGP03.phx.gbl...
>>I have been playing around with the security on my SQL Reporting Server
>>and want to make sure I have reset it correctly.
>> Under my default website I have \Reports (http://server/reports). When I
>> Right Click the virtual and go into the Properties/Directory Security
>> Tab/Edit button on the Authentication and Access control what should I
>> have checked for "Enable Anonomous" checkbox and and "Integrated
>> Security" checkbox? Same goes for default website\ReportServer. What
>> would happen if only Anonomous is checked?
>> When I have only Integrated checked on \ReportServer I get just a plain
>> page giving me the Reporting server name and a MSRS version of
>> 9.00.3042.00 But nothing else. Does this virtual directory do nothing
>> and only used by the configuration manager?
>> Thanks
>> -Richard K
>>
>
want to make sure I have reset it correctly.
Under my default website I have \Reports (http://server/reports). When I
Right Click the virtual and go into the Properties/Directory Security
Tab/Edit button on the Authentication and Access control what should I have
checked for "Enable Anonomous" checkbox and and "Integrated Security"
checkbox? Same goes for default website\ReportServer. What would happen
if only Anonomous is checked?
When I have only Integrated checked on \ReportServer I get just a plain page
giving me the Reporting server name and a MSRS version of 9.00.3042.00 But
nothing else. Does this virtual directory do nothing and only used by the
configuration manager?
Thanks
-Richard KFirst, a suggestion, do not ever go outside of RS and set security on the
websites. Set security from within RS and let it do what it needs to. I have
never touched the websites from IIS.
Second, if you set anonymous then you lose all admin rights (because you are
anonymous, RS does not know you are an admin).
RS consists of two applications. ReportServer is the site for Reporting
Services. Reports is the portal that ships with RS. Some people use it some
don't. With ReportServer website all you see are directories (which if you
have not deployed anything yet you would not have any directories listed).
Report Manager (what the portal is called) uses webservices with
ReportServer for all it does.
Go to http://yourseverhere/Reports/Pages/Folder.aspx
for Report Manager website. If you do not have anonymous set and you are an
admin on the server box then you will automatically be admin in RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard K" <Rkokoski@.gmail.com> wrote in message
news:uZNFcggYIHA.3964@.TK2MSFTNGP03.phx.gbl...
>I have been playing around with the security on my SQL Reporting Server and
>want to make sure I have reset it correctly.
> Under my default website I have \Reports (http://server/reports). When I
> Right Click the virtual and go into the Properties/Directory Security
> Tab/Edit button on the Authentication and Access control what should I
> have checked for "Enable Anonomous" checkbox and and "Integrated Security"
> checkbox? Same goes for default website\ReportServer. What would happen
> if only Anonomous is checked?
> When I have only Integrated checked on \ReportServer I get just a plain
> page giving me the Reporting server name and a MSRS version of
> 9.00.3042.00 But nothing else. Does this virtual directory do nothing
> and only used by the configuration manager?
> Thanks
> -Richard K
>|||Thanks for the reply and confirmation of what I have been seeing.
Somestimes curiousity "killed the cat" with looking at the IIS side of the
world. I'm very good with SQL but a newbie to Report Services so just
trying to learn.
-Richard K
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OMnCCdoYIHA.1132@.TK2MSFTNGP06.phx.gbl...
> First, a suggestion, do not ever go outside of RS and set security on the
> websites. Set security from within RS and let it do what it needs to. I
> have never touched the websites from IIS.
> Second, if you set anonymous then you lose all admin rights (because you
> are anonymous, RS does not know you are an admin).
> RS consists of two applications. ReportServer is the site for Reporting
> Services. Reports is the portal that ships with RS. Some people use it
> some don't. With ReportServer website all you see are directories (which
> if you have not deployed anything yet you would not have any directories
> listed). Report Manager (what the portal is called) uses webservices with
> ReportServer for all it does.
> Go to http://yourseverhere/Reports/Pages/Folder.aspx
> for Report Manager website. If you do not have anonymous set and you are
> an admin on the server box then you will automatically be admin in RS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Richard K" <Rkokoski@.gmail.com> wrote in message
> news:uZNFcggYIHA.3964@.TK2MSFTNGP03.phx.gbl...
>>I have been playing around with the security on my SQL Reporting Server
>>and want to make sure I have reset it correctly.
>> Under my default website I have \Reports (http://server/reports). When I
>> Right Click the virtual and go into the Properties/Directory Security
>> Tab/Edit button on the Authentication and Access control what should I
>> have checked for "Enable Anonomous" checkbox and and "Integrated
>> Security" checkbox? Same goes for default website\ReportServer. What
>> would happen if only Anonomous is checked?
>> When I have only Integrated checked on \ReportServer I get just a plain
>> page giving me the Reporting server name and a MSRS version of
>> 9.00.3042.00 But nothing else. Does this virtual directory do nothing
>> and only used by the configuration manager?
>> Thanks
>> -Richard K
>>
>
Monday, February 20, 2012
Report rendering in webform
Hi,
Currently I display report in my webform (website) using
Reportviewer.ReportURL method which fetch report from Report Manger through
Http:// port. which takes too much to rendering report.
Is there any method through which I can render report in my webpage through
reprot API or something like that so that it doesn't fetch report through
http port and rendering time should be fast.
Thanks in Advance.Kam,
I am curious as to how you determined that using HTTP-GET causes the slow
performance? Did you look at how long it takes for the database query to be
processed, report to be generated and rendered?
Requesting your reports via HTTP-GET is the fastest way to generate them.
Think of the Report Server (not Report Manager) as a web application. Your
request/response total latency consists of submitting the report request to
the Report Server, querying the database, generating the report, rendering
the report, sending the report payload to the Report Viewer (browser), and
displaying the report in the browser. From this latencies, you should focus
on minimizing the time it takes to query the database and generate the
report.
Here is a tip: use the RS Execution Log to find out how much the Report
Server spends querying, generating and rendering your report.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> Hi,
> Currently I display report in my webform (website) using
> Reportviewer.ReportURL method which fetch report from Report Manger
through
> Http:// port. which takes too much to rendering report.
> Is there any method through which I can render report in my webpage
through
> reprot API or something like that so that it doesn't fetch report through
> http port and rendering time should be fast.
> Thanks in Advance.|||How to check R S Exectuion Log ?
"Teo Lachev" wrote:
> Kam,
> I am curious as to how you determined that using HTTP-GET causes the slow
> performance? Did you look at how long it takes for the database query to be
> processed, report to be generated and rendered?
> Requesting your reports via HTTP-GET is the fastest way to generate them.
> Think of the Report Server (not Report Manager) as a web application. Your
> request/response total latency consists of submitting the report request to
> the Report Server, querying the database, generating the report, rendering
> the report, sending the report payload to the Report Viewer (browser), and
> displaying the report in the browser. From this latencies, you should focus
> on minimizing the time it takes to query the database and generate the
> report.
> Here is a tip: use the RS Execution Log to find out how much the Report
> Server spends querying, generating and rendering your report.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Kam" <Kam@.discussions.microsoft.com> wrote in message
> news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> > Hi,
> > Currently I display report in my webform (website) using
> > Reportviewer.ReportURL method which fetch report from Report Manger
> through
> > Http:// port. which takes too much to rendering report.
> > Is there any method through which I can render report in my webpage
> through
> > reprot API or something like that so that it doesn't fetch report through
> > http port and rendering time should be fast.
> >
> > Thanks in Advance.
>
>|||Here is a code to render a report in a stream sent to an aspnet page.
//Create a Reporting Service Object (you have to add a reference to it in
VS.NET)
localhost.ReportingService s = new localhost.ReportingService ();
//specify the credentials
s.Credentials = new System.Net.NetworkCredential("myuser",
"mypassword","");
try
{
// Render arguments
byte[] result = null;
string reportPath = "/Test/Rlinktest";
string format = "HTML4.0";
string historyID = null;
string devInfo = "";
string showHideToggle = null;
string encoding;
string mimeType;
localhost.Warning[] warnings = null;
localhost.ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
localhost.SessionHeader sh = new localhost.SessionHeader();
s.SessionHeaderValue = sh;
//call the render method of webservice
result = s.Render(reportPath, format, historyID, devInfo, null, null,
showHideToggle, out encoding, out mimeType, out
reportHistoryParameters, out warnings,
out streamIDs);
Response.ClearContent();
Response.ContentType="text/html";
Response.BinaryWrite(result);
Response.Flush();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
Cédric
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> Hi,
> Currently I display report in my webform (website) using
> Reportviewer.ReportURL method which fetch report from Report Manger
> through
> Http:// port. which takes too much to rendering report.
> Is there any method through which I can render report in my webpage
> through
> reprot API or something like that so that it doesn't fetch report through
> http port and rendering time should be fast.
> Thanks in Advance.|||Kam,
The RS Execution Log is stored in the ExecutionLog table in the RS
ReportServer database. For analyzing its data easier, you need to install
the Execution Log DTS package. Check the Rs documentation for the following
topics:
- Report Server Execution Log
- Querying and Reporting on Report Execution Log Data
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:6BF3E420-9468-43C5-8E48-925B6C806D69@.microsoft.com...
> How to check R S Exectuion Log ?
> "Teo Lachev" wrote:
> > Kam,
> >
> > I am curious as to how you determined that using HTTP-GET causes the
slow
> > performance? Did you look at how long it takes for the database query to
be
> > processed, report to be generated and rendered?
> >
> > Requesting your reports via HTTP-GET is the fastest way to generate
them.
> > Think of the Report Server (not Report Manager) as a web application.
Your
> > request/response total latency consists of submitting the report request
to
> > the Report Server, querying the database, generating the report,
rendering
> > the report, sending the report payload to the Report Viewer (browser),
and
> > displaying the report in the browser. From this latencies, you should
focus
> > on minimizing the time it takes to query the database and generate the
> > report.
> >
> > Here is a tip: use the RS Execution Log to find out how much the Report
> > Server spends querying, generating and rendering your report.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > http://www.prologika.com
> >
> >
> > "Kam" <Kam@.discussions.microsoft.com> wrote in message
> > news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> > > Hi,
> > > Currently I display report in my webform (website) using
> > > Reportviewer.ReportURL method which fetch report from Report Manger
> > through
> > > Http:// port. which takes too much to rendering report.
> > > Is there any method through which I can render report in my webpage
> > through
> > > reprot API or something like that so that it doesn't fetch report
through
> > > http port and rendering time should be fast.
> > >
> > > Thanks in Advance.
> >
> >
> >
Currently I display report in my webform (website) using
Reportviewer.ReportURL method which fetch report from Report Manger through
Http:// port. which takes too much to rendering report.
Is there any method through which I can render report in my webpage through
reprot API or something like that so that it doesn't fetch report through
http port and rendering time should be fast.
Thanks in Advance.Kam,
I am curious as to how you determined that using HTTP-GET causes the slow
performance? Did you look at how long it takes for the database query to be
processed, report to be generated and rendered?
Requesting your reports via HTTP-GET is the fastest way to generate them.
Think of the Report Server (not Report Manager) as a web application. Your
request/response total latency consists of submitting the report request to
the Report Server, querying the database, generating the report, rendering
the report, sending the report payload to the Report Viewer (browser), and
displaying the report in the browser. From this latencies, you should focus
on minimizing the time it takes to query the database and generate the
report.
Here is a tip: use the RS Execution Log to find out how much the Report
Server spends querying, generating and rendering your report.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> Hi,
> Currently I display report in my webform (website) using
> Reportviewer.ReportURL method which fetch report from Report Manger
through
> Http:// port. which takes too much to rendering report.
> Is there any method through which I can render report in my webpage
through
> reprot API or something like that so that it doesn't fetch report through
> http port and rendering time should be fast.
> Thanks in Advance.|||How to check R S Exectuion Log ?
"Teo Lachev" wrote:
> Kam,
> I am curious as to how you determined that using HTTP-GET causes the slow
> performance? Did you look at how long it takes for the database query to be
> processed, report to be generated and rendered?
> Requesting your reports via HTTP-GET is the fastest way to generate them.
> Think of the Report Server (not Report Manager) as a web application. Your
> request/response total latency consists of submitting the report request to
> the Report Server, querying the database, generating the report, rendering
> the report, sending the report payload to the Report Viewer (browser), and
> displaying the report in the browser. From this latencies, you should focus
> on minimizing the time it takes to query the database and generate the
> report.
> Here is a tip: use the RS Execution Log to find out how much the Report
> Server spends querying, generating and rendering your report.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Kam" <Kam@.discussions.microsoft.com> wrote in message
> news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> > Hi,
> > Currently I display report in my webform (website) using
> > Reportviewer.ReportURL method which fetch report from Report Manger
> through
> > Http:// port. which takes too much to rendering report.
> > Is there any method through which I can render report in my webpage
> through
> > reprot API or something like that so that it doesn't fetch report through
> > http port and rendering time should be fast.
> >
> > Thanks in Advance.
>
>|||Here is a code to render a report in a stream sent to an aspnet page.
//Create a Reporting Service Object (you have to add a reference to it in
VS.NET)
localhost.ReportingService s = new localhost.ReportingService ();
//specify the credentials
s.Credentials = new System.Net.NetworkCredential("myuser",
"mypassword","");
try
{
// Render arguments
byte[] result = null;
string reportPath = "/Test/Rlinktest";
string format = "HTML4.0";
string historyID = null;
string devInfo = "";
string showHideToggle = null;
string encoding;
string mimeType;
localhost.Warning[] warnings = null;
localhost.ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
localhost.SessionHeader sh = new localhost.SessionHeader();
s.SessionHeaderValue = sh;
//call the render method of webservice
result = s.Render(reportPath, format, historyID, devInfo, null, null,
showHideToggle, out encoding, out mimeType, out
reportHistoryParameters, out warnings,
out streamIDs);
Response.ClearContent();
Response.ContentType="text/html";
Response.BinaryWrite(result);
Response.Flush();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
Cédric
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> Hi,
> Currently I display report in my webform (website) using
> Reportviewer.ReportURL method which fetch report from Report Manger
> through
> Http:// port. which takes too much to rendering report.
> Is there any method through which I can render report in my webpage
> through
> reprot API or something like that so that it doesn't fetch report through
> http port and rendering time should be fast.
> Thanks in Advance.|||Kam,
The RS Execution Log is stored in the ExecutionLog table in the RS
ReportServer database. For analyzing its data easier, you need to install
the Execution Log DTS package. Check the Rs documentation for the following
topics:
- Report Server Execution Log
- Querying and Reporting on Report Execution Log Data
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:6BF3E420-9468-43C5-8E48-925B6C806D69@.microsoft.com...
> How to check R S Exectuion Log ?
> "Teo Lachev" wrote:
> > Kam,
> >
> > I am curious as to how you determined that using HTTP-GET causes the
slow
> > performance? Did you look at how long it takes for the database query to
be
> > processed, report to be generated and rendered?
> >
> > Requesting your reports via HTTP-GET is the fastest way to generate
them.
> > Think of the Report Server (not Report Manager) as a web application.
Your
> > request/response total latency consists of submitting the report request
to
> > the Report Server, querying the database, generating the report,
rendering
> > the report, sending the report payload to the Report Viewer (browser),
and
> > displaying the report in the browser. From this latencies, you should
focus
> > on minimizing the time it takes to query the database and generate the
> > report.
> >
> > Here is a tip: use the RS Execution Log to find out how much the Report
> > Server spends querying, generating and rendering your report.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > http://www.prologika.com
> >
> >
> > "Kam" <Kam@.discussions.microsoft.com> wrote in message
> > news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> > > Hi,
> > > Currently I display report in my webform (website) using
> > > Reportviewer.ReportURL method which fetch report from Report Manger
> > through
> > > Http:// port. which takes too much to rendering report.
> > > Is there any method through which I can render report in my webpage
> > through
> > > reprot API or something like that so that it doesn't fetch report
through
> > > http port and rendering time should be fast.
> > >
> > > Thanks in Advance.
> >
> >
> >
Subscribe to:
Posts (Atom)