Okay, that seems to have worked. Thank you so much for your help and patience.

I've got to say I'm mighty discouraged, we seem to be going round n round about the same issue. The problem is: I do NOT get the five folders...

I did click "Report", NOT Report Wizard.

Steps: ->Right click 'Reports'

->Options available from menu:

Add New Report,

Add (submenu): New Item, existing item

Import Reports

Properties

If I select 'Add New Report'...

Following those steps still does not provide me with a dataset. I end up in a Report Wizard screen which has a Query Builder button and when I click...

Here are precisely the steps I have followed:

File->New ->BI Project->Report Server Project

•Named Project: SSC_Report, clicked ‘ok’

•Right click Shared Data Sources, selected Add New Data Source

•In Shared Data Source Properties I...

That resolves the problem, the values I am looking for don't exist in the PayDetail table.. Thank you for your assistance.

The whole query has char as the data type with the exception of 'rate' which is decimal

I didn't realize there was a forum specifically for newbies until after I posted my question in this one.

Thanks for the links, they are quite helpful.

Using this line: CONVERT(CHAR(11), MAX(CASE EP.ReviewType WHEN 'RES' THEN EP.ReviewDate END), 106) AS RespitePR

and removing the following line from the query: WHERE EP.NextReviewDate <'2014-11-30'

The query is now generating...

I'm afraid I don't know what you are asking me for.

Your explanation made sense, tried your suggested fix but am still not getting the most recent date. eg) emp 998 has a review date of July 31, 2014 but...

That works just by itself but I have two other elements - converting the date format and a second review date. I don't need to get the review date...