Yes I have, that doesn't work either.

If you mean that the data that the report uses can reside on a SQL2000 server, that's correct. But you will need a SQL2005 box to store your RS database....

Why isn't it an option to run VS 2003? It'll work with 2005 side-by-side.

Is your report server running? Can you access http://localhost/reportserver using IE?

Set the format code of the textbox to d

I know how to add code to a report. However I cannot find any documented way to access the rows of a DataSet and loop over them. Anyone?

That would require writing sql code as well. Can anyone think of a way to to it all in RS, without writing any other queries or stored procedures? (Like Crystal...

What is the IIS error? Anything logged in the event log? What version of RS?

Yes, I know how do do this in SQL, but like I said, the data comes from a stored procedure so I need to do the manipulation in the report...

Yes, you can link to the report on the server and get it exported to pdf with a simple hyperlink (or a button)

An example would be:

Lets say you have a...

Brilliant solution,

Thanks!

This should get you started: http://msdn2.microsoft.com/en-us/library/ms169926(SQL.90).aspx

Here's some sample code that does what you need (in c#, but the methods are the same afterall) http://www.sqlmag.com/Article/ArticleID/48140/Reporting_for_Duty.html