http://community.daptiv.com/search/SearchResults.aspx?o=DateDescending&tag=Data+Model,advanced+report+builder&orTags=0Search results matching tags 'Data Model' and 'advanced report builder'en-USCommunityServer 2007.1 (Build: 20910.1126)http://community.daptiv.com/forums/p/1519/3601.aspx#3601Wed, 04 Jun 2008 16:25:18 GMTa7c4c9a0-88c6-4d85-9ad8-684624c8041b:3601Ed Nixon<p>Not entirely sure what you are seeking so...</p> <p>You can use a (or multi-select) prompt to produce a specific (or list of) Enterprise Users &amp; EnterpriseMemberIDs.&nbsp; </p> <ul> <li> <div>REM: change the filter [Presentation].[Users].[Full Name] = ?Prompt? to [Presentation].[Users].[Full Name]&nbsp;in ?Prompt? with a multi-select</div></li></ul> <p>the following two fields can join Project and Enterprise User information:</p> <ul> <li> <div>Project Information--&gt;Project Member--&gt;IDs--&gt;EnterpriseMemberID</div></li> <li> <div>EnterpriseMember--&gt;IDs--&gt;EnterpriseMemberID</div></li></ul> <p>the following filter may be applied to a project query:</p> <ul> <li> <div>[Presentation].[Project Member].[EnterpriseMemberID] in&nbsp; ( [PromptQuery].[EnterpriseMemberID] )&nbsp; </div></li></ul> <p>I hope&nbsp;the above&nbsp;is helpful in getting to the report information you want.&nbsp; </p> <p>&nbsp;</p>