you talk about blank fields, weell that would depend on what u want in your report. if you want table1 in report then there are no blanks. but if you want table2 then there will be blanks as there will be no data for some fields. if you just want to dump attributes into columns regardless like

PartType - Node - Port - Channel - atrribute 1 - atrribute 2 - arribute 3

in the way of php i would do something like this.

$attrib=array();

get db results

// if atrribute is not blank set atrribute array
if(!empty($Speed)){$arrib[]=Speed-value;}
if(!empty($Direction)){$arrib[]=Direction-value;}
if(!empty($Height)){$arrib[]=Height-value;}
ect.....

so if speed is not empty speed value would be $arrib[0]

PartType - Node - Port - Channel - arrib[0] - arrib[1] - arrib[2]


tables setup

table1 - part type id
PartType
Node
Port
Channel


table2 - part type attributes
PartType
Speed
Direction
Height
Length
Width
Height
Mass
Volume