between pages trigger problem
470802Jan 5 2010 — edited Jan 8 2010Hello,
I'm having a problem with a report and I'll be very grateful for some help.
The initial problem is to draw a special matrix, but I couldn't manage to show it successfully then I've invented my own matrix type.
I've a repeating frame where inside has three more frames (A, B and C). The frame A is the row label, the frame B is the column label and the frame C is the cell of the matrix.
B
A C
It's shown from left to right and from up to down. Depending on the position the frame A and frame B it souldn't be shown. Until now all is ok.
Example:
B B B B
A C C C C
A C C C C
A C C C C
The problem is when the report changes the page. I've a variable which indicates if the frame B has to be shown or not. This variable is updated in the "between pages" trigger. The problem is that the format trigger of the repeating frame is executed before the "between pages" trigger, then the variable is not updated and the frame B is not shown. This situation happens when the page is filled and the reports try to show the following cell.
Example of malfunction:
A C B B B
C C C
A C C C C
A C C C C
I thing that the report tries to show the repeating frame with the correct "inside frames" hidden and because it doesn't fit in the page then the "between pages" trigger is fired, but the format trigger is not re-fired to take into account the updated variables.
I work with Oracle Reports 6i.
Could anyone help me? Thank you very much.
Jordi
P.D.: I hope you understand the problem.
P.D.: Sorry for the grammar.