A lot of Ranet users need to integrate the pivot table into their ready applications, so when we developed it we tried to design the architecture that would allow developers to rewrite and add functionality to the solution according to their business needs. Still, certain issues may arise during the integration process. Thus, we decided to write an article describing the integration of Ranet Pivot Table into an ASP.NET application.

First, let’s create an ASP.NET project in Visual Studio. We used Visual Studio 2013 for this example, but the process will be just the same if you work in Visual Studio 2015. Besides, in VS 2015 you can develop the backend using ASP.NET Core, which will let you create a cross-platform solution that can be hosted not only on Internet Information Services.

We added Web API to the project, so all data in the project is transferred from the server through Web API.

ranet olap in asp net application

Then, download Ranet Pivot Table for HTML. This is a complete solution for analytical reports that is ready for deployment on IIS. It is also deployed on our demo server: https://bi.galaktikasoft.com/js/RanetOlap/

ranet olap archieve

After you’ve unzipped the files you need to rename the bin catalog to dll, and then copy the catalog in the web application’s directory (except the Global.asax file). Then add Assets folder and index.html file to the project.

solution-explorer-view

Now, add to the project a reference to Ranet.Analytics.PivotGrid.dll from the dll catalog.

adding-ranet-pivot-table

Now you can compile and run the project. If you’ve done everything correctly, you should see a web application similar to the app deployed on our demo server. The best way to make sure everything is correct is to check the database connection.

checking-database-connection

If you see such pop-up window, you’ve done everything correctly. In this case, you can rewrite the functionality we have included in Ranet Pivot Table the way you need. Users usually have various business needs they customize the component to – some need tо store the reports in the database (SQL Server, MySQL, PostgreSQL) rather than the file storage, others – to be able to filter the metadata tree the end users use to create reports, manage the view etc.

We hope this article will be helpful for you, and don’t hesitate to contact us in case you have any questions about Ranet Pivot Table for HTML5.