Kit G (9/27/2010)

---

steve-893342 (9/27/2010)

---

Kit G (9/27/2010)

---

Thanks Steve for the code. That date at Los Mules where...

Check to make certain the datasource has the appropriate credentials stored in it's definition.

-Luke.

Alvin Ramard (9/27/2010)

---

I use the GMail Reader. It's fairly simple to use and has one major advantage over Outlook. Since it's web based, you can access Gmail Reader...

Thanks for finally posting the version number. Sorry I assumed this was 2000 as that's what the largest majority of articles I could find on this error number...

Were you the one that originally created the procedure? IF not, and this is a SQL 2000 instance, you were not the owner, therefor you would have needed to...

Make sure the user you are using to connect to the database has permissions to that stored procedure. Also, depending on the version of SQL you are using make...

Kit, is the sample data representative of the data in your database in so much as there is no way to differentiate the 2 events with the exception of the...

Though I think you'd need to test this you could perhaps Add an explicit deny to execute sp_add_job for the particular user you are having issues with.

sp_add_job is...

I don't see any syntax errors in your SQL statement. Is it doing something you are not expecting, or throwing some sort of error message?

-Luke.

Does the execution log of the SSRS database give you any clues?

how about googling something along these lines...

SSRS known issues site:microsoft.com

Make certain that the user that you are connecting with has the appropriate rights on the share. That user needs modify or above on the share and write or...

Just out of curiosity, why not use SSIS instead to create the file,then you can invoke another process like the cmd line version of winzip, 7-zip or whatever you choose,...

tsmith-960032 (9/22/2010)

---

Daniel Bowlin (9/22/2010)

---

Try a CTE or temp table to get your DISTINCT then join that back to a SELECT where you query the data and constrain on the MIN...

The only thing to note is you should pay attention to what settings you set when you download the reports and create the solution. For example, if you upload...