I'm in a situation where I have to build a super complex table or rather matrix
This is how the table/matrix should look like:
The complex thing is that everything is taken from a database.
I will try to explain the color sections one by one.
SERIE (Green area)
If we start with the top columns; SERIE 1, SERIE 2, SERIE 3
These values are coming from a table column value. If this column has the value 3 then I will need to print 3 table cells, just like in the image.
MEDICINE NAMES (Blue area)
Then there is the outer left columns, that goes like this;
Behandlingsdag (meaning day of treatment)
Osplatin (100 mg/m2)
And so forth.
All these values are also coming from 3 different tables
One Column (Yellow area)
These cells are getting their values from a table. According to some true og false values.
1, 2, 3, 4 (Red area)
Then there is the table cells below the SERIES. These table cells goes like this
First there is a 1, then there are the tables cells 1 to 18 all below
View Complete Post