This is directed to Remi Gregoire.  Can you explain why you should reassign the parameters inside the procedure?

I have done a similar report based on a date selection and I had to do it thru a stored procedure and parameter in my report. If you are using...

Thanks for the input.

I guess I knew that all along, I just didn't want to accept it. I'll try the identity thing. It just seems strange that I do get...

Try closing and disposing of the connection in the asp app.

Some are new files, others write over the same. I changed the time of one of the backups and that seems to have fixed it. The one that had a...

It is sql 2000 on windows 2003. The backups that are failing are of various types full and simple. They are complete backups. The error log just says that it...

Thanks that worked, but I was really hoping to get the columns parsed out on insert. I already have the code to parse the ##) from the front of each...

Ms Sql Reporting Services

Not perfect, but with work can usually accomplish what you want. Still fairly new, so not fully developed yet. I expect it to improve as new releases...

I assume you are talking about report server. If so, good luck, it's all in adjusting the margins to the right amount. I spent hours adjusting mine and finally got...

I have done this with the following

IBM400 = As400 Name

In following example as400 name and odbc data source are named the same

EXEC sp_addlinkedserver

   @server = 'IBM400',

   @provider...

Try explicitly disposing of the connections. Simply closing them is not good enough. It leaves the connections in sql as orphaned connections. Check the locks thru Enterprise manager and you...

Check your version of Excel, you must have the latest version of Excel 2000 or Excel 2003 to work with Reporting Services.

Okay, guess it's because I don't have any training on this, but how do you set the printer options programmatically before rendering.  I simply have created a report project and...