I have released a new free module (beta) where all features should be working. See description below. I am looking for a few testers and then will release a final version. I have only tested it in 7.3.x. It might work in lower versions. It requires .NET 4.0. I am open to suggestions and new features as long they don't require major work. I would like to be done with the final version soon. The module is free and will stay free. Once finished, it will be in the DNN store.
Demo: http://www.tactibit.com/dnn/GridRe...
Download: http://www.tactibit.com. No registration required. The zip is 26M (see special instructions for upload size limit below)
Support/bug reports: Through forums on the site. I am discouraging email. Please share with others.
Documentation: GettingStarted.txt file the zip file. It's also in the module's documentation folder after installation.
Description:
GridReport is used to display data coming from the result of any stored procedure. You create any type of a single result set of stored procedures. You can use any number and type of parameters to the stored procedures. You define each stored procedure as a report in a table. The web page displays these reports in a drop down. Once you select a report, a dynamic form is generated for the report's parameters where a user can enter values for filtering the data. In the web page you can export the grid to an Excel spreadsheet. You can also group on a column and export the grid's grouped data to Excel where each group's data resides in its own worksheet in the spreadsheet.
Special instructions for installing large modules:
The default DNN upload size limit is 12M. Because GridReport zip file is larger than 12M, you have to do one of these two options:
1- Increase the size limit in web.config file. In the httpRunTime section, change the two 12288 values to anything larger than 26M. 30288 works.
2- or upload the zip file to your DNN's Install/modules folder using ftp or your host's file manager and put the zip file in the modules folder. Then browse to your DNN installer url. Example: http://www.YOURDOMAINNAME.com/install/install.aspx?mode=installresources. This will install the module. Don't forget to delete the file when you're done.