According to the BOL any address will work.

BOL ... "The report server does not validate e-mail addresses or obtain e-mail addresses from an e-mail server. You must know in advance...

Sorry, I was speaking beyond my knowledge level. *grin*

This may help....

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=279460

Is your empID an int datatype?

Try

SELECT CAST (empID AS varchar(20)) + empName

Sergiy is correct, but to fix your issue after the fact....

I see two issues here, and keep in mind I'm only beginning to work with text and ntext fields..

1. ~STOLEN...

I knew there was an easier way [KH] ....

There may be an easier way, but this works....

select

dateadd( day, 0, cast( datepart ( month, dateadd( month, -18, getdate() ) ) as varchar(2) ) +

...

Karen,

I've come up with a way to do this in standard. Its rough and I plan on tidying it up, but we're using it at my company and it works.

You...

This is just a quick thought, but did you don't need "AND" in your IIF. And I think you left out the "1" in the line.

=IIF(Fields!Field2.Value = 0, 0, SUM(Fields!Field1.Value)...

If the serial number is not an issue, this works.

-----------

declare @I int, @rowcount int, @ctr int, @prod varchar(50), @lastprod varchar(50)

select

identity(int, 1, 1) as nDex,

1 as seq,

prodid,

subpartid,

subpartdesc,

subpartserial

into

#tmp

from

subparts

order...

Does the table PC have a column with the serial numbers?

I have a second table PC that has a ProdID, PC_SubpartDesc1, PC_SubpartDesc2, PC_SubpartDesc3, PC_SubpartDesc4

>> with the matching serial numbers1...

In your query convert the nulls to a date that you won't hit...

I.E.

select

field1,

field2,

IsNull( Date, '12/31/2999' ) as...

Another thing to keep in mind is that the more aggregation and grouping that is done through RS, the more time the report will take to run. You may want...

I would strongly recommend the "Hitchhikers Guide to SQL Reporting Services" There is a TON of information, and it's not a hard read!

Not only does it give samples using SOAP,...

If you set the "Cascade Delete Related Records" on the tables' relationship, this will allow you to Truncate them.