How to filter a lookup on EP form with Query


The existing lookup in Expense reports show a dimension hierarchy Lookup. i want to filter the lookup to show only set dimension’s lookup and not the entire list.

I suppose i would need to write a query at dataset level but not sure how to .

if anyone who could help me with EP customisations.


Maybe this blogpost can help you: Advanced filtering on a Dynamics AX Web Form published in a SharePoint environment.



Design Code (Markup Lang Code)


<asp:TextBox runat=“server” ID=“SearchClient” ToolTip=“Enter the contents to search”></asp:TextBox>

<asp:Button ID=“SearchButton” runat=“server” Text=“Button” onclick=“SearchButton_Click” />

<asp:TextBox runat=“server” ID=“TextBoxFilterCustAccount”></asp:TextBox>

<dynamics:AxLookup ID=“AxLookup3” runat=“server” OnLookup=“Customer_LookUp” TargetControlId=“TextBoxFilterCustAccount”>


<asp:Label ID=“ErrorMesg” runat=“server” Visible=“False” Font-Bold=“True”


Buddy the question has been framed wrongly.

Customization needed to be done on the dataset level should replicate Dimension Hierarchy if set to Active.

The lookup of Financial Dimensions should replicate the hierarchy executed in Ax.