Datawindow to NativePDF (2017 R2)

Resolved Datawindow to NativePDF (2017 R2)

Issue

Votes

Undo

Jason Lipman
PowerBuilder
Tuesday, 15 May 2018 15:10 PM UTC

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

Responses (3)

Roland Smith Accepted Answer Pending Moderation

Tuesday, 15 May 2018 15:22 PM UTC
PowerBuilder
# 1

Is the units property set to 1/1000 inch (2)?

Comment

Jason Lipman
Tuesday, 15 May 2018 15:46 PM UTC

Yup. It most certainly is. By now, I have tried all the combinations of things I can think of with properties.

Helpful 0

There are no comments made yet.

Chris Pollach @Appeon Accepted Answer Pending Moderation

Tuesday, 15 May 2018 15:50 PM UTC
PowerBuilder
# 2

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

Comment

Jason Lipman
Tuesday, 15 May 2018 20:36 PM UTC

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="

Helpful 0

There are no comments made yet.

Chris Pollach @Appeon Accepted Answer Pending Moderation

Tuesday, 15 May 2018 21:41 PM UTC
PowerBuilder
# 3

Hi Jason;

Is this what you are trying to do?

Regards ... Chris

Comment

Jason Lipman
Tuesday, 15 May 2018 22:41 PM UTC

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

Jason

Helpful 0

Chris Pollach @Appeon
Wednesday, 16 May 2018 13:25 PM UTC

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

Helpful 0

Jason Lipman
Wednesday, 16 May 2018 16:12 PM UTC

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

Jason

Helpful 0

There are no comments made yet.

Page :
1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

Resolved Datawindow to NativePDF (2017 R2)

Find Questions by Tag