Just because I wasn't contributing anything to the discussion, it's wrong to presume that I wasn't following the discussion.

I actually considered helping when you posted your first message, but due...

"General network error"

This says it all. Basically there's been some sort of communication hiccup that's terminated the connection.

Well I've seen the discussion and I can't see anywhere in the previous posts where you've confirmed that SELECT @@SERVERNAME does not return null.

Actually, it should return the machine/instance name...

"I was not getting the right answer for my problem so i thinked those posters who dont go to replication menu should see this and can help me."

Your issue has...

You use Visual Studio.Net on the developers workstation to develop and deploy the reports, or as mentioned use the RS command-line utility.

Try

text1 + ISNULL(',' + text2, '') + ISNULL(',' + text3, '') etc...

Probably need to do some casting for non-char fields.

As Steve has said, Reporting Services uses the .Net Framework so you need that on the server. What you do not need on the server is the Visual Studio .Net...

Was there a problem with the response you recieved over here,

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=221429

If so, respond to the poster explaining the problem. You don't need to create a new post.

Also, have you run SELECT @@SERVERNAME on both servers and verified that the name is not set to null?

Have you looked through this KB article?

http://support.microsoft.com/?id=321822

When your deep in hell, the best thing I find is to roll everything back to the point where it's like nothing happened,...

What sort of database are you maintaining? How big is the database? How often is information added and removed? Does it need to be available 24x7, or do you have...

Please do not cross post, you already have a thread running for this problem, you don't need to create another.

This problem has nothing to do with Notification Services Administration. Please...

I still go back to my original posting,

"If the report is many, many pages long, then thinking logically, is the report useful? Would it be better seperated into smaller reports?"

I...

"It's a pretty big SQL statement from about 8 tables"

So does putting the query into a stored procedure help? What sort of formatting, etc... is in the report?

How much...

Never tried xp_sendmail with two queries. Try seperating them with the semi-colon statement terminator and see what you get.

Personally I stay away from SQL Mail, too much of a hassle to keep...