dotnet Report Builder has many uses. It is primarily for programmers or software vendors who want to add Ad-Hoc Report Generating capabilities within their Software Application.
If your clients keep requesting new Reports, and your programmers have to code and create it for them, dotnet Report Builder can save your Company time and money by allowing Customers to generate most reports on their own. If you use SSRS (SQL Server Reporting) or other services that charge by CPU cores, you can avoid expensive licensing fees.
dotnet Report Builder can also be used for in house Database or a single Application for the same purpose, to easily create Reports.
No, we do not at any time need access or have access to your database or it's records. You do have to setup some basic information about your database schema in our Admin section, which we have access to and our system uses to generate SQL statements for the Reports. However, those SQL statements are executed inside your application, and we we never have access to your database connection.
dotnet Report Builder generates standard SQL Statements, so it can work with any SQL database. The default code is for .Net's Microsoft SQL Server Provider, but it can be easily changed to use .Net's Oracle or Access provider, or to the standard ODBC Connection Provider. Most of our clients use MS SQL or MySQL.
Yes, you can Download the report in Excel or PDF, and print it also. The report data is available in your code base in a SQL data table, so you can code export methods in your application if needed.
The front end code is open source, and complete C# and JS code installs with the nuget package. This code is for the Report Designer and the Report itself, and you can make some changes to it per your requirements. However, the Service code is not open source and is not available to the Developers.
dotnet Report takes a completely different approach to SSRS and other similar solutions like Telerik Reporting or Active Reports, where the developer has to code a stored procedure and then design each report from scratch. Our Ad Hoc Reporting solution takes a very different approach, where you can easily add our intuitive and friendly report builder in your Enterprise Software Application, and then your developers or users can design the reports inside dotnet Report. See this article for more details.
The nuget package adds the Wizard Code and the Report View code to your application, but the code for the Database Schema information that sets up the Wizard, the Load/Save Report functions and the SQL statement generator is on dotnet Report Builder's hosted and secure Web Service. The Report wizard code sends and receives data to and from this Web Service.
After the user has chosen all the steps in the Wizard, the steps data is submitted to dotnet Report Builder's Web Service, and it evaluates and returns an Encrypted SQL statement back. This Encrypted statement is passed to the Controller in your code, where it's Decrypted and Executed using ADO .Net SQL Command.
Yes, you can definitely use your own Company Name or Logo when using dotnet Report Builder. The Ad Hoc Report Builder Wizard is just HTML that resides in your application. You can easily change the styling and layout by changing the css style and html markup. You can also add or change wordings or instruction
My table contains data records for all my clients, but I don't want clients to see each others data. Can Report Builder handle that?
Yes, dotnet Report support multi tenant clients. You can specify an Account or Client field, and then set that value in your Account Setup, and it will always be filtered in the where clause.