General information
Category:
Reports & Report designer
Hello, Barbara
Thank you for your advice, but I didn't explain my problem in-depth enough ...
Actually, I made report based on parametrized View. That View I created including Table "Person" with parameter Person.Num= ?nNum . For that view I create relation with Table1, Table2 on Fields:
Person.year+Person.month +Person.num to Table1.year+Table1.month+Table1.num
Person.year+Person.month +Person.num to Table2.year+Table2.month+Table2.num
Table2 has relation on fields Table2.code with Table3.code
Table2.code to Table3.code(so table3 doesn't have any related fields with table1)
Those relations I created in Report's DataEnvironment .
I succeeded to obtain for each records in Table Person matching records in Table1, Table2 and Table3 (just using relations).
In the Band "Detail" I put one Edit box for records in Table1,under this - Edit box for records in Table2
But records from Table3 I have to put under all the other in Band"Fouter".Doing so I get as a result just 1-st records in Table3 matching to records in Table2.
In order to get other records from Table3 I am trying in the Init method of the DataEnvironment to put those records in array using SQL command, but now problem is to show all elements from the array.
I am not sure this is the right way. I also try to create cursor just like you said, but this multiplies records in table"Person" as many times as i have records in two other tables,
so i can't get the rigth records in bamd"Detail" (they are much more).
Are you feeling tired ...?
Please help,
Galia
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only