• I worked on a SSRS project which we converted it to web based from Windows based.

    to filter a report based on the user logged in , we added a column to the data table , so each row belongs to a particular group( US states for example ). using UserID report function to filter dataset.

    a lot of details , may be an eye opener for you.