Kermia
Kermia

Reputation: 4221

Fastreport and TSQLQuery

I use TSQLQuery (from DBExpress) to run a query on two Mysql Tables. Now i want to print a report from that Query using FastReport but i don't know how to do it!

Help me please.

Upvotes: 0

Views: 1821

Answers (2)

No'am Newman
No'am Newman

Reputation: 6477

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.

Upvotes: 1

Johan
Johan

Reputation: 76753

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.

Upvotes: 2

Related Questions