Printable View
Giving the ability to allow a user to create the a page he wants to view and access fields in a database they specify. And from my app call that page. Is this possible? If so where would be a good place to start looking on getting info on how to do this.
Are you talking about creating some kind of custom report based on what the user chooses.
You are looking to do ad-hoc reporting. I belive some reporting packages allow this funcitonality, but not sure if they provide it over the web. Check out the majore reporting softwre out there.
If you want to roll your own, you will have to build some kind of query builder for the user to build a query to execute against the database.
To display the results, just assign them to a datagrid, and it will display the results in a table format.
Not sure if I was clear enough on this matter. I will look into the Ad-Hoc that was recommended. This is almost gonna be like a script that an administrator would put together so that agents knows what to say. As well this will have to write back to the database. I have been able to get the page to create and get viewed by the agent. The only thing I am not sure about is, the code behind the page doing the database stuff is gonna be different for each page that is built by the end user.
Forgive me I am somewhat new to ASP. I have been working with VB.NET for over a year now though.