I want to build a portal page that shows a table that the user can filter dynamically, with two sets of picklist filters: one set to select which records will be shown across rows, and another set to determine which fields will be displayed down columns. (For simplicity let's say we're only dealing with one object without any grid mapping.)
As an illustration, with an object representing past sales of a company: the user can select from the first set to display sales from certain regions, or above a certain dollar value, or of a certain product, and then from the second set to determine that the fields displayed down the columns will be the ones related to financial information about the sale, or customer information, or product details.
I believe I should be building this with javascript components on a portal page, but before I go down that road too far, is there a better approach? Is there any way to use the built-in views or reports to do something like this?
Any suggestions will be much appreciated!
Thank you,
Greg
Thank you, Orchid. That is useful for the search function in our portal but not quite as flexible as I need for another view to be able to filter and access data dynamically. Would reports provide such functionality?
Thanks,
Greg
Thank you, Orchid!
Greg