I stand corrected, John: right you are. My apologies. To recap, then, my understanding of the alternatives you face (leaving it with you to weigh the cost benefits) are:
(Doug's) run as is, relying on each user's security to restrict to the correct data, grouping by Project in case they click the report title and run it for "all"....but each client would need a Worker license
(Narayan's) Run As "you" with a prompt on Company which (fortunately) does restrict to the Requestor rights when run under a Project...but leaving all other client data exposed if they click the report title
(Duplication) copy the reporr for every company, hard coding the filter on each, and sending that report out (possibly via a Share as Public url) to each client...noting that for 100+ clients, the manual effort to set them up and send them out is not insignificant, not to mention the maintenance effort involved in then changing the view (etc) later when business requirements change
(Custom) consider our "http://store.atappstore.com/product/magic-reports/">Magic Report solution, which we could tailor to suit and ensure the data is protected (even using Requestor licenses)...but comes with some assembly required
(Longshot) continue to look for some other solution that will meet your requirements within Workfront's existing reporting feature set (eg Run As "you", but adding Smart Formatting on every column in the report to only show the data if the logged in Requestor's Company matches the Project's Company, and if not, shows Null)...noting that I just thought of that option now, have never tried it, and that it might not be possible
Pros and Cons abound. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand!
https://community.workfront.com/participate/unanswered-threads