Showing posts with label reportingservices. Show all posts
Showing posts with label reportingservices. Show all posts

Monday, March 26, 2012

ReportViewer

Hi,
I'm using Microsoft.Samples.ReportingServices.ReportViewer for
visualization of the my reports in dotnet C# application.
But, my the ReportViewer position in my folder and do not in my report
when i show my dotnet application.
Example:
My RS manager is:
http://maq-100911/Reporting/
My report name is: Prototipo.rdl
My Report correct visualization in RS Manager is:
http://maq-100911/Reporting/Pages/Report.aspx?ItemPath=%2fPrototipo
How do implementation ReportViewer correctly?
I do:
ReportViewer1.ServerUrl = "http://maq-100911/Reporting";
ReportViewer1.ReportPath = "/Prototipo";
Sorry, i'm from Brazi and my English is so so ...
Tks
MercanteYou have only to build ReportViewer sample and insert it in your webform. It
should work.
I didn't understand what you said:
"But, my the ReportViewer position in my folder and do not in my report when
i show my dotnet application"
Se vc quer, pode escrever isso em portugues.
Jaime
"Mercante" <claumerc@.hotmail.com> wrote in message
news:1123277239.233053.298930@.o13g2000cwo.googlegroups.com...
> Hi,
> I'm using Microsoft.Samples.ReportingServices.ReportViewer for
> visualization of the my reports in dotnet C# application.
> But, my the ReportViewer position in my folder and do not in my report
> when i show my dotnet application.
> Example:
> My RS manager is:
> http://maq-100911/Reporting/
> My report name is: Prototipo.rdl
> My Report correct visualization in RS Manager is:
> http://maq-100911/Reporting/Pages/Report.aspx?ItemPath=%2fPrototipo
> How do implementation ReportViewer correctly?
> I do:
> ReportViewer1.ServerUrl = "http://maq-100911/Reporting";
> ReportViewer1.ReportPath = "/Prototipo";
> Sorry, i'm from Brazi and my English is so so ...
> Tks
> Mercante
>sql

Reportservice2005.asmx throws an error in logonUser

I have 2 instances of reportingservices 2005. Trying to use the one
ReportingServer with Forms Authentication like this
server.Url = @."http://web2/reportserver2/reportservice2005.asmx";
server.LogonUser(TxtUser.Text,TxtPwd.Text, null);
the logon method throws this :
System.Web.Services.Protocols.SoapException: Server did not recognize the
value of HTTP Header SOAPAction:
http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/LogonUser.
at System.Web.Services.Protocols.Soap11ServerProtocolHelper.RouteRequest() at
System.Web.Services.Protocols.SoapServerProtocol.RouteRequest(SoapServerMessage
message) at System.Web.Services.Protocols.SoapServerProtocol.Initialize() at
System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type,
HttpContext context, HttpRequest request, HttpResponse response, Boolean&
abortProcessing)
Is it not possible to have 2 reporting webservices running ? or do I need
some extra setup. The documentation says that it is not possible to call
logonUser without SSL. I dont use SSL. But I have seen examples that not uses
SSL. Is that a problem ?
--
Regards
Henrik JuelHello Henrik,
As you know, LogonUser must be called over Secure Sockets Layer (SSL). The
method fails if it is not called securely. Upon successful authentication,
the report server Web service generates an authentication cookie and
returns the cookie in the HTTPS header. The response is returned over SSL.
Please refer to the following link for details:
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswe
bservice.rsexecutionservice2005.reportexecutionservice.logonuser.aspx
In addition, this issue could occur your SOAP proxy version doesn't match
the server version. Please make sure the version you see when you navigate
to http://servername/reportserver/endpoint.asmx?wsdl is the same as the one
you use in your client proxy.
Or, you could try to remove/readd the reference to test.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>Thread-Topic: Reportservice2005.asmx throws an error in logonUser
>thread-index: AcY+81Z92IvjjV7hRfiHMD/bouDyEA==>X-WBNR-Posting-Host: 212.242.254.200
>From: =?Utf-8?B?SGVucmlrIEp1ZWw=?= <HenrikJuel@.newsgroup.nospam>
>Subject: Reportservice2005.asmx throws an error in logonUser
>Date: Fri, 3 Mar 2006 10:50:27 -0800
>Lines: 26
>Message-ID: <EA7C04E1-6228-4C30-9C89-60736C98D92E@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:69790
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>I have 2 instances of reportingservices 2005. Trying to use the one
>ReportingServer with Forms Authentication like this
>server.Url = @."http://web2/reportserver2/reportservice2005.asmx";
>server.LogonUser(TxtUser.Text,TxtPwd.Text, null);
>the logon method throws this :
>System.Web.Services.Protocols.SoapException: Server did not recognize the
>value of HTTP Header SOAPAction:
>http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/
LogonUser.
>at System.Web.Services.Protocols.Soap11ServerProtocolHelper.RouteRequest()
at
>System.Web.Services.Protocols.SoapServerProtocol.RouteRequest(SoapServerMes
sage
>message) at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
at
>System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type,
>HttpContext context, HttpRequest request, HttpResponse response, Boolean&
>abortProcessing)
>Is it not possible to have 2 reporting webservices running ? or do I need
>some extra setup. The documentation says that it is not possible to call
>logonUser without SSL. I dont use SSL. But I have seen examples that not
uses
>SSL. Is that a problem ?
>--
>Regards
>Henrik Juel
>

