http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/33120.aspxWed, 15 Feb 2017 18:23:10 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:33120MikeB0http://forums.method.me/cs/forums/thread/33120.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=33120<p>I have a screen with a pivot report of sales data by customer.</p> <p>When seeing the report on the screen, results are filtered by the sales reps on the invoice (or shared sales reps). I assume this is just because of user permissions.<span id="mce_0_start" style="overflow:hidden;"></span></p> <p>However, when exporting the report, all sales reps are included<span id="mce_1_start" style="overflow:hidden;"> in the results. I&#39;d like the results filtered by sales rep.</span></p> <p>There is a minor issue though: over time, sales reps for certain customers have changed. So, a single customer can have multiple different sales reps over time. Each current sales rep has access to the old sales reps for their customers.</p> <p>So, this means I&#39;d need to &quot;build a seletion&quot; list based on user permissions. This is easy to do with a grid, but that option doesn&#39;t appear to exist for regular screen actions of for report filtering.</p> <p>How do I do this? I need to build a selection list from the logged in user of shared sales rep record IDs and then filter the report for export.</p>