Questions? Feedback?powered byOlark live chat software
Bug 3359

Composite DataWindow 12 November, 2019

Igor G
18 September, 2019
Product: PowerBuilder Category: DataWindow
Version: 2019 Publishing: Public
Status: Analyzing Priority: P3
Classification: Resolution:
Chris Pollach 12 November, 2019
Hi Igor;

   We have not heard back from you for a while. Were you able to resolve your print issue(s) OK?

Regards ... Chris
Chris Pollach 18 October, 2019
Looks like the issue is only PowerServer now. 

DC.Print() will not work because it takes the parent only DWO Printer settings for the entire prinjob, ignoring the child DWO printer settings.
Igor G 18 October, 2019
Could you help me understand why I can't get landscape printing? See my first comment from today.
Chris Pollach 18 October, 2019
   Super ... that is one of the reasons for sometimes using the PrintDataWindow() approach vs DC.Print() on a composite or nested DWO.

   If the issue now is only from the PowerServer aspect... can we close this ticket as its PB related? Then I would recommend opening a new ticket under PowerServer for this PrintDataWindow issue.

Regards ... Chris
Igor G 18 October, 2019
The PrintDataWindow report way, definitely
Chris Pollach 18 October, 2019
Hi Igor;

  Are you saying that printing now works OK in a "native" PB application but not as a PowerServer Web App?

Regards ... Chris
Igor G 18 October, 2019
In addition, the following code prints great on the app, but on the web app there's a blank page produced. In this way I have to specifically select "landscape" as well.
So if this cannot work on the webapp, I really need to figure the PrintDataWindow way.

--------------
long jb

printsetup()

jb = PrintOpen()

dw_member_report.print (jb, 250, 250)
dw_member_report_detail.print (jb, 250, 1100)

PrintClose(jb)
Igor G 18 October, 2019
Screen Shot 2019-10-18 at 11.01.03 AM.png (36KB)

I don't know what I am missing.

I am picking "landscape print" in the printer properties, but it still creates portrait (MS PDF printer, local/app and web). I am printing using "PrintDataWindow" (same code as above for Sep 23rd).

Attached are the "print specifications" for the DW.
Chris Pollach 23 September, 2019
If your printing two or more DWO's on the same page - then you would use the orientation of the widest DW. If you use the "PrintDataWindow" command, then it will print each DWO with the orientation its set to.
Igor G 23 September, 2019
But nested or composite DW's cannot have updatable DW's with events, right?

OK, how about forcing a landscape print?
Chris Pollach 23 September, 2019
Hi Igor;

   The PrintDataWindow() command forces each DW to start printing on a new page (as stated in the PB Help). The only way to have multiple DWO's print one after the other is to use either a NESTED or COMPOSITE DataWindow to control how the child DWO's print (with or without a new page).

Regards ... Chris
Igor G 23 September, 2019
Good morning Chris,

If I have 2 data windows, and I'd like to print them one after another....
- The data windows have it specified in the print specifications that they should be printed in Landscape mode, but by default they still print in Portrait
- The data windows print on separate pages - is there a way to make them print one after the other?

long jb

printsetup()

jb = PrintOpen()

PrintDataWindow (jb, dw_member_report)
PrintDataWindow (jb, dw_member_report_detail)

PrintClose(jb)
Chris Pollach 19 September, 2019
Hi Igor;

  Unfortunately, the DC does not fire any events for the Child DWO's ... only DDDW's. The CB should show on the parent DWO. I am not sure what the issue is on that aspect.

  From what you would like to do, it should like you need to approach this with separate DWO's. I would suggest a design that uses a Tab Control with each DWO in DW Control in a set of Tab Pages. Then have a Composite or Nested DWO in a DC beside the Tab Control. Each change to a DWO within a tab page forces a refresh of the Composite DC to show any changes. In essence, the Composite DWO becomes like a "Print Preview" of what has changed in the Tab Control's DWOs.

Food for thought.

Regards ... Chris
Igor G 19 September, 2019
1) Command buttons in header still do not show. I copied a button to the main body of the DW, but it still does not show
2) How would I handle events for the nested data window(s)?
Chris Pollach 19 September, 2019
  You would use the "Insert Report" from the DW Painter's menu.