Wednesday, March 7, 2012

ReportingServices - global access problem.

Hi, experts.
I have a strange problem with accessing Analysis Services from
Reporting
Services.
Our client needs to public reports in the web site and to make them
accessible for everybody. In order to achieve it, I did the following:
1. In IIS I put the anonymous access for the virtual directory
ReportServer. (the user IWAM_hostname)
2. I granted the explorer right to the user IWAM_hostname from the web
application that permits the reports to be managed.
3. In the same application I changed the credentials for the dataset
that pointed to analysis services. I chose the "stored credentials"
(the user I specified had access rights in the corresponding cube).
Once the configuration was established, I tried to access our reports
via web. I could see reporting services interface but it was not
possible to view the data from analysis services. There was an error:
"dimension not known."
Seeing this, I decided to give analysis services rights for the
IWAM_hostname user, but it brought the same result.
When I changed the configuration of Report Server virtual directory
(instead of anonymous access, I put the windows authorization again),
everything worked fine.
I have an impression that credentials specified in the web application
are ignored.
The question is, which user is used to access the Analysis Services
from the Reporting Services when the anonymous user is set in the IIS
ReportServer directory.
All relevant information will be appreciated.
One more thing: Reporting Services has the servicepack 1 installed.
Thanks in advance
Maciej KiewraHi Maciej,
I have the exact same problem as you. I was told to try and add entry to
the RSWebApplication.config file. It is
<ReportServerExternalUrl>http://yourwebservername/ReportServer</ReportServerExternalUrl>
add this right after the <ReportServerUrl> entry. This didn't work for me
but I am interested in if it works for you. Let me know.
Thanks,
JJ
"Maciej Kiewra" wrote:
> Hi, experts.
>
> I have a strange problem with accessing Analysis Services from
> Reporting
> Services.
> Our client needs to public reports in the web site and to make them
> accessible for everybody. In order to achieve it, I did the following:
> 1. In IIS I put the anonymous access for the virtual directory
> ReportServer. (the user IWAM_hostname)
> 2. I granted the explorer right to the user IWAM_hostname from the web
> application that permits the reports to be managed.
> 3. In the same application I changed the credentials for the dataset
> that pointed to analysis services. I chose the "stored credentials"
> (the user I specified had access rights in the corresponding cube).
> Once the configuration was established, I tried to access our reports
> via web. I could see reporting services interface but it was not
> possible to view the data from analysis services. There was an error:
> "dimension not known."
> Seeing this, I decided to give analysis services rights for the
> IWAM_hostname user, but it brought the same result.
> When I changed the configuration of Report Server virtual directory
> (instead of anonymous access, I put the windows authorization again),
> everything worked fine.
> I have an impression that credentials specified in the web application
> are ignored.
> The question is, which user is used to access the Analysis Services
> from the Reporting Services when the anonymous user is set in the IIS
> ReportServer directory.
> All relevant information will be appreciated.
> One more thing: Reporting Services has the servicepack 1 installed.
>
> Thanks in advance
> Maciej Kiewra
>