Report Woes

[AlastairOz]

I get the information to a report via 2 select into cursor statements.
I am trying to use grouping, but I always end up with one set of data getting lost.
For example:
Select #1 has primary key, want to group on that.
Select #2 has its own PK plus the foreign key from Select #1
I put Select #2 into the detail, add a group, use the
foreign key from select #2 for the group expression.
Add a line or a bit of text in the group to show the grouping
is working, : Select # 2 grouped.

When I then add fields to the group band from select #1,
I set relationship from select #2 into Select #1, NO data
for select#1.
Any ideas?

Thanks
Alastair

 

[AlastairOz]

Its OK, I have solved it: I did not set indexes on the temporary cursors
Alastair

 

[AlastairOz]

I spoke too soon, Its still not working.
Any Help would be greatly appreciated.

 

[Olaf Doschke]

You better drive a report by one cursor only, do a sql join.
Other solutions include SET RELATION, perhaps SET SKIP too.

But its much easier to select into one alias.

Bye, Olaf.