floating tables

[fcecconi]

Is there any way to have tables dynamically change their X & Y position?

For example table 1 has 10 rows in it based on a set of criteria and the next table 2 is right below it.

But if the table 1 now has 15 rows, how can table 2 dynamically move down to avoid overlapping?

Thanks

Frank

[Anil_Babu_Samineni]

To avoid Overlapping use NoConcatenate - May be?

[marcus_sommer · Accepted solution]

Only with macros would it be (with some efforts) possible to change the object-positions and it's not really recommended to do it. Therefore you will need different approaches - by only a small number of possible different records you could use several objects and hide them conditionally - otherwise you need to rethink the whole usability of this sheet respectively the entire application.

- Marcus

[fcecconi]

Marcus

We came up with the same idea as you posted this.  Thanks for confirming our assumptions

[effinty2112]

Hi Frank, Try putting your tables in a container. Choose the grid style with one column and two rows. Cheers Andrew

[fcecconi]

Andrew

We tried that, but the tables didn't change their position.  the only way we were able to achieve the look and feel that we wanted was to show and hide multiple tables