Hi,
I'm trying to get a report to only return data for the user that is running the report (windows authentication). I've taken the report from the K2 Report Designer into Visual Studio, I can access the UserId to display on the report (in a new column or text box), but I can't use it in the query (on the data tab) to compare against the dataset field. Any idea on the syntax to be used or how I build a WHERE clause using UserId?
many thanks
Andy