Hi,
given report type: Records per Line
SQL-Command (Master):
SELECT MasterID, field1, field2, field3 FROM table_master WHERE [B]MasterID = 1[/B]
SQL-Command (SubSelect):
SELECT SubID, MasterID, field1, field2, field3 FROM table_sub WHERE MasterID = {MasterID}
This works fine …
I want now a multipage pdf and change the SQL-Command (Master) to:
SELECT MasterID, field1, field2, field3 FROM table_master WHERE [B]MasterID IN (1, 2)[/B]
In this case, SC prints a “mixed” record set … = Bug!