'Expand to Layout' = "YES" vs "NO"

[bsinclair]

I am currently working with a large data base of information and attempting to display it using a subfile. The subfile will allow up to 9999 records to be entered but the subfile display will only allow 99 rows when 'expand to layout' is not "YES". The Subfile will scroll through all 9999 in the subfile with 'Expand to Layout' equal to "YES". Is there anyway to get this action in an oversize subfile using java script to display scroll bars and 'expand to layout' = "NO'?

Oversized means
wider then displayed and a total of 9999 records in it.

I hope I am explaining this correctly................

[Scott Klement]

Instead of making it expand to the layout, you could have the layout sized to the size of the subfile, and make it scrollable as explained here:
http://www.profoundlogic.com/forums/php ... f=53&t=860

Does that help? (I may be misunderstanding...)

[bsinclair]

I don't think wer are talking the same thing. I am using a display defined as 2500px in height and 1537 px wide so I need both horizontal and vertical scroll bars and I also need to see all 9999 records in the subfile. With 'Expand to layout' = 'NO' I am limited to 99 records displayed in the subfile yet with 'expand to layout' = 'YES' the program will scroll through all 9999 even though only 99 are defined in the subfile grid settings 'numbers of rows' .

Is there a way to get the same scoll through action with expand to layout = 'NO'.

[Scott Klement]

Do you mean that you can't get more than 99 total records in the subfile? Or do you mean that you can't get more than 99 on the screen at one time?

Expand to layout should just change the number displayed at one time to be the size of the layout that the subfile is in. It shouldn't affect the total number.

[bsinclair]

In both situations I am loading 9999 records into the subfile. When expand to layout = 'YES' the display willl scroll through all 9999 even though only a specific number are defined in the 'number of rows' attribute.

when expand to layout = 'NO' then you only see the number of rows defined in the 'number of rows' attribute even though you have loaded 9999 into the subfile.

I am looking for expand to layout = 'NO' to respond in the same manner as when it equals 'YES'.

[Scott Klement]

What "expand to layout" does is expand the subfile to the size of the layout widget that it has been placed inside. So if your layout is very large, it may show hundreds of records.

However, the "normal" way to use a subfile widget is to give it a number of rows to display on the screen, and a total number. It will have it's own scroll bar (separate from the browser's scroll bar) that you can use to scroll through the records. You can turn the scroll bar on/off or change it's behavior in the subfile widget properties.

I see that there's a 99 record per page limit (but the total size limit is 9999) in the designer... meaning you can't type a number higher than 99 in the rows per page size. However, it's possible to make it larger than that by calling JavaScript APIs. Is that what you're looking for?