Datawindow to NativePDF (2017 R2)

1
0
-1

Hello all,

I posted a similar question/issue in a previous post, but this is a slightly different situation, but the same unsolved problem.
I think I confused people by talking about "PSR to PDF", rather then just saying "Datawindow to PDF"
 
Simply, I need to save a dw into NativePDF with a custom width of 43 inches. The datawindow is that wide, and this will never be sent to a printer.
I cannot get SaveAs to accomplish this. No matter what I try, it will save to PDF as multiple pages, rather then one long row.
 
Here is what I have that is currently not working as I expect with the CustomPage.Width.. Any ideas?

        SetPointer(HourGlass!)
        dw_1.Object.DataWindow.Export.PDF.NativePDF.UsePrintSpec = 'Yes'
        dw_1.Modify("DataWindow.Print.Paper.Size='255'")   // Set custom paper size to inches
        dw_1.Modify("DataWindow.Print.CustomPage.Width='42000'")   //42.000 inches wide

        ls_save_as_location = ls_file_path + "Exception Funds\" + gs_client_code + "_" + String(Today( ), "mmddyy") + ".pdf"
        IF dw_1.SaveAs(ls_save_as_location, PDF!, True) = -1 THEN lb_was_error = True
        SetPointer(Arrow!)

Thanks!

Jason Lipman

Question Tags: 

Answers

Chris Pollach answered Datawindow to NativePDF (2017 R2)

1
+1
-1

Hi Jason;

   Is this what you are trying to do?

Regards ... Chris

Jason Lipman's picture

Yes!!! Go ahead.. tell me how simple it was and what I missed! :)

Jason

Chris Pollach's picture

Hi Jason;

   This was actually produced on the 8.5 x 11 paper size but I used the DW's Zoom property to zoom it down so that it would fit within the page size before creating the PDF. Once the PDF is created, the user can then use their PDF reader to zoom it up to a better visible size. So in essence, this was actually a workaround to your problem.

   No matter if I picked 11 x 17 paper size or used custom paper size settings for the printer paper via PowerScript - the DWO seemed to ignore them and reverted back to my default printer's settings. So I definitely think that PB has a bug (limitation) in this area. Definitely worth opening a support ticket for this one IMHO.

Regards ... Chris

Jason Lipman's picture

Agreed. Thank you for the work around idea. I'll submit a bug report.. and reference this conversation.

Jason

Chris Pollach answered Datawindow to NativePDF (2017 R2)

1
0
-1

Hi Jason;

  Can you send us your DWO Source?

Before exporting the DWO source  ... just add some datum in the DW Source via the DATA pane?  We can then try and recreate your issue and maybe come up with a solution for you.

Regards ... Chris

Jason Lipman's picture

Thanks, Chris.Below is 310 rows of a datawindow, from R2, called "d_to_nativepdf", with rows of phony data for your review. I appreciate whatever you determine. Perhaps it is a bug? In any case, the goal is to save as log rows, not multiple pages.

Jason

-------------------------------------

