logo
small logo
  • Products
  • Comprar
  • Suporte
  • Articles
  • Customer panel Suporte
    • en
    • pt
    • es
    • de
    • pl
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • How to use SQL queries when creating an internal report data source in FastReport.Net report designer
  • Geração de relatórios com PostgreSQL em um aplicativo .NET 5 com Debian 10

    25 de maio de 2022

    Muitos precisam de uma solução que irá gerar relatórios em sistemas Linux e também irá

    read more
  • Customizing the report designer

    31 de maio de 2020

    Report designer is replete with lots of features that many users do not use. Sometimes

    read more
  • Aprimoramento na interface da árvore de relatórios no designer FastReport

    5 de setembro de 2021

    Melhoramos as árvores de relatórios e dados no FastReport .NET e no designer Mono a

    read more
  • Como usar a régua no editor RichText para FastReport.NET

    16 de março de 2022

    Ao editor RichText foi adicionada uma régua. A presente régua permite que os usuários

    read more
  • Plugin para importar dados de .XLSX em FastReport .NET

    16 de março de 2022

    Com o lançamento do FastReport .NET 2022.2 foi adicionado um plugin para conexão de

    read more

How to use SQL queries when creating an internal report data source in FastReport.Net report designer

2 de setembro de 2019

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 query object:

 

 Then, write the request text:

 

Of course, here you can use the visual query designer, but now we don’t need it, the purpose of the demonstration is a query.

We specified a parameter in the request condition. In the next step, you need to create a parameter with the same name.

 

Since we are simply demonstrating how to work with parameters, we simply set the default value:

Next, select the desired columns.

That's all. The table is ready.

Remember, it is advisable to write queries according to all the rules of SQL, with an indication of the scheme, and possibly with the names in quotes. Here is an example of a valid postgresql database query:

1
SELECT * FROM public."Users" WHERE "Users"."Name"= @Name

 But, in addition to the parameterized query, we can also use dynamic queries. These are requests that we form in a text form, and then we execute them. Such queries allow using report variables to substitute, for example, the name of a table or parameter, or part of a ‘where’ clause – whatever is needed. It looks like this:

 

But that's not all. You can also use stored functions and stored procedures in a query. Here is an example of using the function:

 

Parameters in functions are passed in brackets, separated by commas.

An example of using a stored procedure:

Parameters in the stored procedure are followed by a procedure name separated by commas.

In this way, you can expand the data generation capabilities in order not to do this within the report.

about product download comprar
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
.NET FastReport Designer SQL

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Comprar
  • Download
  • Documentação
  • Depoimentos
  • Como desinstalar nossos produtos
  • Ticket system
  • FAQ
  • Tutorial Video
  • Forum
  • Articles
  • Our News
  • Informação sobre nós
  • Parceiros
  • Extended licensing
  • Contatos

© 1998-2022 by Fast Reports Inc.

  • Privacidade