Notice removed Draw attention by Notre1
    Bounty Ended with Jeroen's answer chosen by Notre1
    Notice added Draw attention by Notre1
    Bounty Started worth 100 reputation by Notre1
    Tweeted twitter.com/#!/StackSoftRecs/status/512036439526473728
4 more grammar and clarification fixes
source | link

I would like a web-based system where I can publish a SQL query and users can run it with the least amount of friction possible. Ideally, I wouldn't need to do much more than configure the data source and paste in the query.

Right now, I give users access to a SQL query by embedding it into Excel as a linked query and emailing the Excel file to them. I use the "Format as Table" option to format alternating rows with a different color schemes and enable column filtering, and auto fit the column width (with some manual adjustments for columns that are way too wide because of one or two outlying text fields). That's about all the "report" formatting I do; I'm looking for a web-based solution that approaches that level of simplicity.

The downside to using Excel for report distribution is that other users (or administrators) can't discover this query. Also, I can't make any changes or improve the query without re-sending the Excel file (and, even then, I don't know who else the file has been sent to). I'm looking for some sort of central repository to solve these sorts of problems.

I've setup some a couple of Pentaho Reporting reports, and, when using the Report Design Wizard for the initial setup, it isn't too bad, but it's a PITA to go back and make a modification like adding a column or adding a new group for banding. Maybe publishing a query directly using the Pentaho BA/BI Server is more along the lines of what I am looking for, but I never got that far when working through the various Pentaho tutorials.

If I were to try writing something like this myself I would probably try to use something like DataTables, SlickGrid, or Handsontable for displaying the data grid on the web page.

Requirements:

  • Support for simple tabular reports
    • Automatically format reports with good defaults
  • Can be open source (preferred) or commercial
  • Supported Data sources:
    • MS SQL Server
  • Web server or server OS required:
    • Any

Optional features:

  • User authentication
    • Ideally, RBAC that can integrate with MS Active Directory (AD) and utilize groups in AD
  • Export/download data grid to a CSV, XLS, or XLSX file
  • Basic graphing
  • Pivot tables
  • Support for running/viewing reports on mobile platforms like the iPhone 5c or iPad Mini
    • Responsive design that uses the maximizes the use of the available web browser resolution
  • Supported Data sources:
    • IBM DB2 on AS/400 (iSeries)
    • SAP NetWeaver ERP
    • Arbitrary ODBC data sources
    • Arbitrary JDBC data sources
    • MySQL
    • PostrgreSQL
    • MariaDB
    • Oracle
  • Web server supported:
    • MS IIS
  • Backend server programming language:
    • Python
    • Java
    • C#
    • PHP

I don't need:

  • "pixel-perfect" reports

I would like a web-based system where I can publish a SQL query and users can run it with the least amount of friction possible. Ideally, I wouldn't need to do much more than configure the data source and paste in the query.

Right now, I give users access to a SQL query by embedding it into Excel as a linked query and emailing the Excel file to them. I use the "Format as Table" option to format alternating rows with a different color schemes and enable column filtering, and auto fit the column width (with some manual adjustments for columns that are way too wide because of one or two outlying text fields). That's about all the "report" formatting I do; I'm looking for a web-based solution that approaches that level of simplicity.

The downside to using Excel for report distribution is that other users (or administrators) can't discover this query. Also, I can't make any changes or improve the query without re-sending the Excel file (and, even then, I don't know who else the file has been sent to). I'm looking for some sort of central repository to solve these sorts of problems.

I've setup some a couple of Pentaho Reporting reports, and when using the Report Design Wizard for the initial setup isn't too bad, but it's a PITA to go back and make a modification like adding a column or adding a new group for banding. Maybe publishing a query directly using the Pentaho BA/BI Server is more along the lines of what I am looking for, but I never got that far when working through the various Pentaho tutorials.

If I were to try writing something like this myself I would probably try to use something like DataTables, SlickGrid, or Handsontable for displaying the data grid on the web page.

Requirements:

  • Support for simple tabular reports
    • Automatically format reports with good defaults
  • Can be open source (preferred) or commercial
  • Supported Data sources:
    • MS SQL Server
  • Web server or server OS required:
    • Any

Optional features:

  • User authentication
    • Ideally, RBAC that can integrate with MS Active Directory (AD) and utilize groups in AD
  • Export/download data grid to a CSV, XLS, or XLSX file
  • Basic graphing
  • Pivot tables
  • Support for running/viewing reports on mobile platforms like the iPhone 5c or iPad Mini
    • Responsive design that uses the maximizes the use of the available web browser resolution
  • Supported Data sources:
    • IBM DB2 on AS/400 (iSeries)
    • SAP NetWeaver ERP
    • Arbitrary ODBC data sources
    • Arbitrary JDBC data sources
    • MySQL
    • PostrgreSQL
    • MariaDB
    • Oracle
  • Web server supported:
    • MS IIS
  • Backend server programming language:
    • Python
    • Java
    • C#
    • PHP

I don't need:

  • "pixel-perfect" reports

I would like a web-based system where I can publish a SQL query and users can run it with the least amount of friction possible. Ideally, I wouldn't need to do much more than configure the data source and paste in the query.

Right now, I give users access to a SQL query by embedding it into Excel as a linked query and emailing the Excel file to them. I use the "Format as Table" option to format alternating rows with a different color schemes and enable column filtering, and auto fit the column width (with some manual adjustments for columns that are way too wide because of one or two outlying text fields). That's about all the "report" formatting I do; I'm looking for a web-based solution that approaches that level of simplicity.

The downside to using Excel for report distribution is that other users (or administrators) can't discover this query. Also, I can't make any changes or improve the query without re-sending the Excel file (and, even then, I don't know who else the file has been sent to). I'm looking for some sort of central repository to solve these sorts of problems.

I've setup a couple of Pentaho Reporting reports, and, when using the Report Design Wizard for the initial setup, it isn't too bad, but it's a PITA to go back and make a modification like adding a column or adding a new group for banding. Maybe publishing a query directly using the Pentaho BA/BI Server is more along the lines of what I am looking for, but I never got that far when working through the various Pentaho tutorials.

If I were to try writing something like this myself I would probably try to use something like DataTables, SlickGrid, or Handsontable for displaying the data grid on the web page.

Requirements:

  • Support for simple tabular reports
    • Automatically format reports with good defaults
  • Can be open source (preferred) or commercial
  • Supported Data sources:
    • MS SQL Server
  • Web server or server OS required:
    • Any

Optional features:

  • User authentication
    • Ideally, RBAC that can integrate with MS Active Directory (AD) and utilize groups in AD
  • Export/download data grid to a CSV, XLS, or XLSX file
  • Basic graphing
  • Pivot tables
  • Support for running/viewing reports on mobile platforms like the iPhone 5c or iPad Mini
    • Responsive design that uses the maximizes the use of the available web browser resolution
  • Supported Data sources:
    • IBM DB2 on AS/400 (iSeries)
    • SAP NetWeaver ERP
    • Arbitrary ODBC data sources
    • Arbitrary JDBC data sources
    • MySQL
    • PostrgreSQL
    • MariaDB
    • Oracle
  • Web server supported:
    • MS IIS
  • Backend server programming language:
    • Python
    • Java
    • C#
    • PHP

I don't need:

  • "pixel-perfect" reports
3 more grammar fixing
source | link

I would like a web-based system where I can publish a SQL query and users can run it with the least amount of friction possible. Ideally, I wouldn't need to do much more than configure the data source and paste in the query.

Right now, I find the easiest way to give users access to a SQL query to embedby embedding it into Excel as a linked query and emailemailing the Excel file to them. I use the "Format as Table" option to format alternating rows with a different color schemes and enable column filtering, and auto fit the column width (with some manual adjustments for columns that are way too wide because of one or two outlying text fields). That's about all the "report" formatting I do; I'm looking for a web-based solution that approaches that level of simplicity.

The downside to using Excel for report distribution is that other users (or administrators) can't discover this query. Also, I can't make any changes or improve the query without re-sending the Excel file (and, even then, I don't know who else the file has been sent to). I'm looking for some sort of central repository to solve these sorts of problems.

I've setup some a couple of Pentaho Reporting reports, and when using the Report Design Wizard for the initial setup isn't too bad, but it's a PITA to go back and make a modification like adding a column or adding a new group for banding. Maybe publishing a query directly using the Pentaho BA/BI Server is more along the lines of what I am looking for, but I never got that far when working through the various Pentaho tutorials.

If I were to try writing something like this myself I would probably try to use something like DataTables, SlickGrid, or Handsontable for displaying the data grid on the web page.

Requirements:

  • Support for simple tabular reports
    • Automatically format reports with good defaults
  • Can be open source (preferred) or commercial
  • Supported Data sources:
    • MS SQL Server
  • Web server or server OS required:
    • Any

Optional features:

  • User authentication
    • Ideally, RBAC that can integrate with MS Active Directory (AD) and utilize groups in AD
  • Export/download data grid to a CSV, XLS, or XLSX file
  • Basic graphing
  • Pivot tables
  • Support for running/viewing reports on mobile platforms like the iPhone 5c or iPad Mini
    • Responsive design that uses the maximizes the use of the available web browser resolution
  • Supported Data sources:
    • IBM DB2 on AS/400 (iSeries)
    • SAP NetWeaver ERP
    • Arbitrary ODBC data sources
    • Arbitrary JDBC data sources
    • MySQL
    • PostrgreSQL
    • MariaDB
    • Oracle
  • Web server supported:
    • MS IIS
  • Backend server programming language:
    • Python
    • Java
    • C#
    • PHP

I don't need:

  • "pixel-perfect" reports

I would like a web-based system where I can publish a SQL query and users can run it with the least amount of friction possible. Ideally, I wouldn't need to do much more than configure the data source and paste in the query.

Right now, I find the easiest way to give users access to a SQL query to embed it into Excel as a linked query and email the Excel file to them. I use the "Format as Table" option to format alternating rows with a different color schemes and enable column filtering, and auto fit the column width (with some manual adjustments for columns that are way too wide because of one or two outlying text fields). That's about all the "report" formatting I do; I'm looking for a web-based solution that approaches that level of simplicity.

The downside to using Excel for report distribution is that other users (or administrators) can't discover this query. Also, I can't make any changes or improve the query without re-sending the Excel file (and, even then, I don't know who else the file has been sent to). I'm looking for some sort of central repository to solve these sorts of problems.

I've setup some a couple of Pentaho Reporting reports, and when using the Report Design Wizard for the initial setup isn't too bad, but it's a PITA to go back and make a modification like adding a column or adding a new group for banding. Maybe publishing a query directly using the Pentaho BA/BI Server is more along the lines of what I am looking for, but I never got that far when working through the various Pentaho tutorials.

If I were to try writing something like this myself I would probably try to use something like DataTables, SlickGrid, or Handsontable for displaying the data grid on the web page.

Requirements:

  • Support for simple tabular reports
    • Automatically format reports with good defaults
  • Can be open source (preferred) or commercial
  • Supported Data sources:
    • MS SQL Server
  • Web server or server OS required:
    • Any

Optional features:

  • User authentication
    • Ideally, RBAC that can integrate with MS Active Directory (AD) and utilize groups in AD
  • Export/download data grid to a CSV, XLS, or XLSX file
  • Basic graphing
  • Pivot tables
  • Support for running/viewing reports on mobile platforms like the iPhone 5c or iPad Mini
    • Responsive design that uses the maximizes the use of the available web browser resolution
  • Supported Data sources:
    • IBM DB2 on AS/400 (iSeries)
    • SAP NetWeaver ERP
    • Arbitrary ODBC data sources
    • Arbitrary JDBC data sources
    • MySQL
    • PostrgreSQL
    • MariaDB
    • Oracle
  • Web server supported:
    • MS IIS
  • Backend server programming language:
    • Python
    • Java
    • C#
    • PHP

I don't need:

  • "pixel-perfect" reports

I would like a web-based system where I can publish a SQL query and users can run it with the least amount of friction possible. Ideally, I wouldn't need to do much more than configure the data source and paste in the query.

Right now, I give users access to a SQL query by embedding it into Excel as a linked query and emailing the Excel file to them. I use the "Format as Table" option to format alternating rows with a different color schemes and enable column filtering, and auto fit the column width (with some manual adjustments for columns that are way too wide because of one or two outlying text fields). That's about all the "report" formatting I do; I'm looking for a web-based solution that approaches that level of simplicity.

The downside to using Excel for report distribution is that other users (or administrators) can't discover this query. Also, I can't make any changes or improve the query without re-sending the Excel file (and, even then, I don't know who else the file has been sent to). I'm looking for some sort of central repository to solve these sorts of problems.

I've setup some a couple of Pentaho Reporting reports, and when using the Report Design Wizard for the initial setup isn't too bad, but it's a PITA to go back and make a modification like adding a column or adding a new group for banding. Maybe publishing a query directly using the Pentaho BA/BI Server is more along the lines of what I am looking for, but I never got that far when working through the various Pentaho tutorials.

If I were to try writing something like this myself I would probably try to use something like DataTables, SlickGrid, or Handsontable for displaying the data grid on the web page.

Requirements:

  • Support for simple tabular reports
    • Automatically format reports with good defaults
  • Can be open source (preferred) or commercial
  • Supported Data sources:
    • MS SQL Server
  • Web server or server OS required:
    • Any

Optional features:

  • User authentication
    • Ideally, RBAC that can integrate with MS Active Directory (AD) and utilize groups in AD
  • Export/download data grid to a CSV, XLS, or XLSX file
  • Basic graphing
  • Pivot tables
  • Support for running/viewing reports on mobile platforms like the iPhone 5c or iPad Mini
    • Responsive design that uses the maximizes the use of the available web browser resolution
  • Supported Data sources:
    • IBM DB2 on AS/400 (iSeries)
    • SAP NetWeaver ERP
    • Arbitrary ODBC data sources
    • Arbitrary JDBC data sources
    • MySQL
    • PostrgreSQL
    • MariaDB
    • Oracle
  • Web server supported:
    • MS IIS
  • Backend server programming language:
    • Python
    • Java
    • C#
    • PHP

I don't need:

  • "pixel-perfect" reports
2 fixed grammar
source | link

I would like a web-based system where I can publish a SQL query and users can run it with the least amount of friction possible. I would like to like to not have Ideally, I wouldn't need to do much more than configure the data source and paste in the query.

Right now, I find the easiest way to give users access to a SQL query to embed it into Excel as a linked query and email the Excel file to them. I use the "Format as Table" option to format alternating rows with a different color schemes and enable column filtering, and auto fit the column width (with some manual adjustments for columns that are way too wide because of one or two outlying text fields). That's about all the "report" formatting I do; I'm looking for a web-based solution that approaches that level of simplicity.

The downside to using Excel for report distribution is that other users (or administrators) can't discover this query. Also, I can't make any changes or improve the query without re-sending the Excel file (and, even then, I don't know who else the file has been sent to). I'm looking for some sort of central repository to solve these sorts of problems.

I've setup some a couple of Pentaho Reporting reports, and when using the Report Design Wizard for the initial setup isn't too bad, but it's a PITA to go back and make a modification like adding a column or adding a new group for banding. Maybe publishing a query directly using the Pentaho BA/BI Server is more along the lines of what I am looking for, but I never got that far when working through the various Pentaho tutorials.

If I were to try writing something like this myself I would probably try to use something like DataTables, SlickGrid, or Handsontable for displaying the data grid on the web page.

Requirements:

  • Support for simple tabular reports
    • Automatically format reports with good defaults
  • Can be open source (preferred) or commercial
  • Supported Data sources:
    • MS SQL Server
  • Web server or server OS required:
    • Any

Optional features:

  • User authentication
    • Ideally, RBAC that can integrate with MS Active Directory (AD) and utilize groups in AD
  • Export/download data grid to a CSV, XLS, or XLSX file
  • Basic graphing
  • Pivot tables
  • Support for running/viewing reports on mobile platforms like the iPhone 5c or iPad Mini
    • Responsive design that uses the maximizes the use of the available web browser resolution
  • Supported Data sources:
    • IBM DB2 on AS/400 (iSeries)
    • SAP NetWeaver ERP
    • Arbitrary ODBC data sources
    • Arbitrary JDBC data sources
    • MySQL
    • PostrgreSQL
    • MariaDB
    • Oracle
  • Web server supported:
    • MS IIS
  • Backend server programming language:
    • Python
    • Java
    • C#
    • PHP

I don't need:

  • "pixel-perfect" reports

I would like a web-based system where I can publish a SQL query and users can run it with the least amount of friction possible. I would like to like to not have to do much more than configure the data source and paste in the query.

Right now, I find the easiest way to give users access to a SQL query to embed it into Excel as a linked query and email the Excel file to them. I use the "Format as Table" option to format alternating rows with a different color schemes and enable column filtering, and auto fit the column width (with some manual adjustments for columns that are way too wide because of one or two outlying text fields). That's about all the "report" formatting I do; I'm looking for a web-based solution that approaches that level of simplicity.

The downside to using Excel for report distribution is that other users (or administrators) can't discover this query. Also, I can't make any changes or improve the query without re-sending the Excel file (and, even then, I don't know who else the file has been sent to). I'm looking for some sort of central repository to solve these sorts of problems.

I've setup some a couple of Pentaho Reporting reports, and when using the Report Design Wizard for the initial setup isn't too bad, but it's a PITA to go back and make a modification like adding a column or adding a new group for banding. Maybe publishing a query directly using the Pentaho BA/BI Server is more along the lines of what I am looking for, but I never got that far when working through the various Pentaho tutorials.

If I were to try writing something like this myself I would probably try to use something like DataTables, SlickGrid, or Handsontable for displaying the data grid on the web page.

Requirements:

  • Support for simple tabular reports
    • Automatically format reports with good defaults
  • Can be open source (preferred) or commercial
  • Supported Data sources:
    • MS SQL Server
  • Web server or server OS required:
    • Any

Optional features:

  • User authentication
    • Ideally, RBAC that can integrate with MS Active Directory (AD) and utilize groups in AD
  • Export/download data grid to a CSV, XLS, or XLSX file
  • Basic graphing
  • Pivot tables
  • Support for running/viewing reports on mobile platforms like the iPhone 5c or iPad Mini
    • Responsive design that uses the maximizes the use of the available web browser resolution
  • Supported Data sources:
    • IBM DB2 on AS/400 (iSeries)
    • SAP NetWeaver ERP
    • Arbitrary ODBC data sources
    • Arbitrary JDBC data sources
    • MySQL
    • PostrgreSQL
    • MariaDB
    • Oracle
  • Web server supported:
    • MS IIS
  • Backend server programming language:
    • Python
    • Java
    • C#
    • PHP

I don't need:

  • "pixel-perfect" reports

I would like a web-based system where I can publish a SQL query and users can run it with the least amount of friction possible. Ideally, I wouldn't need to do much more than configure the data source and paste in the query.

Right now, I find the easiest way to give users access to a SQL query to embed it into Excel as a linked query and email the Excel file to them. I use the "Format as Table" option to format alternating rows with a different color schemes and enable column filtering, and auto fit the column width (with some manual adjustments for columns that are way too wide because of one or two outlying text fields). That's about all the "report" formatting I do; I'm looking for a web-based solution that approaches that level of simplicity.

The downside to using Excel for report distribution is that other users (or administrators) can't discover this query. Also, I can't make any changes or improve the query without re-sending the Excel file (and, even then, I don't know who else the file has been sent to). I'm looking for some sort of central repository to solve these sorts of problems.

I've setup some a couple of Pentaho Reporting reports, and when using the Report Design Wizard for the initial setup isn't too bad, but it's a PITA to go back and make a modification like adding a column or adding a new group for banding. Maybe publishing a query directly using the Pentaho BA/BI Server is more along the lines of what I am looking for, but I never got that far when working through the various Pentaho tutorials.

If I were to try writing something like this myself I would probably try to use something like DataTables, SlickGrid, or Handsontable for displaying the data grid on the web page.

Requirements:

  • Support for simple tabular reports
    • Automatically format reports with good defaults
  • Can be open source (preferred) or commercial
  • Supported Data sources:
    • MS SQL Server
  • Web server or server OS required:
    • Any

Optional features:

  • User authentication
    • Ideally, RBAC that can integrate with MS Active Directory (AD) and utilize groups in AD
  • Export/download data grid to a CSV, XLS, or XLSX file
  • Basic graphing
  • Pivot tables
  • Support for running/viewing reports on mobile platforms like the iPhone 5c or iPad Mini
    • Responsive design that uses the maximizes the use of the available web browser resolution
  • Supported Data sources:
    • IBM DB2 on AS/400 (iSeries)
    • SAP NetWeaver ERP
    • Arbitrary ODBC data sources
    • Arbitrary JDBC data sources
    • MySQL
    • PostrgreSQL
    • MariaDB
    • Oracle
  • Web server supported:
    • MS IIS
  • Backend server programming language:
    • Python
    • Java
    • C#
    • PHP

I don't need:

  • "pixel-perfect" reports
1
source | link