I found the exact syntax in a another unrelated sqlservercentral post once I figured out what the problem was.

replace

I'm still waiting on our email administrator.
However, I did find the problem and the fix.
Not that the error messages gave any indication as to what the problem was.

I checked the log file and found the message below.
The same user (myself) has other subscriptions that work  and email without a problem.
The report is actually being emailed...

Showing my age but in 1974 we actually had DST all year to alleiviate the energy crisis because of Arab oil embargo.
I was a kid but I remember walking...

Of course there will always be bugs. 
However, there is no excuse for production software containing negligent bugs.
It is impossible to find crazy outliers but I find myself frustrated...

Can you try running the query in SQLPLUS to resolve the Oracle syntax issues and then try openquery.

Sometimes the driver can send back bogus messages that might be obvious in...

Log on to sqlplus as sys

Create user sqluser identified by 'newpassword';

Grant connect to sqluser;

Grant dba to sqluser;

For the linked server log on as sqluser password newpassword and you will...

Who really cares if they are looking up the answer on the internet. The idea is to see how they would approach /solve a particular problem/solution. If they look it...

It is in preview mode on my PC that I am getting the error.

Both my workstation and the server I hope to publish it to are 64 bit.

Our user would like to be able to drill down to the detail. I could create subreports and filter the parent report. However, being that there are gigabyte and gigabytes...

I once ran into a similar problem with a stored procedure which worked really almost instantaneously in SSMS but took over a minute to return in crystal. I thought it...

Is there any performance gain for large tables in using except outside of a merge statement?

This is very simple subset of the data but I think it shows what I am looking for.

In the fourth quarter of 2011, employee 1000 would score a 2 and...

Thanks for the query but it gets sticky when the employee has multiple services over the same weekend. For example a service both on Saturday and Sunday would mean a...

The good news is that it is a standard quarter.

I'm working on putting together the ddl that I can post.