$PBExportHeader$d_to_nativepdf.srd
release 17;
datawindow(units=2 timer_interval=60000 color=16777215 brushmode=0 transparency=0 gradient.angle=0 gradient.color=8421504 gradient.focus=0 gradient.repetition.count=0 gradient.repetition.length=100 gradient.repetition.mode=0 gradient.scale=100 gradient.spread=100 gradient.transparency=0 picture.blur=0 picture.clip.bottom=0 picture.clip.left=0 picture.clip.right=0 picture.clip.top=0 picture.mode=0 picture.scale.x=100 picture.scale.y=100 picture.transparency=0 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 1 print.margin.left = 250 print.margin.right = 250 print.margin.top = 250 print.margin.bottom = 250 print.paper.source = 0 print.paper.size = 5 print.canusedefaultprinter=yes print.prompt=yes print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes print.background=no print.preview.background=no print.preview.outline=yes hidegrayline=no showbackcoloronxp=no picture.file="" grid.lines=0 selected.mouse=no )
header(height=322 color="-1" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
summary(height=0 color="-1" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
footer(height=302 color="-1" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
detail(height=197 color="553648127~tIF (ti_message = 'FILTR', RGB(255,255,185),  // Yellow
  IF(display_flag IN ('1','3'),
     RGB(220,220,220), // grey
    IF(f_get_time_diff(Datetime(updatedate), 'M') > 30,
       RGB(255,230,230), // red
       RGB(255,255,255)  // white
      )
    )
)" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
table(column=(type=char(6) updatewhereclause=no name=trade_origin dbname="trade_origin" values="    0/OMS    INT/OMS-S    MS/Upld-S    MSUPLD/Upld    UPLD/" )
 column=(type=char(1) updatewhereclause=no name=unprocessed_acct dbname="unprocessed_acct" )
 column=(type=long updatewhereclause=no name=tradeid dbname="tradeid" )
 column=(type=char(15) updatewhereclause=no name=fund_num dbname="fund_num" )
 column=(type=char(6) updatewhereclause=no name=source dbname="source" )
 column=(type=char(20) updatewhereclause=no name=trade_type dbname="trade_type" )
 column=(type=char(20) updatewhereclause=no name=acct_trade_type dbname="acct_trade_type" )
 column=(type=char(27) updatewhereclause=no name=secnum dbname="secnum" )
 column=(type=char(50) updatewhereclause=no name=sec_descript dbname="sec_descript" )
 column=(type=char(5) updatewhereclause=no name=trancode dbname="trancode" values="    0/Sell    S/Buy    B/Cover    COVER/Free Deliver    FDEL/Free Receive    FREC/Reverse Buy    RB/Reverse Sell    RS/Short    SHORT/Buy Free    BF/Sell Free    SF/" )
 column=(type=char(14) updatewhereclause=no name=ticket_num dbname="ticket_num" )
 column=(type=char(14) updatewhereclause=no name=original_ticket dbname="original_ticket" )
 column=(type=decimal(4) updatewhereclause=no name=shares dbname="shares" )
 column=(type=decimal(6) updatewhereclause=no name=price dbname="price" )
 column=(type=decimal(4) updatewhereclause=no name=principal dbname="principal" )
 column=(type=decimal(4) updatewhereclause=no name=accrued_int dbname="accrued_int" )
 column=(type=char(10) updatewhereclause=no name=effective_date dbname="effective_date" )
 column=(type=char(10) updatewhereclause=no name=trade_date dbname="trade_date" )
 column=(type=char(10) updatewhereclause=no name=actualsettldate dbname="actualsettldate" )
 column=(type=char(1) updatewhereclause=no name=comm_ind dbname="comm_ind" )
 column=(type=decimal(4) updatewhereclause=no name=commission dbname="commission" )
 column=(type=char(2) updatewhereclause=no name=commtype dbname="commtype" )
 column=(type=char(10) updatewhereclause=no name=broker_code dbname="broker_code" )
 column=(type=char(10) updatewhereclause=no name=clearing_broker_code dbname="clearing_broker_code" )
 column=(type=decimal(4) updatewhereclause=no name=expenses dbname="expenses" )
 column=(type=char(2) updatewhereclause=no name=pmcode dbname="pmcode" )
 column=(type=char(255) updatewhereclause=no name=trade_notes dbname="trade_notes" )
 column=(type=char(1) updatewhereclause=no name=inv1_export dbname="inv1_export" )
 column=(type=char(2) updatewhereclause=no name=asset_group dbname="asset_group" )
 column=(type=char(20) updatewhereclause=no name=updatedate dbname="updatedate" )
 column=(type=char(255) updatewhereclause=no name=ti_message dbname="ti_message" )
 column=(type=char(1) updatewhereclause=no name=ti_allow_download dbname="ti_allow_download" )
 column=(type=char(1) updatewhereclause=no name=putcall_flag dbname="putcall_flag" )
 column=(type=char(10) updatewhereclause=no name=contractual_settle_date dbname="contractual_settle_date" )
 column=(type=char(1) updatewhereclause=yes name=mps_processed dbname="MPS_processed" )
 column=(type=char(255) updatewhereclause=no name=inv1_errmsg dbname="inv1_errmsg" )
 column=(type=char(4) updatewhereclause=no name=advisor_code dbname="advisor_code" )
 column=(type=char(1) updatewhereclause=no name=is_tba dbname="is_tba" values="    0/Yes    T/No    F/" )
 column=(type=char(1) updatewhereclause=no name=display_flag dbname="display_flag" )
 column=(type=char(10) updatewhereclause=no name=oms_sec_type dbname="oms_sec_type" )
 column=(type=char(15) updatewhereclause=no name=acct_composite_fund_num dbname="acct_composite_fund_num" )
 column=(type=char(15) updatewhereclause=no name=master_head_acct dbname="master_head_acct" )
 column=(type=char(15) updatewhereclause=no name=sector_head_acct dbname="sector_head_acct" )
 column=(type=datetime updatewhereclause=no name=acct_live_date dbname="acct_live_date" )
 column=(type=char(1) updatewhereclause=no name=acct_live_ind dbname="acct_live_ind" )
 column=(type=char(20) updatewhereclause=no name=lei_code dbname="LEI_code" )
 column=(type=char(1) updatewhereclause=no name=acct_match_status dbname="acct_match_status" )
 column=(type=char(1) updatewhereclause=no name=acct_mc_status dbname="acct_mc_status" )
 column=(type=char(255) updatewhereclause=no name=acct_recon_comments dbname="acct_recon_comments" )
 column=(type=char(20) updatewhereclause=no name=client_name dbname="client_name" )
 column=(type=char(10) updatewhereclause=yes name=recon_maker_user dbname="recon_maker_user" )
 column=(type=char(10) updatewhereclause=yes name=recon_checker_user dbname="recon_checker_user" )
 column=(type=char(1) updatewhereclause=yes name=acct_status dbname="acct_status" values="    0/None    N/C    C/P    P/S    S/" )
 column=(type=char(1) updatewhereclause=yes name=samedayflag dbname="samedayflag" values="     0/Y    Y/N    N/" )
 procedure="1 execute tvs..tv_fa_blotter_sp1;1 @client_code = :client_code" arguments=(("client_code", string))  sort="fund_num A ti_message D IF(trade_origin IN ('INT','MS'),1,2) A secnum_helper A ticketnum_helper A ticket_num A updatedate A tradeid A CASE(trade_origin WHEN 'INT' THEN 1 WHEN 'MS' THEN 2 WHEN 'UPLD' THEN 3 WHEN 'MSUPLD' THEN 4 ELSE 5) A " )
data("INT","N", 1111111,"9999","JASON","","END OF ALL","1212122","JASON'S EXAMPLE 1","S","9131942779",null  45657.0000, 19.848700, 1638861.1100, 0,"01/01/2018","02/01/2018","06/30/2018","C", 1.0000,"EN","QWE","QWE", 0,"RE","THANK",null "WD","01/01/2018","",null "","06/01/2018","F","This is just not doing what I want it to do!","LCL","F",null "COP","1212","5656565",null 2017-11-30 00:00:00:000000,"L",null "","",null "Jason's Dilemma Inc.",null null "","N","INT","N", 2222222,"9999","JASON","","END OF ALL","1212122","JASON'S EXAMPLE 1","B","9132121959",null  59134.0000, 23.162700, 1637903.0800, 0,"01/01/2018","02/02/2018","06/30/2018","C", 2.0000,"EN","SDF","SDF", 0,"RE","YOU",null "WD","01/01/2018","",null "","06/01/2018","F","That is why cars drive in the lane, rather then in the house","LCL","F",null "COP","1212","5656565",null 2017-11-30 00:00:00:000000,"L",null "","",null "Jason's Dilemma Inc.",null null "","N","INT","N", 3333333,"9999","JASON","","END OF ALL","2121211","LIPMAN EXAMPLE 2","S","9131834759",null  976321.0000, 11.660700, 1705559.2800, 0,"01/01/2018","02/03/2018","06/30/2018","C", 3.0000,"EN","XCV","XCV", 0,"RE","FOR",null "WD","01/01/2018","",null "","06/01/2018","F","Account not setup","LCL","F",null "COP","1212","5656565",null 2017-11-30 00:00:00:000000,"L",null "","",null "Jason's Dilemma Inc.",null null "","Y","INT","N", 4444444,"9999","JASON","","END OF ALL","2121211","LIPMAN EXAMPLE 2","S","9132115609",null  111111.0000, 12.066700, 1706081.7500, 0,"01/01/2018","02/04/2018","06/30/2018","C", 4.0000,"EN","JHG","JHG", 0,"RE","HELPING",null "WD","01/01/2018","",null "","06/01/2018","F","Process flow is invalid","LCL","F",null "COP","1212","5656565",null 2017-11-30 00:00:00:000000,"L",null "","",null "Jason's Dilemma Inc.",null null "","N","INT","N", 5555555,"9999","JASON","","END OF ALL","2121211","LIPMAN EXAMPLE 2","S","9132142849",null  2222.0000, 12.600400, 98253.6400, 0,"01/01/2018","02/05/2018","06/30/2018","C", 5.0000,"EN","YUO","YUO", 0,"RE","ME!",null "WD","01/01/2018","",null "","06/01/2018","F","Shirts with Hawaiin insignias are cool","LCL","F",null "COP","1212","5656565",null 2017-11-30 00:00:00:000000,"L",null "","",null "Jason's Dilemma Inc.",null null "","N",null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null )
group(level=1 header.height=0 trailer.height=187 by=("fund_num" , "ti_message" ) header.color="536870912" header.transparency="0" header.gradient.color="8421504" header.gradient.transparency="0" header.gradient.angle="0" header.brushmode="0" header.gradient.repetition.mode="0" header.gradient.repetition.count="0" header.gradient.repetition.length="100" header.gradient.focus="0" header.gradient.scale="100" header.gradient.spread="100" trailer.color="-1" trailer.transparency="0" trailer.gradient.color="8421504" trailer.gradient.transparency="0" trailer.gradient.angle="0" trailer.brushmode="0" trailer.gradient.repetition.mode="0" trailer.gradient.repetition.count="0" trailer.gradient.repetition.length="100" trailer.gradient.focus="0" trailer.gradient.scale="100" trailer.gradient.spread="100" )
text(band=header alignment="2" text="Original
Ticket #" border="0" color="0" x="15833" y="62" height="229" width="677" html.valueishtml="0"  name=original_ticket_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Comm
Ind" border="0" color="0" x="22979" y="62" height="229" width="395" html.valueishtml="0"  name=comm_ind_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="1" text="Comm
Amt" border="0" color="0" x="23395" y="62" height="229" width="656" html.valueishtml="0"  name=commission_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Comm
Type" border="0" color="0" x="24072" y="62" height="229" width="406" html.valueishtml="0"  name=commtype_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Advisor
Code" border="0" color="0" x="25781" y="62" height="229" width="479" html.valueishtml="0"  name=t_5 visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="
Security #" border="0" color="0" x="6677" y="62" height="229" width="875" html.valueishtml="0"  name=secnum_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Master
Head Acct" border="0" color="0" x="3666" y="62" height="229" width="1041" html.valueishtml="0"  name=master_head_acct_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Sector
Head Acct" border="0" color="0" x="4729" y="62" height="229" width="760" html.valueishtml="0"  name=sector_head_acct_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="
Security Description" border="0" color="0" x="10562" y="62" height="229" width="2125" html.valueishtml="0"  name=sec_descript_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="
Trade Type" border="0" color="0" x="8104" y="62" height="229" width="1208" html.valueishtml="0"  name=trade_type_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="
Source" border="0" color="0" x="6208" y="62" height="229" width="447" html.valueishtml="0"  name=source_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="
OMC" border="0" color="0" x="5510" y="62" height="229" width="677" html.valueishtml="0"  name=tradeid_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Port.
Mgr" border="0" color="0" x="26281" y="62" height="229" width="489" html.valueishtml="0"  name=pmcode_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Accounting Recon
Comments" border="0" color="0" x="29541" y="62" height="229" width="12427" html.valueishtml="0"  name=acct_recon_comments_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Update Date
(Eastern Time)" border="0" color="0" x="26791" y="62" height="229" width="1239" html.valueishtml="0"  name=updatedate_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Recon
Maker User" border="0" color="0" x="28052" y="62" height="229" width="708" html.valueishtml="0"  name=recon_maker_user_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Recon
Checker User" border="0" color="0" x="28781" y="62" height="229" width="739" html.valueishtml="0"  name=recon_checker_user_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Accounting
Acct#" border="0" color="0" x="2583" y="62" height="229" width="1062" html.valueishtml="0"  name=acct_composite_fund_num_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Trade
Origin" border="0" color="0" x="1864" y="62" height="229" width="697" html.valueishtml="0"  name=trade_origin_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Accounting
Trade Type" border="0" color="0" x="9333" y="62" height="229" width="1208" html.valueishtml="0"  name=acct_trade_type_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Broker
Code" border="0" color="0" x="24500" y="62" height="229" width="406" html.valueishtml="0"  name=broker_code_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="1" text="Trade
Expenses" border="0" color="0" x="24927" y="62" height="229" width="833" html.valueishtml="0"  name=expenses_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Acct
Status" border="0" color="0" x="1197" y="62" height="229" width="645" html.valueishtml="0"  name=acct_status_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="1" text="Client
Acct#" border="0" color="0" x="10" y="62" height="229" width="1166" html.valueishtml="0"  name=fund_num_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="
TBA" border="0" color="0" x="7572" y="62" height="229" width="510" html.valueishtml="0"  name=is_tba_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Tran
Code" border="0" color="0" x="13822" y="62" height="229" width="937" html.valueishtml="0"  name=trancode_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Effective
Date" border="0" color="0" x="19927" y="62" height="229" width="802" html.valueishtml="0"  name=effective_date_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Trade
Date" border="0" color="0" x="20750" y="62" height="229" width="708" html.valueishtml="0"  name=trade_date_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Contract
Settle Dt" border="0" color="0" x="21479" y="62" height="229" width="656" html.valueishtml="0"  name=t_11 visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="2" text="Actual
Settle Dt" border="0" color="0" x="22156" y="62" height="229" width="802" html.valueishtml="0"  name=actualsettldate_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="1" text="
Quantity" border="0" color="0" x="16531" y="62" height="229" width="1010" html.valueishtml="0"  name=shares_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="1" text="
Price" border="0" color="0" x="17562" y="62" height="229" width="760" html.valueishtml="0"  name=price_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="1" text="
Principal" border="0" color="0" x="18343" y="62" height="229" width="875" html.valueishtml="0"  name=principal_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="1" text="Accrued
Interest" border="0" color="0" x="19239" y="62" height="229" width="666" html.valueishtml="0"  name=accrued_int_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="OMS
Sec Type" border="0" color="0" x="12708" y="62" height="229" width="531" html.valueishtml="0"  name=oms_sec_type_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Same Day
Flag" border="0" color="0" x="13260" y="62" height="229" width="552" html.valueishtml="0"  name=samedayflag_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="
Ticket #" border="0" color="0" x="14781" y="62" height="229" width="1031" html.valueishtml="0"  name=ticket_num_t visible="1"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=53 alignment="0" tabsequence=20 border="0" color="134217857" x="1208" y="0" height="187" width="635" format="[general]" html.valueishtml="0"  name=acct_status visible="1~tIF (ti_message = 'FILTR',1,0)" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any  font.face="Times New Roman" font.height="-11" font.weight="700"  font.family="1" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="8000" tooltip.enabled="0~tCASE (acct_match_status
  WHEN 'C' THEN 1
  WHEN 'P' THEN CASE (acct_mc_status
              WHEN '0' THEN 1
              WHEN '1' THEN 1
              WHEN '2' THEN 1
              ELSE 0)
  WHEN 'U' THEN CASE (acct_mc_status
              WHEN '0' THEN 1
              WHEN '1' THEN 1
              WHEN '2' THEN 1
              ELSE 0)
  ELSE 0)" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="1" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.tip="~tCASE (acct_match_status
  WHEN 'C' THEN 'Complete Match'
  WHEN 'P' THEN CASE (acct_mc_status
              WHEN '0' THEN 'Partial Unsigned'
              WHEN '1' THEN 'Partial Makered'
              WHEN '2' THEN 'Partial Complete'
              ELSE '')
  WHEN 'U' THEN CASE (acct_mc_status
              WHEN '0' THEN 'Sent to Accounting'
              WHEN '1' THEN 'Partial Match'
              WHEN '2' THEN 'Complete Match'
              ELSE '')
  ELSE '')" tooltip.transparency="0" transparency="0" )
text(band=detail alignment="0" text="text~tCASE( acct_status
         WHEN 'P' THEN 'P'
         WHEN 'C' THEN 'C'
         WHEN 'S' THEN 'S'
         WHEN 'N' THEN 'None'
         WHEN '0' THEN '' ELSE '')" border="0" color="134217857" x="1197" y="0" height="187" width="635" html.valueishtml="0"  name=t_acct_status visible="1~tIF (ti_message = 'FILTR',0,1)"  font.face="Times New Roman" font.height="-11" font.weight="700"  font.family="1" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0~tCASE (acct_match_status
  WHEN 'C' THEN 1
  WHEN 'P' THEN CASE (acct_mc_status
              WHEN '0' THEN 1
              WHEN '1' THEN 1
              WHEN '2' THEN 1
              ELSE 0)
  WHEN 'U' THEN CASE (acct_mc_status
              WHEN '0' THEN 1
              WHEN '1' THEN 1
              WHEN '2' THEN 1
              ELSE 0)
  ELSE 0)" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="1" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.tip="~tCASE (acct_match_status
  WHEN 'C' THEN 'Complete Match'
  WHEN 'P' THEN CASE (acct_mc_status
              WHEN '0' THEN 'Partial Unsigned'
              WHEN '1' THEN 'Partial Makered'
              WHEN '2' THEN 'Partial Complete'
              ELSE '')
  WHEN 'U' THEN CASE (acct_mc_status
              WHEN '0' THEN 'Sent to Accounting'
              WHEN '1' THEN 'Partial Match'
              WHEN '2' THEN 'Complete Match'
              ELSE '')
  ELSE '')" tooltip.transparency="0" transparency="0" )
column(band=detail id=54 alignment="0" tabsequence=310 border="0" color="0" x="13270" y="21" height="166" width="541" format="[general]" html.valueishtml="0"  name=samedayflag visible="1~tIF (ti_message = 'FILTR',1,0)" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=detail alignment="0" text="text~tCASE( samedayflag WHEN 'Y'
               THEN 'Yes'
              WHEN 'N'
               THEN 'No'
              WHEN '0'
               THEN ''
               ELSE '')" border="0" color="0" x="13260" y="21" height="166" width="541" html.valueishtml="0"  name=t_samedayflag visible="1~tIF (ti_message = 'FILTR',0,1)"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=8 alignment="0" tabsequence=90 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="6677" y="21" height="166" width="875" format="[general]" html.valueishtml="0"  name=secnum visible="1" edit.limit=27 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=4 alignment="1" tabsequence=10 border="0" color="0" x="20" y="21" height="166" width="1156" format="[general]" html.valueishtml="0"  name=fund_num  tag="Not filterable" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="700~tIF(  ti_message = 'FILTR',400,700)"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
bitmap(band=detail filename="techiss.bmp" x="7322" y="21" height="166" width="229" border="0" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0"  name=p_1 visible="1~tIf (IsNull (ti_allow_download), 0, 1)" transparency="0" )
column(band=detail id=41 alignment="0" tabsequence=40 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="2583" y="21" height="166" width="1062" format="[general]" html.valueishtml="0"  name=acct_composite_fund_num visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=43 alignment="0" tabsequence=60 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="4729" y="21" height="166" width="760" format="[general]" html.valueishtml="0"  name=sector_head_acct visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=42 alignment="0" tabsequence=50 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="3666" y="21" height="166" width="1041" format="[general]" html.valueishtml="0"  name=master_head_acct visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=5 alignment="0" tabsequence=80 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="6208" y="21" height="166" width="447" format="[general]" html.valueishtml="0"  name=source visible="1" edit.limit=5 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=3 alignment="0" tabsequence=70 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="5510" y="21" height="166" width="677" format="[general]" html.valueishtml="0"  name=tradeid visible="1" edit.limit=0 edit.case=any edit.format="###############" edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=9 alignment="0" tabsequence=130 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="10562" y="21" height="166" width="2125" format="[general]" html.valueishtml="0"  name=sec_descript visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (trade_type = ~"CORRECTED~", 700, 400)"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=6 alignment="0" tabsequence=110 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="8104" y="21" height="166" width="1208" format="[general]" html.valueishtml="0"  name=trade_type visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (trade_type = ~"CORRECTED~", 700, 400)"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=7 alignment="0" tabsequence=120 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="9333" y="21" height="166" width="1208" format="[general]" html.valueishtml="0"  name=acct_trade_type visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (trade_type = ~"CORRECTED~", 700, 400)"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=12 alignment="2" tabsequence=170 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="15833" y="21" height="166" width="677" format="[general]" html.valueishtml="0"  name=original_ticket visible="1" edit.limit=6 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=15 alignment="1" tabsequence=32766 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="18354" y="21" height="166" width="864" format="#,###.00" html.valueishtml="0"  name=principal  tag="Not filterable" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=14 alignment="1" tabsequence=32766 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="17562" y="21" height="166" width="760" format="#,###.000000" html.valueishtml="0"  name=price  tag="Not filterable" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=13 alignment="1" tabsequence=32766 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="16541" y="21" height="166" width="1000" format="#,###.0000" html.valueishtml="0"  name=shares  tag="Not filterable" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=22 alignment="2" tabsequence=230 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="24072" y="21" height="166" width="406" format="[general]" html.valueishtml="0"  name=commtype visible="1" edit.limit=2 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=21 alignment="1" tabsequence=32766 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="23406" y="21" height="166" width="645" format="#,###.00" html.valueishtml="0"  name=commission  tag="Not filterable" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=20 alignment="2" tabsequence=220 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="22979" y="21" height="166" width="395" format="[general]" html.valueishtml="0"  name=comm_ind visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=37 alignment="2" tabsequence=250 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="25781" y="21" height="166" width="479" format="[general]" html.valueishtml="0"  name=advisor_code visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=26 alignment="2" tabsequence=260 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="26281" y="21" height="166" width="489" format="[general]" html.valueishtml="0"  name=pmcode visible="1" edit.limit=2 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
compute(band=detail alignment="0" expression="if(asset_group = ~"F~", if(mid(secnum,1,4) = '8888', mid(secnum,5,3), mid(secnum,1,3) ),secnum)"border="0" color="0" x="41979" y="21" height="145" width="93~t0" format="[general]" html.valueishtml="0"  name=secnum_helper visible="1"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=30 alignment="0" tabsequence=270 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="26791" y="21" height="166" width="1239" format="[general]" html.valueishtml="0"  name=updatedate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="1" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="1" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.tip="~t'Arrived ' + f_get_time_diff(Datetime(updatedate), 'M') + ' minutes ago.'" tooltip.transparency="0" transparency="0" )
column(band=detail id=51 alignment="0" tabsequence=280 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="28052" y="21" height="166" width="708" format="[general]" html.valueishtml="0"  name=recon_maker_user visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=52 alignment="0" tabsequence=290 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="28781" y="21" height="166" width="739" format="[general]" html.valueishtml="0"  name=recon_checker_user visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
compute(band=detail alignment="0" expression="IF(  ti_message  = 'FILTR', 0, 1)"border="0" color="0" x="42093" y="10" height="166" width="166" format="[GENERAL]" html.valueishtml="0"  name=co_1st_sort visible="0"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=16 alignment="1" tabsequence=32766 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="19250" y="21" height="166" width="656" format="#,###.00" html.valueishtml="0"  name=accrued_int  tag="Not filterable" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=23 alignment="2" tabsequence=240 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="24500" y="21" height="166" width="406" format="[general]" html.valueishtml="0"  name=broker_code visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=25 alignment="1" tabsequence=32766 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="24937" y="21" height="166" width="822" format="###,###.00" html.valueishtml="0"  name=expenses  tag="Not filterable" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
bitmap(band=detail filename="returned.bmp" x="10" y="21" height="156" width="166" border="0" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0"  name=abend visible="1~t  if(trancode LIKE 'R%',
        IF(IsNull(inv1_errmsg), 0,  
         IF(inv1_errmsg Like '%User needs to%', 1,
IF (inv1_errmsg Like '%Error Deleting the Posted Cancelled Original%',1,0)
         )
        ),  
       IF(IsNull(inv1_export),  
        IF(IsNull(inv1_errmsg),0, 1), 0
        )
     ) " transparency="0" )
column(band=detail id=19 alignment="2" tabsequence=210 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="22156" y="21" height="166" width="802" format="[general]" html.valueishtml="0"  name=actualsettldate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=34 alignment="2" tabsequence=200 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="21479" y="21" height="166" width="656" format="[general]" html.valueishtml="0"  name=contractual_settle_date visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=18 alignment="2" tabsequence=190 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="20750" y="21" height="166" width="708" format="[general]" html.valueishtml="0"  name=trade_date visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=17 alignment="2" tabsequence=180 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="19937" y="21" height="166" width="791" format="[general]" html.valueishtml="0"  name=effective_date visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=40 alignment="0" tabsequence=140 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="12708" y="21" height="166" width="531" format="[general]" html.valueishtml="0"  name=oms_sec_type visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=1 alignment="0" tabsequence=30 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="1864" y="21" height="166" width="697" format="[general]" html.valueishtml="0"  name=trade_origin visible="1~tIF (ti_message = 'FILTR',1,0)" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=detail alignment="0" text="text~tCASE( trade_origin WHEN 'INT'
               THEN 'OMS'
              WHEN 'MS'
               THEN 'OMS-S'
              WHEN 'MSUPLD'
               THEN 'Upld-S'
              WHEN '0'
               THEN ''
               ELSE '')" border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="1864" y="21" height="166" width="697" html.valueishtml="0"  name=t_trade_origin visible="1~tIF (ti_message = 'FILTR',0,1)"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=38 alignment="0" tabsequence=100 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="7572" y="21" height="166" width="510" format="[general]" html.valueishtml="0"  name=is_tba visible="1~tIF (ti_message = 'FILTR',1,0)" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any  font.face="Arial" font.height="-8" font.weight="400~tif (trade_type = ~"CORRECTED~", 700, 400)"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=detail alignment="0" text="text~tCASE( is_tba WHEN 'T'
               THEN 'Yes'
              WHEN 'F'
               THEN 'No'
              WHEN '0'
               THEN ''
               ELSE '')" border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="7572" y="21" height="166" width="510" html.valueishtml="0"  name=t_is_tba visible="1~tIF (ti_message = 'FILTR',0,1)"  font.face="Arial" font.height="-8" font.weight="400~tif (trade_type = ~"CORRECTED~", 700, 400)"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=10 alignment="0" tabsequence=150 border="0" color="0" x="13833" y="21" height="166" width="927" format="[general]" html.valueishtml="0"  name=trancode visible="1~tIF (ti_message = 'FILTR',1,0)" ddlb.limit=0 ddlb.sorted=yes ddlb.allowedit=no ddlb.case=any ddlb.nilisnull=yes ddlb.vscrollbar=yes  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=detail alignment="0" text="text~tCASE( trancode WHEN 'S'
               THEN 'Sell'
              WHEN 'B'
               THEN 'Buy'
              WHEN 'COVER'
               THEN 'Cover'
              WHEN '0'
               THEN ''
               ELSE '')" border="0" color="0" x="13833" y="21" height="166" width="927" html.valueishtml="0"  name=t_trancode visible="1~tIF (ti_message = 'FILTR',0,1)"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=49 alignment="0" tabsequence=300 border="0" color="0~tcase (Mid (trade_type, 1, 3) when ~"CAN~" then RGB (255, 0, 0) when ~"COR~" then RGB (0, 128, 0) else RGB (0, 0, 0))" x="29541" y="21" height="166" width="12427" format="[general]" html.valueishtml="0"  name=acct_recon_comments visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.nilisnull=yes  font.face="Arial" font.height="-8" font.weight="400~tif (IsNull (trade_type), 400, if (trade_type = ~"CORRECTED~", 700, 400))"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
compute(band=detail alignment="0" expression="if (isNull( original_ticket ),  ticket_num ,  original_ticket )"border="0" color="0" x="41979" y="21" height="145" width="93~t0" format="[general]" html.valueishtml="0"  name=ticketnum_helper visible="0"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=11 alignment="0" tabsequence=160 border="0" color="0~tIF(Len(trade_notes) > 0 AND trade_notes <> ~"+~",
   RGB (0, 0, 255),
   CASE (Mid (trade_type, 1, 3)
   WHEN ~"CAN~" THEN RGB (255, 0, 0)
   WHEN ~"COR~" THEN RGB (0, 128, 0)
   ELSE RGB (0, 0, 0))
  )" x="14781" y="21" height="166" width="1031" format="[general]" html.valueishtml="0"  name=ticket_num visible="1" edit.limit=14 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes  font.face="Arial" font.height="-8" font.weight="400~tIF((Len(trade_notes) > 0 AND trade_notes <> ~"+~") OR
   IsNull(trade_type) OR
   trade_type = ~"CORRECTED~", 700, 400)
"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0~tIF(Len(trade_notes) > 0 AND trade_notes <> ~"+~", 1, 0)" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="1" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.tip="~tIF(Len(trade_notes) > 0 AND trade_notes <> ~"+~", ~"For rows with blue Ticket #'s, double click~~nthe row to see related Trade Notes.~", ~"~")" tooltip.transparency="0" transparency="0" )
compute(band=trailer.1 alignment="0" expression="IF(ti_message = 'FILTR', 0, 1)
//    count (fund_num for group 1))"border="0" color="0" x="10562" y="250" height="145" width="2125" format="[General]" html.valueishtml="0"  name=co_grp1_cnt visible="0"  font.face="Small Fonts" font.height="-7" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
compute(band=trailer.1 alignment="1" expression="String(Count(fund_num FOR GROUP 1),'#,###,###') + ' trade' +  
IF(count(fund_num FOR GROUP 1) > 1, 's','') +
' for Fund ' +  fund_num"border="0" color="0" x="10562" y="11" height="177" width="2125" format="[general]" html.valueishtml="0"  name=co_grp1_cnt_view visible="1~tIF(ti_message = 'FILTR', 0, 1)"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
compute(band=footer alignment="1" expression="String(  Sum(co_grp1_cnt for all) , '#,###,###') + ' trade(s) for all funds'
"border="0" color="0" x="10562" y="42" height="145" width="2125" format="[GENERAL]" html.valueishtml="0"  name=co_grp1_cnt_for_all visible="1~tIF (Sum(co_grp1_cnt for all) = 0, 0, 1)"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )

sparse(names="fund_num")htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" pagingmethod=0 generatedddwframes="1" )
xhtmlgen() cssgen(sessionspecific="0" )
xmlgen(inline="0" )
xsltgen()
jsgen()
export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=2 distill.custompostscript="0" xslfop.print="0" nativepdf.customsize=0 nativepdf.customorientation=0 nativepdf.pdfstandard=0 nativepdf.useprintspec=yes )
export.xhtml()