Entering the date into a freeform textbox is going to be fraught with danger. Your perceived simplicity goes out the window when you try and ensure correct date entry. When...

Sounds like a syntax error. Do you have any other method of querying the database? Maybe a tool like Query Analyzer for SQL Server?

The reason I ask this is that...

In the case of the grouped item's name, can you put a textbox in the footer and then have it equal to the textbox in the body?

Best option is to build your own web page that uses the Report viewer control. Then you can format your parameter entry any way you wish.

Take a look at the...

Check the permissions assigned to the folder. By default only the BUILTIN\Administrators group gets access.

You will need some admin access in order to change the permissions.

And what's wrong with providing them with a pretty, purpose built web page to gather parameter information?

SRS isn't designed to create extract files, so why use it that way when...

A method I've used previously that works well is to have the developers use a SQL Server instance installed on their workstation which they have sysadmin privelages to. This stops the...

Why not try http://www.tpc.org 

Seems sort of obvious ... or is it just me ... maybe a google search or two would help

The *= is the Non-ANSI way of specifing a LEFT OUTER JOIN. If the operator was =* it would be a RIGHT OUTER JOIN. You should convert it to the...

Check the "Server Network Utility". By default MSDE only installs with the Shared Memory protocol enabled. You'll need to enable TCP/IP and/or Named Pipes before you can connect to it...

Why the need to use DTS?

Looking at Mike's first option, wouldn't a scheduled job to execute xp_sendmail (or my preferred replacement xp_smtp_sendmail) work just as well and with a lot...

The message looks like a SQL error, rather than a VBScript error. Try looking at profiler while this is running. You might find the problem there.

"And this behaviour is happening only this production database, on other databases it works fine."

This sorta rules out DTS and your stored procedures doesn't it? I'd start off by double-checking the...

You can't assign parameters for extended stored procedures the same way as normal procedures. I think its something to do with retrieving the metadata.

However you can work around it...

If you're running the eval version, then you can "upgrade" to the licensed version by just installing over the top. If the eval expires, best option is to uninstall before...