The DnnBro Sql2Table module is available in the Dnn Store.
It has been built primarily for my own purposes - I use it for almost anything, whenever someone from either my own or another department requests both simple and complex data that I have to fetch from the database.
The module supports MsSQL server using either free text SQL or a stored procedure. Column names are deducted from the select statement.
The result can be downloaded as a CSV file for further work - filtering, sorting etc.
This is a good alternative to sending out spreadsheets with an sql connection inside - as this module keeps your sql connection string internally - the output is just a static file with no connection to the database.
For more details please refer to the Dnn Store - https://store.dnnsoftware...ils/dnnbro-sql2table - or view the demos at https://dnnbro.com
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.