Who is dotnet Report built for?
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.
Does your company have access to my Database?
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.
Can I create some Default Reports that all my clients need?
Does dotnet Report Builder work with any Database system?
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.
Can I download, print or export the reports?
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.
Is dotnet Report Open Source?
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.
Is dotnet Report similar to SSRS (Sql Server Reporting Services)?
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.
How do I integrate dotnet Report Builder in my Application?
Our reporting solution can be installed standalone or easily in an existing application using the nuget package. You just add it right in to your MVC Web Application Project through Visual Studio. See our knowledgebase for full details.
Is all the code contained in my Application?
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.
How does the Report Builder Wizard generate the Report?
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.
Can I White Label dotnet Report Builder and change style?
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.