That was a sample url. You will need to develop your own program. Do a Google search on "vb.net automate Outlook". Publish your vb.net program to a web...

This link may help: http://social.msdn.microsoft.com/Forums/en-US/65ca2e17-1ca1-4e02-aaac-389442f92cee/get-differance-of-two-columns-in-tablix?forum=sqlreportingservices

My guess is that you are hitting a limit on the body size using mailto. I do something similar to what you are attempting; however, I use a hyperlink...

Did you check the Reporting Services error log?

Here is the create table and inserts. The desired output is in the original post. Thanks.

If Object_ID('tempdb..#Orders')Is Not Null

Drop Table #Orders;

Create Table #Orders

( ItemNoVarchar(15)

, DueDateDatetime

, ChamChar(1) )

Insert Into...

Resetting Internet Explorer to default setting fixed it.

I always get best results when doing division using custom code. Here is an example:

Public Function CalcRatio(ByVal Numerator As Object, ByVal Denominator As object, ByVal DivZeroDefault As Object)...

I've read that web services can be called from T-SQL in a stored procedure. Perhaps you can put your error handling there?

Yes. I mean one stored procedure that combines data from your three databases. I use stored procedures almost exclusively in my reporting. You will need to use...

As an alternative, have you considered combining the data from the three databases in a stored procedure and using just one SSRS dataset?

Check if all reports are using a shared schedule.

Brian,

Your report path still does not look right. Try ReportServer?/System/Finance Reports/TestReport

I'm hardly an expert at this, but typically I use dimension attributes as parameters instead of fact table keys.

Brian,

The answer to your report parameter question is in the link your provided. Look at Figure 7 - Supply Report Parameters.

For server name enter just the name of the server without any path or aspx page.

For report path enter: ReportServer?/System/Finance Reports/Invoice

Thanks, but restarting the Distributed Transaction Coordinator did not end the processes. I resorted to a server reboot since the server is also running Reporting Services.