Display Data As Matrices

Classic Servoy
1

Does anyone have some idea about displaying data originating from datasets (or foundsets) in a matrix format, such as below?

This is an example of what I would like to achieve in showing cross exchange rates (by beeing able to show currency names for both row and column titles).

              USD     Euro  Sterling
USD          1.000   1.307     1.536 
Euro         0.765   1.000     1.172
Sterling     0.651   0.853     1.000

It does not appear that table beans from http://www.servoy-plugins.de/ can do that, or perhaps I am just not able to understand how they could.

Thank you for your help.

Carlo

2

From a dataset you can create a datasource and then with the solutionModel you can create a new form that uses this datasource, something like:

		var dataSource = yourdataset.createDataSource("currency");
		var myForm = solutionModel.newForm("newForm", dataSource, "myStyleName", false, 800, 600);
		myForm.view = JSForm.LOCKED_TABLE_VIEW;
		myForm.newLabel("Name", 20, 20, 120, 30);
		myForm.newTextField("dataProviderNameHere", 140, 20, 140, 20);
3

crusca2382:
It does not appear that table beans from http://www.servoy-plugins.de/ can do that

Yes it can: I guess this was originally the reason to develop this…

But as Joas explained you can do this in native Servoy as well (since v5.x if I am correct).

Both ways have pro’s and cons.
The most important question is: are you using smart- or webclient?
Doing it the Servoy way can be handled by both clients, where the bean is only to be used in smart-client solutions.