I am writing a sales report and only want the sales persons to see there sales report, so I have set up a column that stores the sales person NTLOGIN so....SalesNet/JDOE. Then in the data portion of the Report look like this:
Select * from JulyComm where AELOGIN = User!UserID
Getting errors:
Incorrect syntax near '!'
Any ideas???
Should I be approaching this differently perhaps in a filter....how is that done?
Select * from JulyComm where AELOGIN = User!UserID
Getting errors:
Incorrect syntax near '!'
Any ideas???
Should I be approaching this differently perhaps in a filter....how is that done?
