Search results for query: *

Nevermind. Now I see the "Parameter List" Window right there on the Add Command to Report box. Question answered Thanks so much for your help!

To quote you, Brian, "Notice the parameters are created within the CR command dialog. " I don't understand that comment. Am I missing something on the parameter creation? I created the {?StartDate} and {?EndDate} parameters as usual in the Field Explorer under Parameter Fields. I think I...

Whew! ignore that last post of mine. Back home, I was able to research and piece together a much better string of code that works from within Mgmt Studio and CR; select * from SYS_MFS_EMPLOYEES where CODE not in (select EMPCODE from PAY_TMDET where DATE between '2012-10-20' and '2012-11-4') I...

SQL is all new to me. But I need to learn. I am getting just a little confused by the EmpCode, which explains why the original developer created different field names for the data; "SYS_MFS_EMPLOYEES"."CODE" This is the Employee List, I am using the Employee Code "CODE" as the key...

I should point out that this report is for data in MS SQL 2008. And I can pass SQL command through CR if needed.

In CR 2011, I am trying to create a report that lists all Employees with no time entered for a Date Range. Two tables {Employees.EmpCode} and {Time.EmpCode} with a Left Outer Join. When I mix in the Parameter for Date Range {Time.Date} from the table on right, the LOJ no longer functions. I...