Igor G 19 September, 2019
Screen Shot 2019-09-19 at 12.16.59 PM.png (127KB)

So, I actually tried to do a nested DW originally. But I cannot insert a DW as a control. How do I nest it?
Chris Pollach 19 September, 2019
Hi Igor;

  You would basically rebuild the parent DW as a normal DWO (Grid, FreeForm, etc) and then add your child DWO's. Positioning them as required like in your Composite. The only difference is the Retrieval Argument mapping of the child DWO's to column(s) in the parent DW.

  Another suggestion would be to continue with your Composite design. Some PB developers have gotten around the lack of CommandButton interaction by placing a real CB over top of the DW Control and interacting with this control to change the DWO behaviour underneath it. Of course to the end user ... any control(s) floating on top of the DWO header look like one. Especially, if they are transparent. 

Regards ... Chris
Igor G 19 September, 2019
How do I convert it? Is there a value in the source code I can change?
Chris Pollach 19 September, 2019
  Yes .... both Nested and Composite DW's can hold up to 255 child DWO's.
Igor G 19 September, 2019
Chris,

I am basically attempting to be able to print both DW's at once (via container DW). Will a nested DW be able to house 2 DW's?

- Igor
Chris Pollach 19 September, 2019
Hi Igor;

  Composite DW(s) are not designed for update interaction. This type of DW style was specifically designed for reporting only.

  If you want to have a similar look & feel but also user interaction, please convert your Composite DW into a NESTED DW type. This would allow the behaviour you are seeking input & user interaction wise.

  The other alternative is to use the DWOs you already have but one at a time in a separate DW Control. However, you can arrange the cluster of DC's to still look like a Composite or Nested DW.

Regards ... Chris
Igor G 18 September, 2019
What is not showing in the top DW, are the buttons I've put in the header.

In addition, I don't see a way to use event handlers on the child DW's of the composite DW.
Igor G 18 September, 2019
Please scratch my last question. The bottom DW is showing.
Igor G 18 September, 2019
Thanks, I understand about the preview now.

- Are the DW windows in a composite DW updatable, or do they have to be reports?
- Are items in a DW's header updatable?
- A problem I am also having is that the bottom DW (in the composite) is not showing at all for some reason
Chris Pollach 18 September, 2019
Hi Igor;

  OK ... Zzzzz - Yes, a "Composite" DW will always display in "Print Preview" mode. This mode always displays the margins as a blue line by default.

Note1: You can remove the blue line from the display. Open the parent DWO and uncheck the "Print Preview Shows Outline" checkbox in the "Print Specifications" properties pane tab.

Note2: In the "Print Specifications" tab page, you can also remove the "margins (blue line areas) by setting the various "margin" proprieties to Zero (0).

HTH
Regards ... Chris
Igor G 18 September, 2019
Screen Shot 2019-09-18 at 1.51.40 PM.png (21KB)

The "default print" is "Microsoft Print To PDF". I changed the default to a real printer, but it didn't help. See another screenshot attached.
Igor G 18 September, 2019
Screen Shot 2019-09-18 at 1.45.57 PM.png (59KB)

"Blue line" in composite DW (Design mode). Looks the same when ran.
Igor G 18 September, 2019
Screen Shot 2019-09-18 at 1.38.30 PM.png (37KB)

Design view of the composite DW
Igor G 18 September, 2019
/***** composite container ********/

