I am trying to build a Web Part or utilize the web parts of Kentico to create something that looks like this:
I thought maybe I could create this with a Custom Table Data Source and then a grid and a custom control to handle the search filtering. Problem is that the query that loads the grid wont let me do any kind of stored procedure call to bring in the needed Lookup tables for things in the grid.
Then I thought I would use the grid in a custom web part and just handle how it loads but I cannot seem to find the web part in Visual Studio to load it. I can see custom table data source and Custom Table Form but not the grid. Any help and suggestions on how to pull off that as easily as possible would be great.