Repeating Frame

[sivanu]

Hi I have developed an ORacle Report. It is a nomination form having 7 to 8 pages. FYI..Input is a Pin NUmber. So, the customer can either enter one pin or can select many pins from the browser and depending on the selection he needs to either print one form or many forms at a stretch. So i want a repeating frame to be enclosed all the other frames. But if i do that, then i am getitng an error
"REP-1212: Object R_13 is not fully enclosed by its enclosing body" since the repeating i introduced spans over all the pages in the report.

Please let me know the solution for this asap.

Thanks in Advance

 

[nagornyi]

What's the data model of yout report? How do you build a group that sources the repeating frame?

 

[sivanu]

I have one common table called usertable and linked (using data link) other groups (5 different groups) with this one using the primary key. Actually i didn't use the wizard. I created the repeating frame based on the usertable and included all the other sections under that. Since the other sections spans through pages, repeating frame has to go thru all the pages.

Hope i have explained clearly. If not please feel free to contact me. Since this is an urgent requirement, i am really want to solve this asap.

Thanks for your help and expecting a solution from you

Thanks

 

[nagornyi]

Within the repeating frame for the usertable group you need also to have repeating frames for other groups which data you want on the report.

 

[sivanu]

I have repeating frames for each of the other groups inside the main repeating group. the problem is that the main repeating group is going thru all the pages and so i am getting that error.

If i could know the solution for this problem asap, it would be great

 

[nagornyi]

Instead of using outer repeating frame, use "Repeat On" property of the report section in which you place the layout. Usually it is the main section. For the value of the property select the group with which you are trying to source the outer repeating frame.

 

[nagornyi]

The "Repeat On" property is available from version 9. If below, in the section property palette define Vertical Panels per Page = 8, then you can stretch the repeating frame across all 8 vertical pages.

 

[sivanu]

Hi nagornyi,
should i use lexical parameter when i want the report for list of values.

And what u tell is that i need not use repeating frame and use only repeat on feature with the value of repeat on property set to the main group. right?.

 

[nagornyi]

Right if you are using Reports 9i. For list of values, yes, you may use lexical parameter to substitute to the IN clause of the SQL.

 

[sivanu]

Thanks a lot nagornyi

the problem has solved. I am really thankful to u.

Will contact u if i have any further doubts / problems.