Search result

When creating a SQL database connection, you can specify a query to select filtered or combined data. The standard tools of the data source creation wizard also allow you to include parameters in the SQL query. In this case, the designation of the parameter will depend on the type of DBMS to which the connection is made. For example, for MS SQL parameter in the query has the prefix @. And for the Access database instead of the parameter the symbol "?" is indicated. If there are several parameters, they will be inserted into the request according to the order in the list of parameters. Suppose we have created a connection string to the MS SQL database. The next step is the selection of tables:   At this stage, we can create a SQL query using the Add SQL query ... button. The result of the future query will be saved in the table. It is required to set the name of the ...

When making the report, we want it to be "friendly" to the consumers as much as possible. Too much data and design elements processing makes people's understanding of information more unfavourable. As a result, many people want to delete spaces in a table without data. FastReport.Net report generator allows you to perform this function. As you understand, it is necessary not only to hide the column, but also a title for it. If hiding a column is a matter of a couple of clicks with a mouse, then hiding the title task is not trivial. Suppose we have a table from which we want to display the data in a report. However, some data may be missing or set to zero. In this case, we can use the “Conditional Selection” tool to hide zero-data cells. Select the desired cell and click on the icon on the toolbar:   When you add conditions, by default there will be a ...

Probably many have encountered the problem of using a CSV file as a DataSet in Delphi. Let's have a look at  one of the solutions to this problem. We will connect the CSV file via TADOQuery and build a report from this data in FastReport VCL. Create a project and add the following components. ...

We have added a new import function from JasperReports. To use it, go to the "File" menu in the FastReport .NET designer and select "Open ...". In the window that appears, select the filter "JasperReports files (*.jrxml)". The selected file will be automatically converted to a FastReport .NET report and opened in the designer. The resulting imported report may have differences, and most likely, you will have to finalize it — change the properties of objects and add connections. JasperReports "Table" objects w ...

A set of tools for creating reporting infrastructure for .NET business applications ...

Fast Reports has won the following award in the DevProConnections Community Choice Awards: Best Vendor Support: Bronze ...

Do you store COVID-19 data in Excel? Can the report show not all data? Here - https://uk.news.yahoo.com/missing-coronavirus-tests-glitch-large-excel-spreadsheet-file-095054235.html - you can read a wonderful story about how almost 16,000 cases of Covid-19 infection were left out in the UK because the Excel spreadsheet ran out of space. If you are lazy to google, let me remind you that the limit of an Excel spreadsheet is 65,000 lines. These are not isolated cases! People have no idea how much data they and their customers will have to dea ...

...

  In the new version of FastReport FMX, we added FmxLinux support so now you can build your application with FastReport FMX on Linux. Learn how to install and use FastReport FMX 2.8 for FmxLinux in our blog This version also improves work with the latest versions of macOS Big Sur and applications that have passed notarization. On top of that, we added packages for Embarcadero RAD Studio 10.4 and made general improvements. ...