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: [BC30260] 'EH_Application' is already declared as ...

This is the message: An unexpected error occurred while compiling
expressions. Native compiler return value: â'[BC30260] 'EH_Application' is
already declared as 'Class EH_Application' in this class.â'.
I modified an old report and I'm trying to build it, but VS give me that
error.
What is the problem?
Help me please.
Thx
Marco RizziTesting the update ...
I found that the error is generated only in one table when I put this code
into backgroudColor:
=IIf((RowNumber("table9") Mod 2), "White", "WhiteSmoke")
I already used this code in other tables and it works well.
"Marco Rizzi" wrote:
> This is the message: An unexpected error occurred while compiling
> expressions. Native compiler return value: â'[BC30260] 'EH_Application' is
> already declared as 'Class EH_Application' in this class.â'.
> I modified an old report and I'm trying to build it, but VS give me that
> error.
> What is the problem?
> Help me please.
> Thx
> Marco Rizzi
>|||Now I renamed the textbox in the table and it works well.
Now my question is: Why do I need to renamed the textbox?
"Marco Rizzi" wrote:
> Testing the update ...
> I found that the error is generated only in one table when I put this code
> into backgroudColor:
> =IIf((RowNumber("table9") Mod 2), "White", "WhiteSmoke")
> I already used this code in other tables and it works well.
> "Marco Rizzi" wrote:
> > This is the message: An unexpected error occurred while compiling
> > expressions. Native compiler return value: â'[BC30260] 'EH_Application' is
> > already declared as 'Class EH_Application' in this class.â'.
> >
> > I modified an old report and I'm trying to build it, but VS give me that
> > error.
> > What is the problem?
> >
> > Help me please.
> > Thx
> > Marco Rizzi
> >

ERROR: "Subquery returned more than 1 value."

I've got a big procedure written by a contractor. I'm trying to
execute it (against a test db until I get it worked out) and there is
one section of it that fails. I've isolated the section and run it in
Query Analyzer and it still fails. Here is the SQL:
DELETE FROM tblBedOccupancy WHERE (
ContactID IN (
SELECT ContactID FROM tblPeople WHERE Community IN (
SELECT DISTINCT BuildingID FROM lnkCompaniesBuildings WHERE CompanyID
<> 61
)
)
)
The error returned is:
Server: Msg 512, Level 16, State 1, Procedure tg_DeleteOccupancyRecord,
Line 18
Subquery returned more than 1 value. This is not permitted when the
subquery follows =, !=, <, <= , >, >= or when the subquery is used as
an expression.
The statement has been terminated.
If I change DELETE to SELECT *, it runs fine. If I run the subqueries
they run fine. How can I get this to work?
Thanks,
Josh D> The error returned is:
> Server: Msg 512, Level 16, State 1, Procedure tg_DeleteOccupancyRecord,
> Line 18
> Subquery returned more than 1 value. This is not permitted when the
> subquery follows =, !=, <, <= , >, >= or when the subquery is used as
> an expression.
> The statement has been terminated.
Look closely at the error message. Did you notice the name
"tg_DeleteOccupancyRecord". What does this refer to? Looks like a
trigger - and a poorly written one to boot. The problem is the code in the
trigger.|||I'd agree with Scott, sounds like you have trigger written by someone who
didn't realize that triggers fire once per statement, not once per row.

> Server: Msg 512, Level 16, State 1, Procedure tg_DeleteOccupancyRecord,
> Line 18
> Subquery returned more than 1 value. This is not permitted when the
> subquery follows =, !=, <, <= , >, >= or when the subquery is used as
> an expression.
> The statement has been terminated.|||> I'd agree with Scott, sounds like you have trigger written by someone who
> didn't realize that triggers fire once per statement, not once per row.
...and if that was the contractor, this might constitute breach of contract
.
:)
ML|||> ...and if that was the contractor, this might constitute breach of
> contract.
> :)
Well, if the contractor's side of the agreement doesn't explicitly state, "I
know what I'm doing"...|||> Well, if the contractor's side of the agreement doesn't explicitly state, "Id">
> know what I'm doing"...
In continental law the "I know what I'm doing" part is presumed (praesumptio
iuris), and the contractor can only limit his own liability by stating the
opposite.
ML

error with subquery.....

I am getting an error from a query that that has a subquery.

Msg 512, Level 16, State 1, Line 2

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

(0 row(s) affected)

This is a the query.

select *

from dhcp

where nameofcomputer = (SELECT p.nameofcomputer

FROM v_Pams_DHCP p

Left Outer Join adat2005_main a

ON p.nameofcomputer = a.nameofcomputer

where a.serialnumber is null)

Thanks in advance.

Gene

Use in operator,

Code Snippet

select

*

from

dhcp

where

nameofcomputer

in (

SELECT

p.nameofcomputer

FROM

v_Pams_DHCP p

Left Outer Join adat2005_main a

ON p.nameofcomputer = a.nameofcomputer

where

a.serialnumber is null

)

Exists Might be faster than IN,

Code Snippet

select

*

from

dhcp

where

Exists

(

SELECT

p.nameofcomputer

FROM

v_Pams_DHCP p

Left Outer Join adat2005_main a

ON p.nameofcomputer = a.nameofcomputer

where

a.serialnumber is null and p.nameofcomputer = dhcp.nameofcomputer

)

error with assebly

On preview custom assebly returns correct value - works OK, but on server i get an error like "#Error". Is it possible to debug report on server?
Thanks.Your custom assembly may not have permissions to do what you want it to do.
You'll need to edit the rssrvpolicy.config file and give it appropriate
permissions. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_8mue.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:4AE2405E-5DB7-4B48-82B8-4F8846112038@.microsoft.com...
> On preview custom assebly returns correct value - works OK, but on server
i get an error like "#Error". Is it possible to debug report on server?
> Thanks.
>

Error while executing reports from report manager

Hi..

I have deployed reports on to the report server. When I try to open the reports from report server, I get the error," Value does not fall within the expected range." This error message appears as soon as I click on any report on the report manager.

I am not able to find the cause of the error.

Does anybody have any suggestions?

Thanks ,

Viva

Viva1

Try checking your C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\web.config and make sure you have the below settings:

<appSettings>
<add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<add key="ReportViewerTemporaryStorage" value="Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</appSettings>

Ham

|||

Hi.

Thanks for your reply. I checked the web.config.. It has the settings that you have specified.

Still it does not work.

Any other suggestions for the problem?

Viva

|||

Viva1

In the directory C:\Program Files\Microsoft SQL Server\MSSQL.1 is a logfile directory for Reporting Service. In this directory, is a reporting service application log file and normally contains a more descriptive error message. It would be helpful to know what its contains.

Ham

|||

Ham,

Thanks for that. I shall take a look into that file and try to find out the issue.

ViVa