How to Create Query In Report Time
produsys
Brazil
Hi friends. On this time my problem is the following one:
I'm creating a report with Delphi and on before print I need to create an other Query for to make a second Select based on the current data.
Example:
My current query are bringing the code as number 2 for Sales table.
I'm printing the fields of the Sales table but I need for data of the Client table.
If I make all in one select my data will be duplicates. Then I need to make two selects right? Soon I need of two queries. But, How to create an other query in a MasterData (for example) making one select and binding it in one another MasterData?
That is very complicated but is necessary!!
I'm creating a report with Delphi and on before print I need to create an other Query for to make a second Select based on the current data.
Example:
My current query are bringing the code as number 2 for Sales table.
I'm printing the fields of the Sales table but I need for data of the Client table.
If I make all in one select my data will be duplicates. Then I need to make two selects right? Soon I need of two queries. But, How to create an other query in a MasterData (for example) making one select and binding it in one another MasterData?
That is very complicated but is necessary!!