Error: Expected End of Statement

I just don't see it (SSRS 2005 Expression Syntax Error):

=((Fields!PostedAmount_InHouse.Value + Fields!NewPDs_Check.Value + Fields!NewCCs_Check.Value) / Fields!CurrentPostingDay.Value) * (Fields!TotalPostingDays.Value - Fields!CurrentPostingDay.Value) + (Fields!PostedAmount_InHouse.Value + Fields!OldPDs_Check.Value + Fields!NewPDs_Check.Value + Fields!OldCCs_Check.Value + Fields!NewCCs_Check.Value) * Fields!FeeSchedule.Value)) / 100

Error: Expected End of Statement

4( + 6) = Error: Expected Endof Statement

Error while trying to use ReportServices 2005 WebService

I'm messing around with the SSRS 2005 WebService from a vb.net application. When calling the .ListChildren method I get the following error:

Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.

Here is the code I'm using (I called the webreference ssrs)

dim rs as new ssrs.ReportingService2005()

rs.url = "http://127.0.0.1/reportserver"

rs.credentials = System.New.CredentialCache.DefaultCredentials

dim items() as ssrs.CatalogItem

items = rs.ListChildren ("/", True)

The error is coming from the Visual Studio generated proxy. The issue is that when you override the .Url property you must specify the entire URL of the Reporting Services endpoint.

Change your URL string to http://127.0.0.1/reportserver/reportservice2005.asmx and everything should work then.

All of the various designers that we ship automatically append the appropriate web service endpoint. Unfortunately we do not control the code that is generated by the proxy that VS creates. You must ensure that the URL points to the endpoint yourself if you choose to overwrite the default URL that is assigned when the proxy is generated.

|||

Check your credentials...you got a typo

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

Error while trying to use ReportServices 2005 WebService

I'm messing around with the SSRS 2005 WebService from a vb.net application. When calling the .ListChildren method I get the following error:

Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.

Here is the code I'm using (I called the webreference ssrs)

dim rs as new ssrs.ReportingService2005()

rs.url = "http://127.0.0.1/reportserver"

rs.credentials = System.New.CredentialCache.DefaultCredentials

dim items() as ssrs.CatalogItem

items = rs.ListChildren ("/", True)

The error is coming from the Visual Studio generated proxy. The issue is that when you override the .Url property you must specify the entire URL of the Reporting Services endpoint.

Change your URL string to http://127.0.0.1/reportserver/reportservice2005.asmx and everything should work then.

All of the various designers that we ship automatically append the appropriate web service endpoint. Unfortunately we do not control the code that is generated by the proxy that VS creates. You must ensure that the URL points to the endpoint yourself if you choose to overwrite the default URL that is assigned when the proxy is generated.

|||

Check your credentials...you got a typo

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

Error While Exporting Data From a report which have SubReport. - D

Hi all,
i am facing a typical problem in SSRS.I have a report which have a
subreport.Everything working fine if i have data on my main report and my sub
report also,but if i don't have any data then report is giving a error when i
am trying to EXPORT it in some version(.xls or .xml etc).
Really i could not able to understand the reason behind this problem.
I am looking fwd for your quick reply rgd the same.
Thanks in advance.
DibakarOn Feb 26, 4:54 am, Dibakar <Diba...@.discussions.microsoft.com> wrote:
> Hi all,
> i am facing a typical problem in SSRS.I have a report which have a
> subreport.Everything working fine if i have data on my main report and my sub
> report also,but if i don't have any data then report is giving a error when i
> am trying to EXPORT it in some version(.xls or .xml etc).
> Really i could not able to understand the reason behind this problem.
> I am looking fwd for your quick reply rgd the same.
> Thanks in advance.
> Dibakar
I have come across this issue when I have not had data on my subreport
before. Have you tried returning an empty row to the main report (from
the subreport) yet?
Enrique Martinez
Sr. SQL Server Developer|||Yes, i am doing it.but still the same problem remains.
I don;t know how to solve it?Pls help
"EMartinez" wrote:
> On Feb 26, 4:54 am, Dibakar <Diba...@.discussions.microsoft.com> wrote:
> > Hi all,
> >
> > i am facing a typical problem in SSRS.I have a report which have a
> > subreport.Everything working fine if i have data on my main report and my sub
> > report also,but if i don't have any data then report is giving a error when i
> > am trying to EXPORT it in some version(.xls or .xml etc).
> >
> > Really i could not able to understand the reason behind this problem.
> >
> > I am looking fwd for your quick reply rgd the same.
> >
> > Thanks in advance.
> >
> > Dibakar
>
> I have come across this issue when I have not had data on my subreport
> before. Have you tried returning an empty row to the main report (from
> the subreport) yet?
> Enrique Martinez
> Sr. SQL Server Developer
>