Search Results for "report sql"

Application for reporting and data visualization with possibility to store queries (data sets for reports), settings of fields and parameters. Easy to use, universal, dynamic, desktop,Windows, lightweight application. Displaying of the list of reports to choose. It is used to query MS SQL database and presentation of data in the form of a report ( subtotals and grouping), Pivot Chart or Pivot Table. Can also be created a pure extract and after copy/paste can be manipulated in any spreadsheet. Easy to use,desktop, Windows, lightweight application. No need to install. If someone is willing to develop and joining the project, then will be made available the source code.

https://sourceforge.net/projects/in2sql Video for best usage https://rb.gy/tvl8lk This Excel Addin helps SQL analytic create an Excel report based on ODBC relational data. *Creates table base on data from a relational database *Generate a pivot report using the same external connection (1) *Some ad-hoc tools are available - like "keep only" and "remove only" *you can use the row limit option for exploring the largest dataset *The ODBC connection manager is available *auto-build query tool can create SQL select statement by using different database tables with matching them by column name * creating connections for PowerQuery news and updates -- change list -- v05 beta export tables and SQL to CSV files treat CSV like relational tables -- add Cloud ClickHouse Source resolve the problem with an untrusted source changed Sql Editor fixed behavior for "update rows"