Dynamic Reporting System Using Reflection

Sep 11 2008 11:45 PM

Hey,

I have a database which holds thousands of relational records regarding financial information. This information can easily be pivotted to give us reports of various forms. We have a reporting system written in asp.net but the pages are static and generally not very scalable. I'd like to introduce a method where by the report elements (filter elements such as drop down lists etc) are held within a table in the database and then constructed on the fly when a report type is chosen. The problem I have is that the drop down lists for these reports need to have event handlers defined dynamically, ideally with code taken from a field in the database.

Is this even possible? I am very familiar with reflection, but not executing and compiling code that is stored within a database record

Thanks in advance

M


Answers (1)