Home › Forum › Omnis General Forum › Horizontal Complex G
-
Horizontal Complex G
Posted by Angelo Campo on June 8, 2023 at 10:24 amIs there a way to put horizontal column names and also fields in the complex grid
Andreas Pfeiffer replied 1 year, 1 month ago 2 Members · 17 Replies -
17 Replies
-
Hi Angelo,
Are you talking about web forms or window classes?
Best,
Andreas
- This reply was modified 1 year, 1 month ago by Andreas Pfeiffer.
-
Hello Angelo,
Complex grids in windows do have a horizontal header as well as a vertical header. Check out the properties “showhorzheader” and “showvertheader”.
Or do I misinterpret your question?
Best,
Andreas
-
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>I would like to make this grid horizontal</font></font>
- This reply was modified 1 year, 1 month ago by Angelo Campo.
-
Sorry, I am still not getting it.
Do you mean to turn the complete grid 90 degrees?
-
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>metti l’intestazione in orizzontale e anche i campi in questo modo:</font></font>
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>Cognome | Pietro | Campo</font></font></font></font>
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>Campo | PANORAMICO| ROSSO</font></font></font></font></font></font>
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>Orario |12:00 | 11:00</font></font></font></font></font></font></font></font>
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>Quote |4 | 4</font></font></font></font></font></font></font></font></font></font>
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>Totale Campo | 28 | 48</font></font></font></font></font></font></font></font></font></font></font></font>
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>Pagamento | </font></font></font></font></font></font></font></font></font></font></font></font></font></font><b style=”font-family: inherit; font-size: inherit; color: var(–bb-body-text-color);”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>€ </font></font><b style=”font-family: inherit; font-size: inherit; color: var(–bb-body-text-color);”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>€ P O | </font></font><b style=”font-family: inherit; font-size: inherit; color: var(–bb-body-text-color);”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>€ </font></font><b style=”font-family: inherit; font-size: inherit; color: var(–bb-body-text-color);”><font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>€ PO</font></font>
-
Sorry, I can only see HTM tags. Can you send a picture how it should look like?
Thanks.
-
-
ah – now I see what you mean.
You do not want to turn the grid, you want to turn the data – making rows to columns and vice versa.
You would need to change your data in the list. Depending on the SQL server that you use, check out the pivot SQL function.
Best,
Andreas
-
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>ok i try thanks </font></font>
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>
</font></font> -
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>Ci sono altri modi?</font></font>
-
For small lists you might be able to do this within Omnis. Give me a little time. I will provide a little sample library.
-
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>ok thanks</font></font>
-
Hello Angelo,
Attached please find a small sample library that contains an object class that you can use to pivot any list. There is also a test window that loads a list of classes from that library to demonstrate how it works.
One word of warning: It is expensive. So I would like to recommend using pivot functions when loading the data via SQL. That will be much quicker if there are many data.
There is also a pitfall when you have a localised Omnis. I made some hard coded commas in there. This will fail if your parameter separator is set to something else, i.e. semicolon.
Hope this helps.
Best regards,
Andreas
-
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>ok thanks</font></font>
<font style=”vertical-align: inherit;”><font style=”vertical-align: inherit;”>
</font></font>-
now – also works for other language settings. Please see attached.
-
Hi Angelo,
I noticed there is still a glitch. It startet to fail if the list has much more lines because the Do command could not handle the length of the argument. Therefore I changed it using a row variable for adding the line which seems to work much better.
Please see attached lib.
Best,
Andreas
-
-
-
-
-
Log in to reply.