It's possible!

Hello,
I have two databases DB1 and DB2. I want show this result in FastReport:

Number Name Phone
DB1.TABLE1.ID DB1.TABLE1.NAME DB2.TABLE1.PHONE



DB1.TABLE1
ID
NAME

DB2.TABLE2
ID
PHONE

Can I do that with FastReport. I don't do it with SELECT statiment.
SELECT DB1.ID,DB1.NAME,(SELECT PHONE FROM DB2 WHERE DB1.ID=DB2.ID) FROM DB1

Thank you.

Comments

  • edited 8:20AM
    I found answer on Online-Help "Report with two data levels (master-detail)"

    Thanks.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.