Using the hidden columns setting
The hidden column setting removes database fields from the report viewer dropdowns while still allowing the fields to be used in report creation and sorting in reports. In the example below, we want to hide the OrderID from dropdowns in Izenda, but still use it to join and sort in reports.
AdHocSettings.HiddenColumns = new string[] { "[dbo].[Orders].[OrderID]" };