Best practices how to show many columns in dataview (>10 columns with a hundred thousands data rows)

Ilham Maulana Habibie · 2025-07-04T06:47:53+00:00

There was an error rendering this rich post.

Hi all,

I want to know the best practices how to show many columns in dataview with approximately >10 columns with a hundred thousands data rows in a dataview. Because I am stressfull a lot about limitation error rows limit issues. I have read many references from other forums/discussions about this one, and overall of their answers is to REDESIGN A LAYOUT which means that was not solution I need so far.

I really appreciated if someboy can share some best practices about this one here.

Best regards,

Ilham Maulana Habibie

Find more posts tagged with

Database

Layout

Dataview

Accepted answers

All comments

Helmut Heimann

Hi @Ilham Maulana Habibie ,

I'd opt for the FlexGrid in such a case if I were standing in your shoes.
Best results will be achieved with our latest version 14.3.1. What Release are you on?

Best,
Helmut

Ilham Maulana Habibie

Hi @Helmut Heimann ,

Thanks for your option before, but can you describe more detail about why we should use FlexGrid for this case?

Helmut Heimann

Hi @Ilham Maulana Habibie ,

the FlexGrid is designed for handling large volumes of data and gives the end-user much more flexibility than a Dataview could (at least in the most recent version). Have a look at this excerpt from our manual.

My opinion here is based on the fact that you have to deal with lots of rows (i.e. large volume), not that you want to display many columns, although the FlexGrid can handle more columns than the Dataview, too.

Best,
Helmut