0
Answer

Dynamic Data Access Reporting using reflection

Matthew Owens

Matthew Owens

16y
2.8k
1

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

Next Recommended Forum