Home » Developer & Programmer » Reports & Discoverer » Master-Detail relationships in different canvases
Master-Detail relationships in different canvases [message #88386] Mon, 29 July 2002 23:22 Go to next message
Alberto Urbano
Messages: 2
Registered: February 2002
Junior Member
Hi.

I'm trying to use a master-detail relationship in a form which has two canvases. In the first one I've put the fields for the master table, and in the other one, the ones for the detail table. When a query is executed over the Master Block, it only returns data from this block, and doesn't query the detail block. If now I enter this block, the query is executed and I obtain the data of the detail corresponding to the master record.

If I remove the second canvas and put the detail fields in the first one, the query is executed correctly and I get the results of both tables.

Is there any way to solve this?
Re: Master-Detail relationships in different canvases [message #88403 is a reply to message #88386] Thu, 15 August 2002 03:51 Go to previous message
satish
Messages: 112
Registered: September 2000
Senior Member
To solve this problem you have to write a PL/SQL block
for both mater and details.

on master block after enter query.
check system.Block_status
event and if it not changed or query. / the no of rows retrieved.
according to this fire query on detail canvas.
Previous Topic: compiling oracle report with automatic submission of report
Next Topic: Generating reports in RTF and Excel on Sun Solaris
Goto Forum:
  


Current Time: Thu Mar 28 07:05:58 CDT 2024