Resultado da pesquisa

What's news in our crossplatform reporting tool?   Use the opportunity to publish reports on the web - version FastReport.Mono 2013 allows to use the report generator conjunctly with  the Apache web server. You'll find the example of WEB reporting in the folder "Demos/C#/Web".   Do not limit yourself by using only the classic bar codes. In version FastReport.Mono 2013 added support of two-dimensional bar  code - QR-code. Using the QR-code allows to increase up to 100 times the amount of encoded information over traditional barcodes.   - added WEB reporting server - improved look of navigator of generated HTML documents - added "Data Only" property to Xlsx export (Excel 2007 and later version) - added new barcode - QR-code - improved look of RichText object - fixed bug in BusinessObjects data source ...

Previously, we already examined an example of displaying a printing dialog of a report in HTML and PDF formats. The aim of this article is to show how to save reports in the desired format, providing an example of Excel. We use the MVC web application. There is a button, which is provided to save a report. Add it to the web page Home. For this, open the Index.cshtml file in the Views folder.   Place the following code in the desired location: ...

We have already discussed how to send a report to a group of emails from the database. In this article we will do the same, but for a web application on the .Net Core MVC platform. Let me remind you that our task is to get a list of email addresses and user names from a certain database and, send emails with an attached report to these mailboxes. Let's use the MS SQL Server database.   Create an ASP application .Net Core MVC application. First of all, add the necessary libraries to the project using NuGet Packages Manager. In the general nuget repository we find and install packages: Microsoft.EntityFrameworkCore; Microsoft.EntityFrameworkCore.Relational; Microsoft.jQuery.Unobtrusive.Ajax; jQuery. From the local repository - the Nuget folder in the FastReport.Net installation directory, install the packages: ...

In this article I would like to draw your attention to an interesting property of the of the object Text. Clip property determines whether to display the text, if it goes beyond the boundaries of the object. If this feature is enabled, the text will be cut according to the boundaries of the object. If disabled - will be displayed in full, as if the object was stretched. Let's look at an example. Create a simple report. For example, I bring a list of product categories with pictures: Please note that the selected text object with the name of the category has a small size. I specifically disabled text wrapping (WordWrap property) for clarity. Preview the report:   As you can see, the names of the categories cut because of the small size of the text object. Now, set the Cl ...

In the second part of the article we will talk about the functions themselves, which are used to form values. The window function calculates the value from a set of data associated with the current row, that is, data from the same group, if Partition by is used. Conventional aggregate functions for grouping require the grouping of rows, thus losing the necessary unique information from the sample. Therefore, it is necessary to use two instead of a single request in order to have all the necessary data and the sum by groups. Window aggregate functions allow to achieve the same result in one query. Let me remind you that a window is a set of lines by which a function is calculated. The OVER instruction splits the entire set of rows into separate groups — windows according to the specified condition. Let's talk about the types of window functions. There are three groups of destination: • Aggregate functions: SUM (), MAX (), MIN (), AVG (). COUNT (). T ...

To create high-quality reports and correctly export them to different formats (PDF, Word, Excel, etc.), it is necessary to use the graphics engine. Since the earliest versions of the .NET Framework, Microsoft has used GDI+ and its wrapper as part of the System.Drawing library. FastReport .NET has long been using the same library to create beautiful and functional reports. The Mono team has developed their GDI+ version for Unix systems: libgdiplus, which is used by System.Drawing.Common. However, this method does not work perfectly. GDI+ problems Unfortunately, unlike on Windows, System.Drawing.Common works on other platforms very specifically. Such common issues that we receive from our users include incorrect rendering text sizes, lack of RTL language support, incorrect word spacing, word break error in sentences, lack of ARM processor support, and general libgdiplus instability (“Out of memory”, problems during the work in a multi-thr ...

Com a atualização 2022.1, FastReport Online Designer incorpora muitos novos objetos e funcionalidades que irão acelerar significativamente o processo de criação e otimização de seus relatórios. Novos objetos Novos objetos de "linha quebrada" e "polígono" foram adicionados: As linhas quebradas costumam ser usadas com mais freqüência para construir log ...

FastScript v1.97==============+ added support for Embarcadero Rad Studio XE+ added TeeChart 2010 support ...