release 17;
datawindow(units=0 timer_interval=0 color=1073741824 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=5 HTMLDW=no print.printername="" print.documentname="" print.orientation = 1 print.margin.left = 100 print.margin.right = 100 print.margin.top = 50 print.margin.bottom = 50 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no 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="" )
header(height=0 color="536870912" 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="536870912" 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=0 color="536870912" 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=1132 color="536870912" 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" height.autosize=yes )
table(column=(type=char(10) updatewhereclause=yes name=a dbname="a" )
 unbound = "yes")
report(band=detail dataobject="do_main" x="0" y="0" height="340" width="9810" border="0" enabled="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"  height.autosize=yes criteria="" trail_footer = yes  name=dw_emp_rpt visible="1"  slideup=directlyabove )
report(band=detail dataobject="do_member_report_detail" x="0" y="352" height="768" width="9810" 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"  height.autosize=yes criteria="" trail_footer = yes  name=dw_emp_rpt_det visible="1"  slideup=directlyabove )
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=0 distill.custompostscript="0" xslfop.print="0" nativepdf.customsize=0 nativepdf.customorientation=0 nativepdf.pdfstandard=0 nativepdf.useprintspec=no )
export.xhtml()

/*********** end composite container ************/

/*********** "top" DW in container **************/

release 17;
datawindow(units=0 timer_interval=0 color=67108864 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=0 HTMLDW=yes print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no 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="" )
header(height=524 color="536870912" 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="536870912" 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=0 color="536870912" 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=0 color="536870912" 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" height.autosize=yes )
table(column=(type=char(15) update=yes updatewhereclause=yes key=yes identity=yes name=rpt_number dbname="emp_rpt.rpt_number" )
 column=(type=char(15) update=yes updatewhereclause=yes name=job_number dbname="emp_rpt.job_number" )
 column=(type=char(5) update=yes updatewhereclause=yes name=sel_lid dbname="emp_rpt.local_id" )
 column=(type=datetime update=yes updatewhereclause=yes name=from_date dbname="emp_rpt.from_date" )
 column=(type=datetime update=yes updatewhereclause=yes name=to_date dbname="emp_rpt.to_date" )
 column=(type=char(1024) update=yes updatewhereclause=yes name=job_name dbname="emp_rpt.job_name" )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"emp_rpt~" ) COLUMN(NAME=~"emp_rpt.rpt_number~") COLUMN(NAME=~"emp_rpt.job_number~") COLUMN(NAME=~"emp_rpt.local_id~") COLUMN(NAME=~"emp_rpt.from_date~") COLUMN(NAME=~"emp_rpt.to_date~") COLUMN(NAME=~"emp_rpt.job_name~")WHERE(    EXP1 =~"~~~"EMP_RPT~~~".~~~"RPT_NUMBER~~~"~"   OP =~"=~"    EXP2 =~":rptnum~" ) ) ARG(NAME = ~"rptnum~" TYPE = string) " update="EMP_RPT" updatewhere=0 updatekeyinplace=yes retrieve.asneeded=yes arguments=(("rptnum", string)) )
rectangle(band=header x="0" y="0" height="160" width="512"  name=r_rid visible="1" brush.hatch="6" brush.color="12639424" pen.style="0" pen.width="5" pen.color="268435456"  background.mode="2" background.color="33554432" 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" )
rectangle(band=header x="512" y="0" height="160" width="695"  name=r_local visible="1" brush.hatch="6" brush.color="12639424" pen.style="0" pen.width="5" pen.color="268435456"  background.mode="2" background.color="33554432" 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" )
rectangle(band=header x="1207" y="0" height="160" width="731"  name=r_sdate visible="1" brush.hatch="6" brush.color="12639424" pen.style="0" pen.width="5" pen.color="268435456"  background.mode="2" background.color="33554432" 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" )
rectangle(band=header x="1938" y="0" height="160" width="731"  name=r_edate visible="1" brush.hatch="6" brush.color="12639424" pen.style="0" pen.width="5" pen.color="268435456"  background.mode="2" background.color="33554432" 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" )
rectangle(band=header x="2670" y="0" height="160" width="366"  name=r_jid visible="1" brush.hatch="6" brush.color="12639424" pen.style="0" pen.width="5" pen.color="268435456"  background.mode="2" background.color="33554432" 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" )
rectangle(band=header x="3035" y="0" height="160" width="1207"  name=r_jname visible="1" brush.hatch="6" brush.color="12639424" pen.style="0" pen.width="5" pen.color="268435456"  background.mode="2" background.color="33554432" 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" )
text(band=header alignment="2" text="Report ID" border="0" color="33554432" x="23" y="36" height="92" width="462" html.valueishtml="0"  name=t_rid visible="1"  font.face="Tahoma" font.height="-13" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="12639424" 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="Local" border="0" color="33554432" x="544" y="36" height="92" width="635" html.valueishtml="0"  name=t_local visible="1"  font.face="Tahoma" font.height="-13" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="12639424" 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="Start Date" border="0" color="33554432" x="1234" y="36" height="92" width="681" html.valueishtml="0"  name=t_sdate visible="1"  font.face="Tahoma" font.height="-13" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="12639424" 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="End Date" border="0" color="33554432" x="1966" y="36" height="92" width="672" html.valueishtml="0"  name=t_edate visible="1"  font.face="Tahoma" font.height="-13" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="12639424" 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="Job ID" border="0" color="33554432" x="2697" y="36" height="92" width="306" html.valueishtml="0"  name=t_jid visible="1"  font.face="Tahoma" font.height="-13" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="12639424" 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="Job Name" border="0" color="33554432" x="3077" y="36" height="92" width="1129" html.valueishtml="0"  name=t_jname visible="1"  font.face="Tahoma" font.height="-13" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="12639424" 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=header id=3 alignment="0" tabsequence=10 border="0" color="33554432" x="539" y="172" height="92" width="640" format="[general]" html.valueishtml="0"  name=sel_lid visible="1" dddw.name=do_local dddw.displaycolumn=local_name dddw.datacolumn=local_id dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=yes dddw.case=any  font.face="Tahoma" font.height="-14" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" 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=header id=1 alignment="2" tabsequence=32766 border="0" color="33554432" x="18" y="172" height="92" width="471" format="[general]" html.valueishtml="0"  name=rpt_number visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="Tahoma" font.height="-14" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" 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=header id=4 alignment="2" tabsequence=20 border="0" color="33554432" x="1239" y="172" height="92" width="681" format="[shortdate]" html.valueishtml="0"  name=from_date visible="1" edit.name="DateTimeShort" editmask.mask="MM/DD/YYYY"  font.face="Tahoma" font.height="-14" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" 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=header id=5 alignment="2" tabsequence=30 border="0" color="33554432" x="1961" y="172" height="92" width="681" format="[shortdate]" html.valueishtml="0"  name=to_date visible="1" edit.name="DateTimeShort" editmask.mask="MM/DD/YYYY"  font.face="Tahoma" font.height="-14" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" 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=header id=2 alignment="2" tabsequence=40 border="0" color="33554432" x="2702" y="172" height="92" width="302" format="[general]" html.valueishtml="0"  name=job_number visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="Tahoma" font.height="-14" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" 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=header id=6 alignment="2" tabsequence=50 border="0" color="33554432" x="3081" y="172" height="92" width="1129" format="[general]" html.valueishtml="0"  name=job_name visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="Tahoma" font.height="-14" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" 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" )
button(band=header text="" filename="images\Update_Report.png" enabled=yes originalsize=yes action="0" border="0" color="33554432" x="183" y="324" height="156" width="768" vtextalign="0" htextalign="0"  name=b_update visible="1"  font.face="Tahoma" font.height="-14" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" background.transparency="100" background.gradient.color="8421504" background.gradient.transparency="100" 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="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.tip="Click here to update the report..." tooltip.transparency="0" transparency="100" )
button(band=header text="" filename="images\Duplicate_Report.png" enabled=yes originalsize=yes action="0" border="0" color="33554432" x="1202" y="324" height="156" width="768" vtextalign="0" htextalign="0"  name=b_dup visible="1"  font.face="Tahoma" font.height="-14" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" background.transparency="100" background.gradient.color="8421504" background.gradient.transparency="100" 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="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.tip="Click here to make a copy of the report..." tooltip.transparency="0" transparency="0" )
button(band=header text="" filename="images\Print_Report.png" enabled=yes originalsize=yes action="0" border="0" color="33554432" x="2277" y="324" height="156" width="768" vtextalign="0" htextalign="0"  name=b_print visible="1"  font.face="Tahoma" font.height="-14" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" background.transparency="100" background.gradient.color="8421504" background.gradient.transparency="100" 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="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.tip="Click here to print the report..." tooltip.transparency="0" transparency="0" )
button(band=header text="" filename="images\Delete_Report.png" enabled=yes originalsize=yes action="0" border="0" color="33554432" x="3319" y="324" height="156" width="768" vtextalign="0" htextalign="0"  name=b_delete visible="1"  font.face="Tahoma" font.height="-14" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" background.transparency="100" background.gradient.color="8421504" background.gradient.transparency="100" 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="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.tip="Click here to delete the report..." tooltip.transparency="0" transparency="0" )
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=0 distill.custompostscript="0" xslfop.print="0" nativepdf.customsize=0 nativepdf.customorientation=0 nativepdf.pdfstandard=0 nativepdf.useprintspec=no )
export.xhtml()

/**************** end "top" DW in container *************/

/**************** "bottom" DW in container *************/

release 17;
datawindow(units=0 timer_interval=0 color=1073741824 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=0 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no 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="" )
header(height=164 color="536870912" 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="536870912" 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=144 color="536870912" 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" height.autosize=yes )
detail(height=148 color="536870912~tif(describe(~"DataWindow.ReadOnly~") = ~"no~" and getrow() = currentrow(), rgb(192,192,192), rgb (255,255,255))" 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(15) update=yes updatewhereclause=yes key=yes name=rpt_number dbname="emp_rpt_det.rpt_number" )
 column=(type=datetime update=yes updatewhereclause=yes key=yes name=rpt_date dbname="emp_rpt_det.rpt_date" )
 column=(type=decimal(2) update=yes updatewhereclause=yes name=hours_paid dbname="emp_rpt_det.hours_paid" )
 column=(type=char(9) update=yes updatewhereclause=yes key=yes name=mem_ss_number dbname="member.member_ss_number" )
 column=(type=char(50) updatewhereclause=yes name=member_name_first dbname="member.member_name_first" )
 column=(type=char(50) updatewhereclause=yes name=member_name_middle dbname="member.member_name_middle" )
 column=(type=char(50) updatewhereclause=yes name=member_name_last dbname="member.member_name_last" )
 column=(type=char(3) updatewhereclause=yes name=member_stamp_type dbname="member.stamp_type" )
 column=(type=char(1) update=yes updatewhereclause=yes name=member_level dbname="member_level.member_level" )
 column=(type=char(25) updatewhereclause=yes name=member_level_description dbname="member_level.description" )
 column=(type=decimal(4) update=yes updatewhereclause=yes name=hourly_rate dbname="emp_rpt_det.hourly_rate" )
 column=(type=char(1) update=yes updatewhereclause=yes name=delete_flag dbname="emp_rpt_det.delete_flag" )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"emp_rpt~" )  TABLE(NAME=~"emp_rpt_det~" )  TABLE(NAME=~"member~" )  TABLE(NAME=~"member_level~" ) COLUMN(NAME=~"emp_rpt_det.rpt_number~") COLUMN(NAME=~"emp_rpt_det.rpt_date~") COLUMN(NAME=~"emp_rpt_det.hours_paid~") COLUMN(NAME=~"member.member_ss_number~") COLUMN(NAME=~"member.member_name_first~") COLUMN(NAME=~"member.member_name_middle~") COLUMN(NAME=~"member.member_name_last~") COLUMN(NAME=~"member.stamp_type~") COLUMN(NAME=~"member_level.member_level~") COLUMN(NAME=~"member_level.description~") COLUMN(NAME=~"emp_rpt_det.hourly_rate~") COLUMN(NAME=~"emp_rpt_det.delete_flag~")    JOIN (LEFT=~"emp_rpt.rpt_number~"    OP =~"=~"RIGHT=~"emp_rpt_det.rpt_number~" )    JOIN (LEFT=~"emp_rpt_det.member_ss_number~"    OP =~"=~"RIGHT=~"member.member_ss_number~" )    JOIN (LEFT=~"emp_rpt_det.member_level~"    OP =~"=~"RIGHT=~"member_level.member_level~" )WHERE(    EXP1 =~"~~~"EMP_RPT~~~".~~~"EMPLOYER_ID~~~"~"   OP =~"=~"    EXP2 =~":empid~"    LOGIC =~"And~" ) WHERE(    EXP1 =~"~~~"EMP_RPT~~~".~~~"RPT_NUMBER~~~"~"   OP =~"=~"    EXP2 =~":repid~" ) ) ARG(NAME = ~"empid~" TYPE = string)  ARG(NAME = ~"repid~" TYPE = string) " update="EMP_RPT_DET" updatewhere=1 updatekeyinplace=yes arguments=(("empid", string),("repid", string)) )
rectangle(band=header x="0" y="0" height="160" width="699"  name=r_ssn visible="1" brush.hatch="6" brush.color="15780518" pen.style="0" pen.width="5" pen.color="1073741824"  background.mode="2" background.color="268435456" 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" )
rectangle(band=header x="699" y="0" height="160" width="1024"  name=r_ename visible="1" brush.hatch="6" brush.color="15780518" pen.style="0" pen.width="5" pen.color="1073741824"  background.mode="2" background.color="268435456" 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" )
rectangle(band=header x="1719" y="0" height="160" width="800"  name=r_elevel visible="1" brush.hatch="6" brush.color="15780518" pen.style="0" pen.width="5" pen.color="1073741824"  background.mode="2" background.color="268435456" 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" )
rectangle(band=header x="2519" y="0" height="160" width="439"  name=r_hours visible="1" brush.hatch="6" brush.color="15780518" pen.style="0" pen.width="5" pen.color="1073741824"  background.mode="2" background.color="268435456" 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" )
rectangle(band=header x="2958" y="0" height="160" width="293"  name=r_rate visible="1" brush.hatch="6" brush.color="15780518" pen.style="0" pen.width="5" pen.color="1073741824"  background.mode="2" background.color="268435456" 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" )
rectangle(band=header x="3250" y="0" height="160" width="987"  name=r_paid visible="1" brush.hatch="6" brush.color="15780518" pen.style="0" pen.width="5" pen.color="1073741824"  background.mode="2" background.color="268435456" 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" )
text(band=header alignment="2" text="Employee SSN" border="0" color="33554432" x="23" y="28" height="100" width="649" html.valueishtml="0"  name=t_ssn visible="1"  font.face="Tahoma" font.height="-13" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="15780518" 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="4" 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="Employee Name" border="0" color="33554432" x="731" y="28" height="100" width="960" html.valueishtml="0"  name=t_ename visible="1"  font.face="Tahoma" font.height="-13" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="15780518" 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="4" 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="Employee Level" border="0" color="33554432" x="1751" y="28" height="100" width="741" html.valueishtml="0"  name=t_elevel visible="1"  font.face="Tahoma" font.height="-13" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="15780518" 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="4" 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="Hours Paid" border="0" color="33554432" x="2551" y="28" height="100" width="379" html.valueishtml="0"  name=t_hours visible="1"  font.face="Tahoma" font.height="-13" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="15780518" 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="4" 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="Rate" border="0" color="33554432" x="2981" y="28" height="100" width="242" html.valueishtml="0"  name=t_rate visible="1"  font.face="Tahoma" font.height="-13" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="15780518" 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="4" 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="Contribution" border="0" color="33554432" x="3282" y="28" height="100" width="928" html.valueishtml="0"  name=t_paid visible="1"  font.face="Tahoma" font.height="-13" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="15780518" 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="4" 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" )
rectangle(band=detail x="27" y="4" height="140" width="4229"  name=item_selection_rectangle visible="0" brush.hatch="3" brush.color="16777215" pen.style="0" pen.width="5" pen.color="134217741"  background.mode="2" background.color="16777215" background.transparency="40" 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" )
column(band=detail id=4 alignment="2" tabsequence=10 border="1~tif(describe(~"DataWindow.ReadOnly~") = ~"no~" and getrow() = currentrow(), 1, 0)" color="33554432" x="55" y="20" height="100" width="526" format="[general]" html.valueishtml="0"  name=mem_ss_number visible="1" edit.name="" editmask.mask="###-##-####" editmask.focusrectangle=no  font.face="Tahoma" font.height="-12" 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" )
compute(band=detail alignment="0" expression="member_name_first  + (if (isNull (member_name_middle), ~"~", ~" ~" + member_name_middle)) + ~" ~" +  member_name_last"border="0" color="33554432" x="741" y="20" height="100" width="960" format="[GENERAL]" html.valueishtml="0"  name=mem_name visible="1"  font.face="Tahoma" font.height="-12" 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=10 alignment="0" tabsequence=20 border="0" color="33554432" x="1737" y="20" height="100" width="750" format="[general]" html.valueishtml="0"  name=member_level_description visible="1" dddw.name=do_member_level dddw.displaycolumn=description dddw.datacolumn=member_level dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=yes dddw.case=any dddw.vscrollbar=yes  font.face="Tahoma" font.height="-12" 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=3 alignment="1" tabsequence=30 border="0~tif(describe(~"DataWindow.ReadOnly~") = ~"no~" and getrow() = currentrow(), 1, 0)" color="33554432" x="2606" y="20" height="100" width="261" format="###0.00" html.valueishtml="0"  name=hours_paid visible="1" editmask.mask="####.0" editmask.focusrectangle=no  font.face="Tahoma" font.height="-12" 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=11 alignment="1" tabsequence=32766 border="0" color="33554432" x="2971" y="20" height="100" width="242" format="#00.00" html.valueishtml="0"  name=hourly_rate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="Tahoma" font.height="-12" 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" )
compute(band=detail alignment="1" expression="hours_paid * hourly_rate"border="0" color="33554432" x="3282" y="20" height="100" width="389" format="#,#00.00" html.valueishtml="0"  name=contribution visible="1"  font.face="Tahoma" font.height="-12" 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" )
bitmap(band=detail filename="images\Save_Item3.png" x="3799" y="28" height="96" width="197" 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=but_save_item visible="0~tIf (getrow() = currentrow() and isRowModified(), 1, 0)" transparency="0" )
bitmap(band=detail filename="images\Delete_Item3.png" x="4014" y="24" height="100" width="110" 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=but_del_item visible="0~tIf (describe(~"DataWindow.ReadOnly~") = ~"no~" and getrow() = currentrow(), 1, 0)" transparency="0" )
text(band=footer alignment="0" text="Totals:" border="0" color="33554432" x="2313" y="8" height="76" width="238" html.valueishtml="0"  name=t_total visible="1"  font.face="Tahoma" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" 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="sum(hours_paid for all)"border="0" color="33554432" x="2606" y="8" height="64" width="270" format="[GENERAL]" html.valueishtml="0"  name=t_hours_tot visible="1"  font.face="Tahoma" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" 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="sum(contribution for all)"border="0" color="33554432" x="3282" y="8" height="64" width="389" format="###,###.00" html.valueishtml="0"  name=t_contrib_tot visible="1"  font.face="Tahoma" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" 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" )
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=0 distill.custompostscript="0" xslfop.print="0" nativepdf.customsize=0 nativepdf.customorientation=0 nativepdf.pdfstandard=0 nativepdf.useprintspec=no )
export.xhtml()


/********************** end "bottom" DW in container ****************/
Chris Pollach 18 September, 2019
Hi Igor;

  I cannot say that I have ever seen this problem in any version of PB or IM.

1) Can you attach a screen capture of what you are seeing?
2) Can you provide the DWO source for the Composite parent & child DWO's?

Note: The DWO gets it's drawing prowess from the "default" printer. Have you tried changing the MS-Windows default printer & then testing the composite rendering again?

Regard ... Chris
Igor G 18 September, 2019
Can a "composite datawindow" contain UPDATABLE data windows, not just reports?

1) Any way to get rid of the blue line (presumably printing border)?
2) I cannot get to the "bottom" of the composite data window, with even a small DW inside. No matter how much I stretch it down, I cannot get to the bottom border (of the blue line).
3) Are any items in the header of a DW (any DW) updatable?
OS:
Windows Server 2016 
Platform:
64-bit 
Database Type:
Oracle 
Database Version:
12x