Again, sorry to sound stupid (the class was only 2 days, over a year ago), but how will I write the reports if SSRS is not installed on my workstation?...

I see 2 databases in SSMS called XXReports and XXReportsTempDB, should I delete these before I reinstall??? I am going to be the only one creating reports in SSRS...

Martin - Thank you for the information. I have confirmed that SSRS is installed both on the server and on my workstation. I have inherited this server...it appears...

That didn't work. When I open it, I get the option to enter the server name (which is correct) and click 'Find'. When I click on 'Find' is...

Yes, the service is running.

I believe the DB's were named SCAN. If I look in 'Services', after 'SQL Server Reporting Services' the word (SCAN) appears but there is no DB in SQL Server...

This was my first idea (and my preference) but I cannot get past the WMI error...any ideas on that???

I suppose I could do that...would it disturb any of the other live data that is on there??? My regular SQL dbs are constantly in use.

Wayne - Your suggestion works great too. Both return 481 records and they both generate the desired results of a report that will show me all active employees and...

Steve - Thank you, thank you, thank you!!! I removed the > from your statement as I need only yesterday's data, not today's and it worked great!!! I...

Wayne - Thank you!!! That is the answer I was looking for. CirquedeSQLeil, I'm sorry if I was unclear. My only experience with SQL up until a...

I see...that's what I thought. Maybe I did something wrong during the install or maybe there is something that I need to turn off to prevent this from happening...

Please forgive my ignorance but I don't know what you mean...what 'node'???

No...the query is

SELECT * from Table where ColumnName = 'Y'

I was able to get it to run by clicking on 'Debug' then 'Continue' on the menu bar. Is there some way to bypass the 'Debug' step??? I...