Just did some more checking, and it looks like database has Auto Update Statistics set True, so this may not be an issue.

Vendor will bill us if something gets broken through our tempering, but the problem is that to get any kind of response from them takes an ungodly amount of proof...

It's possible for sure. The error has not been seen since it happened on saturday. I've checked logs periodically since then, and nothing like has appeared.

Just checked in Manage Schedule console, no record of schedule with that ID.

I've looked through the table, and it doesn't seem that any of the tasks have a schedule_id that's listed above. Perhaps this is why there was a warning in the...

I'm working with SQL 2008 (SP3). I've tried all the tables you've listed above, but neither one of them contain the schedule id that was reported by error log.

Les Cardwell (6/26/2012)

DROP TABLE #T;

CREATE TABLE #T(Col1 INT)

INSERT INTO #T

SELECT 1 UNION ALL

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 1

--SELECT SUM(DISTINCT(Col1)) AS 'Sum of...

Unfortunately, there is no way to fix the particular join to lose the duplicate values. I've checked every which way, and the tables I'm joining are only linked to each...

It's one field being multiplied by the other one to get totals. I do that in SQL, and then sum it in SSRS

Yes, just checked again, no option has been turned on. It seems like even if you make a report through wizard, and use grouping, you end up with a group...

Actually I found the problem. I was trying to create parameter drop down list from the same datasource as I was pulling the data from. Added another datasource and that...

Is there a way to break or disable forward dependencies for SSRS. I've got a report that has parameters, which don't really have anything to do with each other. Whenever...