Thank you, I got it to work. To all of you who took time to reply and help, Thank you so much!

Unfortunately, I am building an extract to send to a third party, so the date in the table is in that format and is a string. The 3rd variable seems to at...

Your modified version is actually better....It even picks up Views!

Typo they say..... SQL isn't so forgiving about typos..it's called a syntax error. while these points aren't life or death they are a chance for us normal folk to answer...

The answer is wrong "currcmd" should be "curcmd". See: http://msdn.microsoft.com/en-us/library/ee320962%28v=sql.105%29.aspx

I finally found the solution to my Grouping Pane issue. I can't believe the the solution was simply that the panel needed to be enlarged.

Luis,

Thank you for taking the time to reply. While you didn't answer my question, you solved my problem anyway. I was trying to over complicate my...

Dwain,

I took the date compare from the original query that was submitted with the question. I didn't think the the dates with dots would...

I am not really sure what your question is. Is this what you are looking for:

John10.002013-01-15 00:00:001

John10.002013-01-15 00:00:001

John5.00 2013-02-03 00:00:001

John5.00 ...

Earlier, I said nothing happened when I opened the RDL in Report Builder, but I was wrong....The group DOES appear in the Grouping Pane. Joe

Sorry, I guess I had a senior moment, thought I answered you back....Nothing changed in Report Builder. Maybe it is a BIDS install issue

Yes, exactly....Thank you also for taking the time to respond and help...Joe Wolfe

I tried selecting everything under the sun and still no joy - Joe Wolfe

Thank you for responding to my question and I apologize for taking so long to reply back. I had to have some emergency foot surgery.

I am in fact adding...

Oh....much better.... I never knew that....Thank you!!!!