Walter. If you are setting setting relations in the dataenvironment of the report, I have found problems with this method. Instead use SELECT to combine all of the data into one cursor and use this for the report.
>i have a BIG problem within a Report.
>There are three tables, called „office“, „members“, „Jobs“!
>It should look like follows:
>***********************
>Office xy
> Member Dagobert
> Job Stuntman
> Job Salesman
> Job Looser
> Member Kermit
> Job Nothing
>Office zx
> Member Donald
> Job Executive
> Job else
>Sum: all Offices, all Members, all Jobs
>***********************
>OK:
>It works fine, but the table „Jobs“ brings only the first record of this member.
>Will be:
>***---------------------
>Office xy
> Member Dagobert
> Job Stuntman
> Member Kermit
> Job Nothing
>Office zx
> Member Donald
> Job Executive
>Sum: all Offices, all Members, all Jobs
>*****--------------------
>The oneToMany-Relations are true, but the Report takes no care.
>
>What is to do, if there are more then two relations ? (office to member works fine)
>
>Some ideas, any suggestions are very welcom
>
>Walter
Previous
Next
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