Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Band 'Detail' in Report Designer
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00184099
Message ID:
00187187
Views:
28
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
Map
View

Click here to load this message in the networking platform