Search result

Fast Reports will be in Warsaw on .Net Developers Days again! Here's how it was in 2016 and we are excited to be a part of this event again! Thousands of developers, speakers and exhibitor: a must attend event! Learn more about .Net Developers Days here ...

Perhaps you have never used plug-ins for the report designer FastReport .NET. Then this article is for you. As you know, in order to display data from the database in the report, you need to create a connection to the data source. You can do this in the code of the user application or within the report itself. In the first case, you have to create a connection, send it to the report and register it in the report. Not the fastest way actually. However, it is much faster to connect to the data inside the report. Although, if you create ma ...

On-the-fly data aggregation of "flat" database tables is one of the first tasks faced by information system developers and their users. At the same time it is usually difficult to foresee the user needs in terms of data selection criteria (filters), dimensions in which the data needs to be aggregated (slices) and a list of aggregated fields (measures). The need of developing new SQL-queries and reports for each user request sometimes consumes time which could be better spent on information systems development. Thus the question arises how to give user an ability to create pivot reports without the help of a programmer? In the FastReports product line this task is handled by the FastCube component set. By connecting a data source to the FastCube pivot table we are getting a tool which allows dimensions, filters and measures managing. The next small example demonstrates how it is ...

The article is relevant until version 2022.1. FastReport .NET has a great tool for displaying data as an integrated table or matrix. Many of us would like to improve the functionality of matrices, for example, with such a useful option as a choice of N top values. It seems as simple as selecting the N top lines from a data source. However, besides making a selection of the top values, it is necessary to group all the rest data into a single recording, which is the main problem. This cannot be done with the built-in tools of the Matrix object. Thus, we have to prepare the data so that they contain both the top values and the sum of all the rest values. This means is suitable for SQL databases. Everything we need is to write an SQL query. Assume we produce a list of employees’ wages by years. In the data source editor, we may use an SQL query, if an SQL database is used. ...

Microsoft has recently launched a web platform called Blazor. This framework allows creating an interactive web interface with the C# language, as well as HTML and CSS. Blazor is highly demanded and rapidly gains popularity among many .NET developers. We have updated the FastReport.Web package, adding Blazor components for working with reports in web applications based on Blazor Server technology. These components are used in .NET Core 3.1 (and higher) and are in beta status and will be improved over time. Below we describe the creation of a simple web application based on Blazor Server technology. You can download this demo project in my profile at GitHub. To begin with, we create our new project. We will use a ready template for Blazor Server.  You can create a project with Visual Studio (both for Windows and for macOS) or with. ...

Speaking of the .Net framework, we usually imagine the #C programming language. Simply because the share of C# programmers is overwhelming. But we should not forget about other languages as well. For example, a user of the report generator from Stimulsoft wants to create a report from the application code in the VB.NET language: “…At this moment I just testing, I would like to create a report with code from VB. At this moment I am trying to show a report with the tittle that I program in VB. but not show me anything in my web application. Can you give me some guidance on how to do this would be possible to design the report from VB and it shows? Or if I'm omitting any instruction or object to make the report?..." https://forum.stimulsoft.com/viewtopic.php?f ...

Release of Visual Studio 2015 Preview includes new version of C# and VB.NET compilers called "Roslyn". Roslyn is a complete rewrite of C# and VB.NET compilers; if previously they were written in C++, now C# compiler is written in C#, and VB.NET compiler - in VB.NET respectively. Also Roslyn is fully open sourced and available on GitHub. When using the previous compiler, developer couldn't affect the compilation process. New compiler follows the idea of Compiler-as-a-Service: now it's a platform with API that allows the developers taking part in the compilation process. Read more     ...

FastReport Studio 4.7 released!• Added new demonstration program for Sybase PowerBuilder• Improved DrillDownd mechanism, should work correct with master-detail-subtetail nesting• Extened functionality of Vertical Bands• Extended interface of TfrxADOQuery object - added ability to dynamically set Master/Detail relation between SQL queries and dynamically set parameters of SQL queries.• Extended interface of TfrxReport object.• Extended functionality of build-in FastScript language.• Improved export abilites.• Improved compability with scripting languages like VB Script.• Fixed several demo programms.• Extended functionality of TfrxLineView object - now you can dynamically create LineView object and control its properties by external app ...