Dynamic Report Builder
-
Hello All, I've been tasked with the oh so fun requirement of building a dynamic run time report creator for clients. We basically need to show a small sub set of tables, and allow them to generate reports by picking what data, columns, ect they want in the report. Although it doesn't seem super difficult, I'm wondering if anyone has run across an article or tool that helps do this. I spent some time searching the boards and forums which had alot of reporting items, but not real examples of a basic little run time report generator. Any suggestions would be greatly appreciated! Thanks, Ryan
-
Hello All, I've been tasked with the oh so fun requirement of building a dynamic run time report creator for clients. We basically need to show a small sub set of tables, and allow them to generate reports by picking what data, columns, ect they want in the report. Although it doesn't seem super difficult, I'm wondering if anyone has run across an article or tool that helps do this. I spent some time searching the boards and forums which had alot of reporting items, but not real examples of a basic little run time report generator. Any suggestions would be greatly appreciated! Thanks, Ryan
-
Hello All, I've been tasked with the oh so fun requirement of building a dynamic run time report creator for clients. We basically need to show a small sub set of tables, and allow them to generate reports by picking what data, columns, ect they want in the report. Although it doesn't seem super difficult, I'm wondering if anyone has run across an article or tool that helps do this. I spent some time searching the boards and forums which had alot of reporting items, but not real examples of a basic little run time report generator. Any suggestions would be greatly appreciated! Thanks, Ryan
I don't have any tips or resources for you, but I had to do this same thing about a year ago. It started out as a simple app where the user would select the data tables and columns to see, then the users wanted the ability to write custom filters (custom where clauses for the select statements), and reorder the data, and group the data, and have embedded sub reports, and have static page headers and footers, etc, etc. It turned into a huge project. Good luck!
Don't blame me. I voted for Chuck Norris.