开发者

Fastreport and TSQLQuery

开发者 https://www.devze.com 2023-03-30 07:50 出处：网络

I use TSQLQuery (from DBExpress) to run a query on two Mysql Tables. Now i want to pr开发者_如何学Cint a report from that Query using FastReport but i don\'t know how to do it!

相关专题：dbexpress delphi fastreport

I use TSQLQuery (from DBExpress) to run a query on two Mysql Tables. Now i want to pr开发者_如何学Cint a report from that Query using FastReport but i don't know how to do it!

Help me please.

If you enable the query at runtime (fill in relevant params if need be in the designer), you can doubleclick the TSQLQuery to bring up the field designer.
Choose add all fields.

Now you can add a datasource to that TSQLQuery and link the fields to your FastReport.

I strongly advise you to connect the query to the default SQLConnection at design time, and not at run-time, as you are currently doing (according to your comment). This will enable you to see the fields of the query and so link the correct fields to the FastReport.