Showing posts with label strange. Show all posts
Showing posts with label strange. Show all posts

Wednesday, March 28, 2012

Reporting Services 2005 and XML DataSource (as WebService)

I'm trying to build WebService to use result as DataSource for RS 2005 (XML DataSource).

But I have a strange problem.

I have WebMethod with parameters.

When I'm testing my WS in browser then everything works just fine.

But... When I'm trying to call this web-service from VS2005 environment then something strange happens.

Looks like VS passing parameters incorrectly to my WS (not passing at all!)

I've created very simplyfied version just to check parameters:

using System.Xml;
using System.Xml.Serialization;
using System.Messaging;
using System.Text;
using System;
using System.Web.Services;
[WebService(Namespace = "http://company.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class GetRemoteData : System.Web.Services.WebService
{
[WebMethod]
public XmlElement GetData(string CompanyName, string FunctionName, string ParameterList)
{
XmlDocument xmlDocument = new XmlDocument();
XmlElement xmlElement1;
xmlElement1 = xmlDocument.CreateElement("parameters", "values", "urn:errors");
xmlElement1.InnerText = String.Format("{0}, {1}, {2}", CompanyName, FunctionName, ParameterList);
return xmlElement1;
}
}

In the browser WS returns all passed parameters back correctly. VS - not.

What's wrong with my code? Why MSDN example works fine?
Do I need to specify some undocumented (soap specific) attributes?

Where I can find full tutorials how to create RS-compatible web-service?

(Sorry for cross-posting but I have no single reply...)

Hmmm...

I don't understand... Is it so hard? Nobody is using WebService as datasource for RS?

May be I've found some "global unfixable" issue is RS?

I'm checked "address" in my browser server times, but "microsoft" and "MSDN" still are here...

|||

So...?

I've tested different scenarious, but result always is same. RS (only RS!) doesn't passes parameters to my webservice or passing them incorrectly.

How to build RS2005-compatible WebService? I Have non-standard data source and need to show results as RS report.

Very funny result I've got then tried to create WebMethod which returns DataSet! In RS I've got scructure without data instead of data.

Why standard methods from ReportingService2005.asmx (ListChildren, for instance) returns values as "out" parameters?

|||

Dude,
Did you find a solution to this problem?

I fell into this issue for a project I'm developping... but what's weirdest is that I have another project which I developped last year, where I'm using web services with parameters and it works fine.... and I try to find the difference between the 2 of them but I just cannot find it ....

By now, I just know that it the one is working I'm using Kerberos delgation.... besides that, I think everything is the same...

Bye

Reporting Services 2005 and XML DataSource (as WebService)

I'm trying to build WebService to use result as DataSource for RS 2005 (XML DataSource).

But I have a strange problem.

I have WebMethod with parameters.

When I'm testing my WS in browser then everything works just fine.

But... When I'm trying to call this web-service from VS2005 environment then something strange happens.

Looks like VS passing parameters incorrectly to my WS (not passing at all!)

I've created very simplyfied version just to check parameters:

using System.Xml;
using System.Xml.Serialization;
using System.Messaging;
using System.Text;
using System;
using System.Web.Services;
[WebService(Namespace = "http://company.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class GetRemoteData : System.Web.Services.WebService
{
[WebMethod]
public XmlElement GetData(string CompanyName, string FunctionName, string ParameterList)
{
XmlDocument xmlDocument = new XmlDocument();
XmlElement xmlElement1;
xmlElement1 = xmlDocument.CreateElement("parameters", "values", "urn:errors");
xmlElement1.InnerText = String.Format("{0}, {1}, {2}", CompanyName, FunctionName, ParameterList);
return xmlElement1;
}
}

In the browser WS returns all passed parameters back correctly. VS - not.

What's wrong with my code? Why MSDN example works fine?
Do I need to specify some undocumented (soap specific) attributes?

Where I can find full tutorials how to create RS-compatible web-service?

(Sorry for cross-posting but I have no single reply...)

Hmmm...

I don't understand... Is it so hard? Nobody is using WebService as datasource for RS?

May be I've found some "global unfixable" issue is RS?

I'm checked "address" in my browser server times, but "microsoft" and "MSDN" still are here...

|||

So...?

I've tested different scenarious, but result always is same. RS (only RS!) doesn't passes parameters to my webservice or passing them incorrectly.

How to build RS2005-compatible WebService? I Have non-standard data source and need to show results as RS report.

Very funny result I've got then tried to create WebMethod which returns DataSet! In RS I've got scructure without data instead of data.

Why standard methods from ReportingService2005.asmx (ListChildren, for instance) returns values as "out" parameters?

|||

Dude,
Did you find a solution to this problem?

I fell into this issue for a project I'm developping... but what's weirdest is that I have another project which I developped last year, where I'm using web services with parameters and it works fine.... and I try to find the difference between the 2 of them but I just cannot find it ....

By now, I just know that it the one is working I'm using Kerberos delgation.... besides that, I think everything is the same...

Bye

sql

Friday, March 9, 2012

Reporting Service not installed even they say it was installed

When trying to install Rs on Win2003 server running standard SQL2k SP3a I get into strange situation.
On start of installation I get statement that asp.net and Visual studio are not installed or not running (they are installed and running)
Than it proceedes to install Reporting services, goes through all dialogues, states it is installed
But it is not! I can see RS books, but not the program, also no reporting services are running .
Help
Natalijahi,
i prepared a documentation to install sps,sqlserver and
reporting services in a machine...i'm sending it to
you..just leave with the sharepoint and do the
remaining ..u dont need to change any file name or any
thing . just follow the procedure. better to use sql
server enterprise edition
************
To configure a server running share point portal server,
sql server , analysis services and reporting services
Software Requirements:
1. windows 2003 server enterprise edition.
1.1. Configure application server (enable both front page
extensions and asp.net ) to install IIS.
1.2. Install smtp server
1.3. Configure DNS giving appropriate IP address.
2. SQL Server 2000 Enterprise Edition with Analysis
Services (if reqd) and service packs for both SQL server
and Analysis services.
3. Visual Studio .net Enterprise Architecture
4. Share Point Portal Server
Install share point portal server with out
desktop engine if u r using sql server on the same
machine.
while configuring share point portal server it
will ask to remove front page server extensions at the
time of creating a portal. remove the front page server
extensions and then restart the machine and after that
create a portal site.
5. Reporting services
While installing reporting services it will
check the system and gives a warning message that share
point is also installed in the system and we need to
manually configure reporting services.
leave it and go for the next tab.
Specify a domain/user account where ever asked.
unckeck the ssl certification if u dont have
any and check direct to default
website.
Then continue installing.
After installation
1. go to IIS
right click on reports--> properties--
>configuration -->extensions-->edit
and then uncheck if "Verify that the file exists" is
checked.
and then click OK
close IIS.
2. open E:\Inetpub\wwwroot\webconfig file.
2.1. in <http Modules>
include the third line also.
<add name="Session"
type="System.Web.SessionState.SessionStateModule"/>
and change the below line as follows
pages enableSessionState="true" enableViewState="true"
enableViewStateMac="true" validateRequest="false" />
3. In cmd prompt go to
E:\Program Files\Common Files\Microsoft Shared\web server
extensions\60\BIN
type
stsadm -o addpath -url http://localhost/reportserver -type
exclusion
and
stsadm -o addpath -url http://localhost/reports -type
exclusion
4. in cmd prompt go to
E:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer
type
rsactivate -c "rsreportserver.config"
Then restart the machine
ur configuration is complete now.
*********************
>--Original Message--
>When trying to install Rs on Win2003 server running
standard SQL2k SP3a I get into strange situation.
>On start of installation I get statement that asp.net and
Visual studio are not installed or not running (they are
installed and running)
>Than it proceedes to install Reporting services, goes
through all dialogues, states it is installed
>But it is not! I can see RS books, but not the program,
also no reporting services are running .
>Help
>Natalija
>.
>

Wednesday, March 7, 2012

Reporting Server replacing IP address with ComputerName

Hello,
I am facing a strange situation with my reports server.
The machine i am testing the server on has no domain name, only IP.
But, of course, it has a computer name.
When i access the report server manager, i get everything as it should
be, and it shows me the links to the reports, but when i want to see
the report, the report manager replaces IP in the report address, with
the computer name - which makes no sense since i am accessing the
server using the internet.
Hence, i am getting an 404 in the report sub-page.
If i copy the url from there, and go to the page after changing the
computer name to the IP, it works, naturally.
Does anybody know how to change this behavior?
Thanks in advance! :-)
ShlomoYes you need to see this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
Scroll down to the section that says "Deploying a Report Server for Internet
Access"
=-Chris
<shlomoid@.gmail.com> wrote in message
news:1108301192.984825.325330@.o13g2000cwo.googlegroups.com...
> Hello,
> I am facing a strange situation with my reports server.
> The machine i am testing the server on has no domain name, only IP.
> But, of course, it has a computer name.
> When i access the report server manager, i get everything as it should
> be, and it shows me the links to the reports, but when i want to see
> the report, the report manager replaces IP in the report address, with
> the computer name - which makes no sense since i am accessing the
> server using the internet.
> Hence, i am getting an 404 in the report sub-page.
> If i copy the url from there, and go to the page after changing the
> computer name to the IP, it works, naturally.
> Does anybody know how to change this behavior?
>
> Thanks in advance! :-)
> Shlomo
>|||Thanks!
Worked perfectly.