protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
clients.GetClientsByType(elt_account_number, "All");
ColumnsCollection tmpCols = e.Layout.Bands[0].Columns;
tmpCols.FromKey("auto_uid").Hidden = true;
tmpCols.FromKey("po_num").Header.Caption = "Pickup Order No";
tmpCols.FromKey("MAWB_NUM").Header.Caption = "Master AWB/BL";
tmpCols.FromKey("HAWB_NUM").Header.Caption = "House AWB/BL";
tmpCols.FromKey("Shipper_Name").Header.Caption = "Shipper";
tmpCols.FromKey("Pickup_Name").Header.Caption = "Pickup From";
tmpCols.FromKey("Carrier_Name").Header.Caption = "Delivery To";
tmpCols.FromKey("Origin_Port_Code").Header.Caption = "From";
tmpCols.FromKey("Dest_Port_Code").Header.Caption = "To";
tmpCols.FromKey("ModifiedDate").Header.Caption = "Last Modified";
tmpCols.FromKey("file_type").Header.Caption = "File Type";
tmpCols.FromKey("ModifiedDate").Format = "MM/dd/yyyy";
tmpCols.FromKey("file_type").Width = Unit.Pixel(60);
tmpCols.FromKey("Shipper_Name").Width = Unit.Pixel(150);
tmpCols.FromKey("Pickup_Name").Width = Unit.Pixel(150);
tmpCols.FromKey("Carrier_Name").Width = Unit.Pixel(150);
tmpCols.FromKey("Origin_Port_Code").Width = Unit.Pixel(50);
tmpCols.FromKey("Dest_Port_Code").Width = Unit.Pixel(50);
tmpCols.FromKey("ModifiedDate").Width = Unit.Pixel(80);
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
clients.GetClientsByType(elt_account_number, "All");
UltraGridColumn ConsigneeCol = UltraWebGrid1.Bands[0].Columns.FromKey("consignee_acct");
ConsigneeCol.Type = ColumnType.DropDownList;
ConsigneeCol.ValueList.DataSource = clients.Tables["All"];
ConsigneeCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString();
ConsigneeCol.ValueList.ValueMember = clients.Tables["All"].Columns["org_account_number"].ToString();
ConsigneeCol.ValueList.DataBind();
ConsigneeCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
UltraGridColumn ShipperCol = UltraWebGrid1.Bands[0].Columns.FromKey("customer_acct");
ShipperCol.Type = ColumnType.DropDownList;
ShipperCol.ValueList.DataSource = clients.Tables["All"];
ShipperCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString();
ShipperCol.ValueList.ValueMember = clients.Tables["All"].Columns["org_account_number"].ToString();
ShipperCol.ValueList.DataBind();
ShipperCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
ColumnsCollection tmpCols = e.Layout.Bands[0].Columns;
tmpCols.FromKey("created_date").Format = "MM/dd/yyyy";
tmpCols.FromKey("shipout_date").Format = "MM/dd/yyyy";
tmpCols.FromKey("auto_uid").Hidden = true;
tmpCols.FromKey("so_num").Header.Caption = "Shipout No";
tmpCols.FromKey("created_date").Header.Caption = "Created Date";
tmpCols.FromKey("shipout_date").Header.Caption = "Shipout Date";
tmpCols.FromKey("consignee_acct").Header.Caption = "Ship To";
tmpCols.FromKey("customer_acct").Header.Caption = "Customer";
tmpCols.FromKey("file_type").Header.Caption = "File Type";
tmpCols.FromKey("house_num").Header.Caption = "House AWB/BL";
tmpCols.FromKey("master_num").Header.Caption = "Master AWB/BL";
tmpCols.FromKey("file_type").Header.Caption = "File Type";
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid;
ColumnsCollection mawbCols = uwg.Bands[0].Columns;
ColumnsCollection hawbCols = uwg.Bands[1].Columns;
ColumnsCollection itemCols = uwg.Bands[2].Columns;
//hiding uneccessary columns
mawbCols.FromKey("elt_account_number").Hidden = true;
mawbCols.FromKey("shipper_account_number").Hidden = true;
mawbCols.FromKey("createddate").Hidden = true;
mawbCols.FromKey("createdby").Hidden = true;
hawbCols.FromKey("elt_account_number").Hidden = true;
hawbCols.FromKey("mawb_num").Hidden = true;
hawbCols.FromKey("shipper_account_number").Hidden = true;
hawbCols.FromKey("agent_no").Hidden = true;
hawbCols.FromKey("createddate").Hidden = true;
hawbCols.FromKey("modifiedby").Hidden = true;
itemCols.FromKey("elt_account_number").Hidden = true;
itemCols.FromKey("hawb_num").Hidden = true;
itemCols.FromKey("mawb_num").Hidden = true;
// renaming headers
mawbCols.FromKey("mawb_num").Header.Caption = "Master AWB";
mawbCols.FromKey("shipper_name").Header.Caption = "Shipper";
mawbCols.FromKey("dep_airport_code").Header.Caption = "From";
mawbCols.FromKey("to_1").Header.Caption = "To 1";
mawbCols.FromKey("to_2").Header.Caption = "To 2";
mawbCols.FromKey("total_gross_weight").Header.Caption = "Gross Wt.";
mawbCols.FromKey("total_chargeable_weight").Header.Caption = "Charge Wt.";
mawbCols.FromKey("weight_scale").Header.Caption = "Scale";
mawbCols.FromKey("createddate").Header.Caption = "Created";
mawbCols.FromKey("createdby").Header.Caption = "By";
hawbCols.FromKey("hawb_num").Header.Caption = "House AWB";
hawbCols.FromKey("shipper_name").Header.Caption = "Shipper";
hawbCols.FromKey("agent_name").Header.Caption = "Agent";
hawbCols.FromKey("total_chargeable_weight").Header.Caption = "Charge Wt.";
hawbCols.FromKey("weight_scale").Header.Caption = "Scale";
hawbCols.FromKey("createddate").Header.Caption = "Created";
hawbCols.FromKey("modifiedby").Header.Caption = "By";
itemCols.FromKey("item_type").Header.Caption = "Item Type";
itemCols.FromKey("item_desc").Header.Caption = "Item Name";
itemCols.FromKey("item_amount").Header.Caption = "Item Amount";
itemCols.FromKey("vendor_no").Header.Caption = "Vendor";
// format data
mawbCols.FromKey("createddate").Format = "MM/dd/yyyy";
hawbCols.FromKey("createddate").Format = "MM/dd/yyyy";
FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
clients.GetClientsByType(elt_account_number, "All");
UltraGridColumn vendorCol = itemCols.FromKey("vendor_no");
vendorCol.Type = ColumnType.DropDownList;
vendorCol.ValueList.DataSource = clients.Tables["All"];
vendorCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString();
vendorCol.ValueList.ValueMember = clients.Tables["All"].Columns["org_account_number"].ToString();
vendorCol.ValueList.DataBind();
vendorCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", 0));
mawbCols.FromKey("mawb_num").Width = Unit.Pixel(120);
mawbCols.FromKey("shipper_name").Width = Unit.Pixel(200);
mawbCols.FromKey("dep_airport_code").Width = Unit.Pixel(50);
mawbCols.FromKey("to_1").Width = Unit.Pixel(50);
mawbCols.FromKey("to_2").Width = Unit.Pixel(50);
mawbCols.FromKey("total_gross_weight").Width = Unit.Pixel(80);
mawbCols.FromKey("total_chargeable_weight").Width = Unit.Pixel(80);
mawbCols.FromKey("weight_scale").Width = Unit.Pixel(40);
mawbCols.FromKey("Revenue").Width = Unit.Pixel(80);
mawbCols.FromKey("Expense").Width = Unit.Pixel(80);
mawbCols.FromKey("createddate").Width = Unit.Pixel(80);
mawbCols.FromKey("createdby").Width = Unit.Pixel(80);
mawbCols.FromKey("Profit").Width = Unit.Pixel(80);
hawbCols.FromKey("hawb_num").Width = Unit.Pixel(138);
hawbCols.FromKey("shipper_name").Width = Unit.Pixel(200);
hawbCols.FromKey("agent_name").Width = Unit.Pixel(200);
hawbCols.FromKey("total_chargeable_weight").Width = Unit.Pixel(80);
hawbCols.FromKey("weight_scale").Width = Unit.Pixel(40);
hawbCols.FromKey("Revenue").Width = Unit.Pixel(80);
hawbCols.FromKey("Expense").Width = Unit.Pixel(80);
hawbCols.FromKey("createddate").Width = Unit.Pixel(80);
hawbCols.FromKey("modifiedby").Width = Unit.Pixel(80);
hawbCols.FromKey("Profit").Width = Unit.Pixel(80);
itemCols.FromKey("item_type").Width = Unit.Pixel(80);
itemCols.FromKey("item_desc").Width = Unit.Pixel(160);
itemCols.FromKey("item_amount").Width = Unit.Pixel(80);
itemCols.FromKey("vendor_no").Width = Unit.Pixel(150);
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
ColumnsCollection routeCols = e.Layout.Bands[0].Columns;
ColumnsCollection airlineCols = e.Layout.Bands[1].Columns;
ColumnsCollection weightCols = e.Layout.Bands[2].Columns;
//hiding uneccessary columns
routeCols.FromKey("elt_account_number").Hidden = true;
routeCols.FromKey("rate_type").Hidden = true;
airlineCols.FromKey("origin_port").Hidden = true;
airlineCols.FromKey("dest_port").Hidden = true;
airlineCols.FromKey("kg_lb").Hidden = true;
airlineCols.FromKey("elt_account_number").Hidden = true;
airlineCols.FromKey("rate_type").Hidden = true;
weightCols.FromKey("airline").Hidden = true;
weightCols.FromKey("origin_port").Hidden = true;
weightCols.FromKey("dest_port").Hidden = true;
weightCols.FromKey("kg_lb").Hidden = true;
weightCols.FromKey("airline").Hidden = true;
weightCols.FromKey("item_no").Hidden = true;
weightCols.FromKey("elt_account_number").Hidden = true;
weightCols.FromKey("rate_type").Hidden = true;
weightCols.FromKey("share").Hidden = true;
weightCols.FromKey("fl_rate").Hidden = true;
weightCols.FromKey("sec_rate").Hidden = true;
weightCols.FromKey("include_fl_rate").Hidden = true;
weightCols.FromKey("include_sec_rate").Hidden = true;
// renaming headers
routeCols.FromKey("origin_port").Header.Caption = "Origin Port";
routeCols.FromKey("dest_port").Header.Caption = "Destination Port";
routeCols.FromKey("kg_lb").Header.Caption = "Unit";
airlineCols.FromKey("share").Header.Caption = "Share (%)";
airlineCols.FromKey("airline").Header.Caption = "Airline (Code)";
airlineCols.FromKey("fl_rate").Header.Caption = "Fuel Sur (%)";
airlineCols.FromKey("sec_rate").Header.Caption = "Security Sur (%)";
airlineCols.FromKey("include_fl_rate").Header.Caption = "Fuel Profit Sharing";
airlineCols.FromKey("include_sec_rate").Header.Caption = "Security Profit Sharing";
weightCols.FromKey("weight_break").Header.Caption = "Weight Break";
weightCols.FromKey("rate").Header.Caption = "Rate (%)";
////////////////////////////////////////////////////////////////////
FreightEasy.Ports.ALLPorts ports = new FreightEasy.Ports.ALLPorts();
ports.GetAllPorts(elt_account_number, "All");
FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
clients.GetClientsByType(elt_account_number, "Airlines");
//////////////////////////////////////////////////////////////////////
UltraGridColumn KgLbCol = UltraWebGrid1.Bands[0].Columns.FromKey("kg_lb");
KgLbCol.Type = ColumnType.DropDownList;
KgLbCol.ValueList.ValueListItems.Add(new ValueListItem("LB", "L"));
KgLbCol.ValueList.ValueListItems.Add(new ValueListItem("KG", "K"));
KgLbCol.ValueList.Style.Font.Size = FontUnit.Point(8);
KgLbCol.Width = Unit.Pixel(80);
UltraGridColumn OriginPortCol = UltraWebGrid1.Bands[0].Columns.FromKey("origin_port");
OriginPortCol.Type = ColumnType.DropDownList;
OriginPortCol.ValueList.DataSource = ports.Tables["All"];;
OriginPortCol.ValueList.DisplayMember = ports.Tables["All"].Columns["port_display"].ToString();
OriginPortCol.ValueList.ValueMember = ports.Tables["All"].Columns["port_code"].ToString();
OriginPortCol.ValueList.DataBind();
OriginPortCol.ValueList.Style.Font.Size = FontUnit.Point(8);
OriginPortCol.Width = Unit.Pixel(200);
UltraGridColumn DestPortCol = UltraWebGrid1.Bands[0].Columns.FromKey("dest_port");
DestPortCol.Type = ColumnType.DropDownList;
DestPortCol.ValueList.DataSource = ports.Tables["All"];
DestPortCol.ValueList.DisplayMember = ports.Tables["All"].Columns["port_display"].ToString();
DestPortCol.ValueList.ValueMember = ports.Tables["All"].Columns["port_code"].ToString();
DestPortCol.ValueList.DataBind();
DestPortCol.ValueList.Style.Font.Size = FontUnit.Point(8);
DestPortCol.Width = Unit.Pixel(200);
UltraGridColumn AirlineCol = UltraWebGrid1.Bands[1].Columns.FromKey("airline");
AirlineCol.Type = ColumnType.DropDownList;
AirlineCol.ValueList.DataSource = clients.Tables["Airlines"];
AirlineCol.ValueList.DisplayMember = clients.Tables["Airlines"].Columns["airline_display"].ToString();
AirlineCol.ValueList.ValueMember = clients.Tables["Airlines"].Columns["carrier_code"].ToString();
AirlineCol.ValueList.DataBind();
AirlineCol.ValueList.Style.Font.Size = FontUnit.Point(8);
AirlineCol.Width = Unit.Pixel(250);
UltraGridColumn IncFlRateCol = UltraWebGrid1.Bands[1].Columns.FromKey("include_fl_rate");
IncFlRateCol.Type = ColumnType.DropDownList;
IncFlRateCol.ValueList.ValueListItems.Add(new ValueListItem("Yes", "Y"));
IncFlRateCol.ValueList.ValueListItems.Add(new ValueListItem("No", "N"));
IncFlRateCol.ValueList.Style.Font.Size = FontUnit.Point(8);
IncFlRateCol.Width = Unit.Pixel(100);
UltraGridColumn IncSecRateCol = UltraWebGrid1.Bands[1].Columns.FromKey("include_sec_rate");
IncSecRateCol.Type = ColumnType.DropDownList;
IncSecRateCol.ValueList.ValueListItems.Add(new ValueListItem("Yes", "Y"));
IncSecRateCol.ValueList.ValueListItems.Add(new ValueListItem("No", "N"));
IncSecRateCol.ValueList.Style.Font.Size = FontUnit.Point(8);
IncSecRateCol.Width = Unit.Pixel(120);
UltraWebGrid1.Bands[1].Columns.FromKey("share").Width = Unit.Pixel(80);
UltraWebGrid1.Bands[1].Columns.FromKey("fl_rate").Width = Unit.Pixel(80);
UltraWebGrid1.Bands[1].Columns.FromKey("sec_rate").Width = Unit.Pixel(90);
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
ColumnsCollection aesCols = e.Layout.Bands[0].Columns;
FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
clients.GetClientsByType(elt_account_number, "Consignees");
clients.GetClientsByType(elt_account_number, "Shippers");
UltraGridColumn ConsigneeCol = UltraWebGrid1.Bands[0].Columns.FromKey("consignee_acct");
ConsigneeCol.Type = ColumnType.DropDownList;
ConsigneeCol.ValueList.DataSource = clients.Tables["Consignees"];
ConsigneeCol.ValueList.DisplayMember = clients.Tables["Consignees"].Columns["dba_name"].ToString();
ConsigneeCol.ValueList.ValueMember = clients.Tables["Consignees"].Columns["org_account_number"].ToString();
ConsigneeCol.ValueList.DataBind();
ConsigneeCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
UltraGridColumn InterConsigneeCol = UltraWebGrid1.Bands[0].Columns.FromKey("inter_consignee_acct");
InterConsigneeCol.Type = ColumnType.DropDownList;
InterConsigneeCol.ValueList.DataSource = clients.Tables["Consignees"];
InterConsigneeCol.ValueList.DisplayMember = clients.Tables["Consignees"].Columns["dba_name"].ToString();
InterConsigneeCol.ValueList.ValueMember = clients.Tables["Consignees"].Columns["org_account_number"].ToString();
InterConsigneeCol.ValueList.DataBind();
InterConsigneeCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
UltraGridColumn ShipperCol = UltraWebGrid1.Bands[0].Columns.FromKey("shipper_acct");
ShipperCol.Type = ColumnType.DropDownList;
ShipperCol.ValueList.DataSource = clients.Tables["Shippers"];
ShipperCol.ValueList.DisplayMember = clients.Tables["Shippers"].Columns["dba_name"].ToString();
ShipperCol.ValueList.ValueMember = clients.Tables["Shippers"].Columns["org_account_number"].ToString();
ShipperCol.ValueList.DataBind();
ShipperCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
aesCols.FromKey("shipment_ref_no").Header.Caption = "Ship Ref No";
aesCols.FromKey("aes_status").Header.Caption = "AES Status";
aesCols.FromKey("aes_itn").Header.Caption = "ITN No.";
aesCols.FromKey("shipper_acct").Header.Caption = "USPPI";
aesCols.FromKey("house_num").Header.Caption = "House AWB";
aesCols.FromKey("master_num").Header.Caption = "Master AWB";
aesCols.FromKey("consignee_acct").Header.Caption = "Consignee";
aesCols.FromKey("inter_consignee_acct").Header.Caption = "Inter Consignee";
aesCols.FromKey("export_date").Header.Caption = "Export Date";
aesCols.FromKey("origin_state").Header.Caption = "Origin";
aesCols.FromKey("dest_country").Header.Caption = "Destination";
aesCols.FromKey("export_carrier").Header.Caption = "Carrier";
aesCols.FromKey("export_port").Header.Caption = "From";
aesCols.FromKey("unloading_port").Header.Caption = "To";
aesCols.FromKey("tran_date").Header.Caption = "Submit Date";
aesCols.FromKey("export_date").Format = "MM/dd/yyyy";
aesCols.FromKey("tran_date").Format = "MM/dd/yyyy";
aesCols.FromKey("auto_uid").Hidden = true;
aesCols.FromKey("aes_status").Width = new Unit("80px");
aesCols.FromKey("shipment_ref_no").Width = new Unit("90px");
aesCols.FromKey("shipper_acct").Width = new Unit("160px");
aesCols.FromKey("consignee_acct").Width = new Unit("160px");
aesCols.FromKey("inter_consignee_acct").Width = new Unit("160px");
aesCols.FromKey("export_date").Width = new Unit("70px");
aesCols.FromKey("origin_state").Width = new Unit("40px");
aesCols.FromKey("dest_country").Width = new Unit("65px");
aesCols.FromKey("export_carrier").Width = new Unit("110px");
aesCols.FromKey("export_port").Width = new Unit("40px");
aesCols.FromKey("unloading_port").Width = new Unit("40px");
aesCols.FromKey("tran_date").Width = new Unit("70px");
aesCols.FromKey("shipment_ref_no").Hidden = true;
aesCols.FromKey("consignee_acct").Hidden = true;
aesCols.FromKey("inter_consignee_acct").Hidden = true;
aesCols.FromKey("origin_state").Hidden = true;
aesCols.FromKey("dest_country").Hidden = true;
aesCols.FromKey("export_carrier").Hidden = true;
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid;
ColumnsCollection mawbCols = uwg.Bands[0].Columns;
ColumnsCollection hawbCols = uwg.Bands[1].Columns;
ColumnsCollection itemCols = uwg.Bands[2].Columns;
//hiding uneccessary columns
mawbCols.FromKey("elt_account_number").Hidden = true;
mawbCols.FromKey("shipper_acct_num").Hidden = true;
hawbCols.FromKey("elt_account_number").Hidden = true;
hawbCols.FromKey("booking_num").Hidden = true;
hawbCols.FromKey("shipper_acct_num").Hidden = true;
hawbCols.FromKey("agent_no").Hidden = true;
itemCols.FromKey("elt_account_number").Hidden = true;
itemCols.FromKey("booking_num").Hidden = true;
itemCols.FromKey("hbol_num").Hidden = true;
// renaming headers
mawbCols.FromKey("booking_num").Header.Caption = "Booking No";
mawbCols.FromKey("loading_port").Header.Caption = "FROM";
mawbCols.FromKey("unloading_port").Header.Caption = "To";
mawbCols.FromKey("gross_weight").Header.Caption = "Gross Wt.";
hawbCols.FromKey("hbol_num").Header.Caption = "House B/L";
hawbCols.FromKey("shipper_name").Header.Caption = "Shipper";
hawbCols.FromKey("agent_name").Header.Caption = "Agent";
hawbCols.FromKey("gross_weight").Header.Caption = "Gross Wt.";
itemCols.FromKey("item_type").Header.Caption = "Item Type";
itemCols.FromKey("item_desc").Header.Caption = "Item Name";
itemCols.FromKey("item_amount").Header.Caption = "Item Amount";
itemCols.FromKey("vendor").Header.Caption = "Vendor";
FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
clients.GetClientsByType(elt_account_number, "All");
UltraGridColumn vendorCol = itemCols.FromKey("vendor");
vendorCol.Type = ColumnType.DropDownList;
vendorCol.ValueList.DataSource = clients.Tables["All"];
vendorCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString();
vendorCol.ValueList.ValueMember = clients.Tables["All"].Columns["org_account_number"].ToString();
vendorCol.ValueList.DataBind();
vendorCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", 0));
mawbCols.FromKey("booking_num").Width = Unit.Pixel(120);
mawbCols.FromKey("shipper_name").Width = Unit.Pixel(200);
mawbCols.FromKey("loading_port").Width = Unit.Pixel(50);
mawbCols.FromKey("unloading_port").Width = Unit.Pixel(50);
mawbCols.FromKey("gross_weight").Width = Unit.Pixel(80);
mawbCols.FromKey("Revenue").Width = Unit.Pixel(80);
mawbCols.FromKey("Expense").Width = Unit.Pixel(80);
mawbCols.FromKey("Profit").Width = Unit.Pixel(80);
hawbCols.FromKey("hbol_num").Width = Unit.Pixel(138);
hawbCols.FromKey("shipper_name").Width = Unit.Pixel(200);
hawbCols.FromKey("agent_name").Width = Unit.Pixel(200);
hawbCols.FromKey("gross_weight").Width = Unit.Pixel(80);
hawbCols.FromKey("Revenue").Width = Unit.Pixel(80);
hawbCols.FromKey("Expense").Width = Unit.Pixel(80);
hawbCols.FromKey("Profit").Width = Unit.Pixel(80);
itemCols.FromKey("item_type").Width = Unit.Pixel(80);
itemCols.FromKey("item_desc").Width = Unit.Pixel(160);
itemCols.FromKey("item_amount").Width = Unit.Pixel(80);
itemCols.FromKey("vendor").Width = Unit.Pixel(150);
}