I tried that on the datasource and it did not help.

1. I'm using Windows authentication on the report data source.

2. I'm not sure about your second question. If I look at permission on the procedure, the owner is dbo; the...

Yes, I just created a simple report and it runs.

I think this has run through any upgrades and as I mentioned, we added SP2 today and that didn't change anything.

I...

I upgraded SQL Server to SP2 today in an effort to fix this but it didn't.

I'm on Visual Studio 2005.

I can't tell if my CPU maxes out--I don't have to...

I've worked on it for days, including today, and I'm stumped. The procedure runs in SQL Server but will not run in Reporting Services--not in an existing project; not in...

I've done that (2nd paragraph) and it won't run in SSRS. It just sits there. I even deleted that dataset and put in a new one (to the same proc)...

Thanks guys!!

Never mind. I got the syntax fixed, it runs and tests correctly. Thanks for the great referral.

I finally got it to work but not with the code on running balances that's on the Net. I definitely had to make some code changes to get it to...

Okay, I found code to get around that. Now it says my nonclustered index does not exist. But when I run my code again, it doesn't add either index and...

Strange, I'm not getting that error this morning. However, it's part of a larger piece of code. First time I run it, fine. Second time it says the table already...

This almost works:

ALTER TABLE [dbo].TransHist

ADD PRIMARY KEY CLUSTERED (RowNum)

CREATE NONCLUSTERED...

I'm back from vacation and working on this code again. I'm hung up on creating (or recreating?) the indexes. Here's a piece of my code. The error I get is...

Well, I have to say you're right. I tested over 300,000 rows and the report is taking way longer to run than the pure SQL. The reason I did it...

Let me try to sum up what you need.

1. The field that resets the running balance has to be in every row of the SQL that populates the report.

2. You...