Are you the only one managing the Report Server?  What OS is the Report Server running on?  It sounds like a Windows Firewall issue to me.

As far as I know there is no way to specify the delimiter for a CSV in reporting Services.  I mean the C in CSV does stand for COMMA.

Can you post how you are entering the email addresses?  Can you send email to these addresses from your email client?  It should send to valid smtp addresses.

I have never tried to embed javascript in the jump to URL in reporting services, but you might want to try putting a custom function in the Jump to...

Steve,

I encountered the same problem and could not find a solution within reporting services 2000.  I did manage to find a work around.  I set up the subscription in Reporting...

You could also issue a SET ANSI_NULLS OFF at the beginning of your query which would allow Null values to be evaluated using = and <>.

If you are only dealing...

Prashant,

I believe the ISNULL function is a T-SQL addition to ANSI SQL and COALESCE is an ANSI SQL function.  The COALESCE function takes a comma seperated list of values and...

Using Null in the IN clause will only work if you have ANSI_NULLS set to OFF.  If ANSI_NULLS is on you need to use Is Null or Is Not Null...

When was the SQL Server last restarted?  It sounds to me like the SPID in a Closed/RollBack state may be "hung" and the SQL Server needs to be restarted.  Running...

Yes, you are correct, if you only grant select on the view the user cannot modify data in the view.

Andras,

I read the article you lined to and I have a question about tempdb.  The article says, "For the TEMPDB database, create 1 data file per CPU, as described in...

Thanks Jim and Bob.

I spec'd out a Dell 64 bit server onpline and the server without Sql Server was $17K so I am pretty sure that won't fly, but I...

Thanks for the replies.  Here is what I am looking at as far as disk configuration goes (based on Inside MS Sql Server 2000):

Raid 1 drive for OS, Page File...

Found this article, http://technet.microsoft.com/en-us/library/ms141704.aspx, that might help.  It basically tells you how to convert data types in SSIS.  SO you can convert from DT_STR to DT_BYTES.  LIke this:

(DT_BYTES, 5) "GBMCU"

Hope...

I would definitely recommend SSRS if you can get 2005 and use the report builder + models as already suggested.  If you can't do that MS Acess comes to mind. ...