I'm using Reports module 5.0.2 on a DNN 5.01.02 installation. I'm fairly new at DNN and absolutely new with the Reports module. I've gone through the entire forum looking for the answer to my question, but any answers I found were not detailed enough for an absolute beginner with this module. What I need is to have the ability to display on a list, only the information pertaining to the logged on User. In the module I do see where I can elect something like this, but what would be displayed is any record that the user entered only. In my application, my office manager and accountant will both enter documents (yes/no) and financial information. The user ID column that we will enter matched the user ID from DNN. I just want to have it so that when a user is logged in, they can only see the records pertaining to them, although they were not the ones to create the records.

     On a few of the posts where a similar question was asked, I saw answers such as insert
WHERE UserId = @UserId

If this works, then this is great, but I need to know exactly where to insert this statement. I'm new to this module, SQL, etc. and therefore need really clear instructions on where this statement should go.

   So far I like the module and was able to easily set up my columns and also display forms and lists, but without the ability to isolate for viewing only the records that pertain to the logged on user, then I'm up the creek without a paddle. Again, the people that will be viewing their records are not the people who entered them.

Any help will be appreciated.