Do you want the process to be automatic, which is what setting a Foreign Key to ON DELETE CASCADE will do or do you want to control it?

My understanding of ad-hos reporting using report builder and report models is that you should provide the user(s) with a report model that negates the need for any "advanced" sql...

This would actually be fairly simple as you would put the on failure action of the step to GO to Step "Email" and on the email step you set the...

Can you post what was successful for you? This will help others if they find this thread when searching for the same or similar problem.

I don't believe that there is a way to specify that you only want the page header suppressed when outputting to a specific format. I think it is an...

Steve Jones - Editor (2/24/2009)

---

Hey, I didn't delete anything. Heck, I miss half the posts and don't understand the other half. I figure I'll just drop random comments in here...

The issue appears to be in the Initial Catalog parameter. If you remove that from the connection string do you connect successfully?

As a side note, you should not be...

Actually if the column being compared to is nchar or nvarchar preceding the constant with N actually slightly improves performance as no implicit conversion has to take place.

There isn't a column in another level of the grouping that does not have the CanGrow property set to false and is thus causing the other textboxes to grow?

Can you run Profiler when you run the report and see what is being sent to the SQL Server?

The other thing I like to do is to not tie the...

Assuming you have a fixed # of columns you would just put in an expression that adds the values of all the prior columns:

=Fields!Marks1.Value + Fields!Marks2.Value

I don't know a way...

I've never seen this before and the only thing I can find on-line that might be helpful is this:

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/ad9bdf44-e492-4d7a-893e-abed5179bf2a/

but it specifically addresses SSRS 2008. You may want to take...

You should be able to do this. Are you getting an error? If so, what is the error?

I used to also recommend putting any email type activity into a table and having a separate job process it, but because database mail uses Service Broker it is asynchronous...

I don't know of a way to do this other than creating a job that checks the status of other jobs and uses sp_send_dbmail to send out an email for...