Many web applications require some sort of reporting functionality. One of the most powerful frameworks for developing complex reports is Microsoft's SQL Server Reporting Service (SSRS). Webfuel web applications use SSRS to deliver complex reporting functionality for our clients.
Developing reports is quite a complex problem, and something that should be considered from the outset of a web application development project. After all there is no point in spending time and effort developing a database full of rich business information if you have no way to get the data out. It's important to consider the kind of reports that are required. Often it's only when thinking about the desired output from a web application that all the necessary inputs come to light. If you want to get data out of an application then obviously that data needs to be put in in the first place.
There are generally three phases to report generation. The first stage is specifying the report parameters. The second stage is taking those parameters and turning them into a query which will pull the required information from the database. The final stage is presenting this information in the format that the user wants. We use SSRS for this final stage.
With SSRS we can develop reports which can then be viewed on web pages (from desktop, tablet or mobile devices), or downloaded as PDFs, Excel spreadsheets or just raw data (CSV files). This allows our users to view the information quickly and easily online, and then if necessary get the same information in a format that they can process on their own PCs using spreadsheets or other tools.
Because SSRS is powered by Microsoft's industry leading SQL Server database it can produce reports based on millions of rows of data in a matter of seconds.
We can also develop applications that allow you to schedule reports to be run at preset times, and email them out automatically. Do you need a specific sales report running every Friday afternoon, or a monthly stock control report on the last day of each month? If so you can have these kind of reports delivered to your inbox without having to lift a finger. At the end of the day reporting is all about getting at your information with the minimum amount of fuss and effort.
Do you have data stuck in databases, or on spreadsheets, that needs to be set free with a suite of powerful reporting tools? If so then please give us a call to discuss what we can do to help.
When we undertake a template website build our process is a little different to a bespoke web design process. This blog post covers the steps we go through for a template website design & build process, from conception to launch. Step 1:
The world of open source software is experiencing a revolution. Traditionally open source has been the domain of the newcomer to the software market, or restricted to the worlds of Linux / Apache servers. But more recently the big boys
In the first part of this post we covered the e-commerce catalogue, variations and the payment gateway. In this part we look at the different features that can be built into an e-commerce store checkout. A e-commerce checkout is all
An ongoing debate in web design has been the scroll vs the click. Do users visiting a website prefer to scroll through a long page or click through to new pages? 2015 has possibly seen the demise of non scrolling websites, and