Hello All -
I am in the process of building a form for an application that will allow the users the ability to create their own queries. The form will have a list box showing all available tables. When a user selects 1 or more tables the field(s) for each table will be shown in another list box (cascading set up) where the user will then pick combinations of fields. I also want to have a section when users can add search criteria by combo box and filter the report on any of the fields...
I was wonding if anyone has set up or seen something similar to this and had any advice or if anyone has seen a demo that might possibly assist in my design...? The reason for this little side project is because of the miscellaneous report you (read: client) can never think of during the project development lifecycle and then wants after everything is nice and finished... I want to give them a way to create their own tailored reports without giving them the keys to the city so to speak...
look forward to all replys,
Kev
I am in the process of building a form for an application that will allow the users the ability to create their own queries. The form will have a list box showing all available tables. When a user selects 1 or more tables the field(s) for each table will be shown in another list box (cascading set up) where the user will then pick combinations of fields. I also want to have a section when users can add search criteria by combo box and filter the report on any of the fields...
I was wonding if anyone has set up or seen something similar to this and had any advice or if anyone has seen a demo that might possibly assist in my design...? The reason for this little side project is because of the miscellaneous report you (read: client) can never think of during the project development lifecycle and then wants after everything is nice and finished... I want to give them a way to create their own tailored reports without giving them the keys to the city so to speak...
look forward to all replys,
Kev
