FLOMS1
9GrZC2FZ+shieO2cYwSxXtFq2SjGSlHZckfoyXdsZU/5xJ/CxUtL/XpdOdxkcGQP43BTC01Me8jiR6HE5QDgI9nEuSthaEPxRk2h9OoA4HvfcNmDxVmSmelP0fBieGIzjWBlK8ZfQvViSf2sYwQiM8Ug0YhOBfOFRQ==
FLOMS1
C_Detail_ShipLog
SHPACK_Seqid,System.Int32
SystemDate,System.String
StandardName,System.String
SystemTime,System.String
SHPACK_ACTUALFREIGHT,System.Decimal
SHPACK_ACTUALADDLCHARGES,System.Decimal
Markup,System.Decimal
SHPACK_PUBFREIGHT,System.Decimal
SHPACK_PUBADDLCHARGES,System.Decimal
Sort,System.String
CSTPRJ_Id,System.String
Sort2,System.String
whrqst_seqid,System.Int32
SHPACK_WeightLbs,System.Double
shpack_trackingid,System.String
PICPAK_SEQID,System.Int32
PickSlip,System.String
orders_seqid,System.Int32
orders_id,System.String
orders_PONum,System.String
SHPACK_DateShipped,System.DateTime
OBYPrefix,System.String
OBYFirstName,System.String
OBYMiddleName,System.String
OBYLastName,System.String
OBYSuffix,System.String
OBYCompany,System.String
OBY_ADDRESS1,System.String
OBY_ADDRESS2,System.String
OBY_ADDRESS3,System.String
OBY_CITY,System.String
OBY_STATE,System.String
OBY_POSTALCODE,System.String
OBY_COUNTRY,System.String
OBY_PHONE,System.String
OBY_EMAIL,System.String
stoPrefix,System.String
stoFirstName,System.String
stoMiddleName,System.String
stoLastName,System.String
stoSuffix,System.String
stoCompany,System.String
STO_ADDRESS1,System.String
STO_ADDRESS2,System.String
STO_ADDRESS3,System.String
STO_CITY,System.String
STO_STATE,System.String
STO_POSTALCODE,System.String
STO_COUNTRY,System.String
STO_PHONE,System.String
STO_EMAIL,System.String
FGTCAR_Name,System.String
FGTSVC_DESCRIPTION,System.String
30
C_Detail_ShipLog
FLOMS1
select * from C_Detail_ShipLog
C_ShipLog_SubRpt
pickdt_seqid,System.Int32
picpak_seqid,System.Int32
prvers_seqid,System.Int32
prduct_Seqid,System.Int32
prduct_partnumber,System.String
prduct_description,System.String
prdord_toshipqty,System.Int32
prvers_version,System.String
PICKSN_SerialNumber,System.String
30
C_ShipLog_SubRpt
FLOMS1
select * from C_ShipLog_SubRpt
DSSS
picpak_seqid
DSSS
Relation1
PICPAK_SEQID
,StartDate,StartDate,,System.String,,False,False,False,False
,EndDate,EndDate,,System.String,,False,False,False,False
,ClientName,ClientName,,System.String,,False,False,False,False
,SystemID,SystemID,,System.String,,False,False,False,False
,TimeZone,TimeZone,,System.String,,False,False,False,False
,sortby,sortby,,System.String,,False,False,False,False
,PhoneEmail,PhoneEmail,,System.String,,False,False,False,False
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.2,10.22,1
True
All;[47:54:153];1;Solid;True;3;[47:54:153]
Transparent
3.3,0,3.52,1
Arial,9.75,Regular,Point,False,0
Center
0,0,0,0
Text3
<font size="20" color="blue"><b>DETAIL SHIPPING LOG</b></font><br>
Start Date: {StartDate} End Date: {EndDate}<br>
{TimeZone}<br>
Sort first by: {sortby}<br>
Phone/Email: {PhoneEmail}
Black
Wysiwyg
Expression
Center
True
Transparent
True
8.3,0,1.1,1
Arial,9.75,Regular,Point,False,0
0,0,0,0
Text4
Date: <br>
Time: <br>
{TimeZone}
Black
,,,,WordWrap=True,A=0
Wysiwyg
Expression
True
Transparent
9.4,0,0.8,1
Arial,9.75,Regular,Point,False,0
b51db0db0d5b4f2ab279d9c89f748055
Right
0,0,0,0
Text5
{Format("{0:MM/dd/yyyy}", Today)}<br>
{Format("{0:HH:mm}", Time)}
Black
Wysiwyg
Expression
True
Transparent
0,0,1,1
Arial,9.75,Regular,Point,False,0
0,0,0,0
Text6
<b>{ClientName}</b>
<br>
<br><font color="blue">
System ID: <br>
Client Name:
</font>
Black
Wysiwyg
Expression
True
Transparent
1,0,1,1
Arial,9.75,Regular,Point,False,0
e709c774b14f4ec89a5cfb0123d3d93b
0,0,0,0
Text7
<br>
<br>
{SystemID} <br>
{ClientName}
Black
Wysiwyg
Expression
PageHeaderBand1
Transparent
0,7.52,10.22,0.2
Transparent
0,0,10.22,0.2
Fill
Arial,8
Center
0,0,0,0
Text1
{PageNofM}
Black
Expression
Center
Transparent
0,0,1.62,0.2
Left
Arial,8
0,0,0,0
Text2
*Request for Shipping
Black
Expression
Center
PageFooterBand1
Transparent
0,1.6,10.22,0.9
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
0,0.2,0.9,0.4
Arial,9,Bold,Point,False,0
0,0,0,0
Text8
Order #
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
1,0.2,0.5,0.4
Arial,9,Bold,Point,False,0
1cd738de15e64a71a91070748ddacadb
0,0,0,0
Text9
Pick Slip ID
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
1.6,0.2,1,0.4
Arial,9,Bold,Point,False,0
b44e9fcf232841beac8e30ef1cef5400
0,0,0,0
Text10
Ordered By
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
2.7,0.2,0.9,0.4
Arial,9,Bold,Point,False,0
87ffaa419d18479c9543092c6120c315
0,0,0,0
Text11
Product ID/ Version
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
3.7,0.2,1.6,0.4
Arial,9,Bold,Point,False,0
beee04b8d7ed468bb24d121ea806cfd4
0,0,0,0
Text12
Product Description
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
5.4,0.2,0.6,0.4
Arial,9,Bold,Point,False,0
c5ecd370f7c8429b9fbd04c686a0f301
Right
0,0,0,0
Text13
Quantity Shipped
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
6.1,0.2,0.6,0.4
Arial,9,Bold,Point,False,0
16a645d49b6043b9984fb213357923d2
0,0,0,0
Text14
Serial #
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
6.8,0.2,1,0.4
Arial,9,Bold,Point,False,0
7530b530ae8b45e39d3688951656525c
0,0,0,0
Text15
Tracking #
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
7.9,0.2,1.1,0.4
Arial,9,Bold,Point,False,0
3eca626af18d47ccba3f9291c6468968
Center
0,0,0,0
Text16
Freight Carrier/Service
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
9.1,0.2,0.5,0.4
Arial,9,Bold,Point,False,0
bbeef8a8b9c0444695bd48a5897431b3
Right
0,0,0,0
Text17
Weight
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Bottom;[10:17:255];2;Solid;False;4;Black
Transparent
9.7,0.2,0.5,0.4
Arial,9,Bold,Point,False,0
43ae295e58cf439a87269a7f0b244240
Right
0,0,0,0
Text18
Freight
Blue
,,,,WordWrap=True,A=0
Expression
Bottom
Transparent
True
0,0.7,10.2,0.2
Arial,9
0,0,0,0
Text23
The third name down should show asian characters. These are the characters it should show: 庙号吕洞宾.
These characters show up as static text, but they do not show up when they are pulled in from the database as a field.
However, it does show up in the HTML preview, just not the Web preview.
Black
Expression
HeaderBand1
Transparent
0,2.9,10.22,0.2
Transparent
0,0,10.22,0.2
Fill
Arial,9.75,Bold,Point,False,0
0,0,0,0
Text19
{Format("{0:MM/dd/yyyy}", C_Detail_ShipLog.SHPACK_DateShipped)}
Black
Expression
Bottom
{Format("{0:MM/dd/yyyy}", C_Detail_ShipLog.SHPACK_DateShipped)}
GroupHeaderBand1
Transparent
0,3.5,10.22,0.3
Transparent
True
0,0,0.9,0.3
Arial,9,Regular,Point,False,0
0,0,0,0
Text20
{C_Detail_ShipLog.orders_id}
Black
,,,,WordWrap=True,A=0
DataColumn
Transparent
True
1,0,0.5,0.3
Arial,9,Regular,Point,False,0
2a619e402fcd47e18c14425085653f01
0,0,0,0
Text21
{C_Detail_ShipLog.PickSlip}
Black
,,,,WordWrap=True,A=0
DataColumn
True
Transparent
True
1.6,0,1,0.3
Arial Unicode MS,9
8ec826145c9e4cebb8d2a02afc367dc6
0,0,0,0
Text22
{C_Detail_ShipLog.OBYFirstName} {C_Detail_ShipLog.OBYLastName}
Black
,,,,WordWrap=True,A=0
Wysiwyg
Expression
Transparent
7,0,3.2,0.3
Arial,9
0,0,0,0
Text24
This is an example of the static text showing up in a databand: 庙号吕洞宾
Black
,,,,WordWrap=True,A=0
Expression
C_Detail_ShipLog
DataBand1
ASC
orders_id
4be481870af24f70b79ee25bf64c34fb
0.39,0.39,0.39,0.39
Page1
Landscape
8.5
11
Letter
Arial,100
[50:0:0:0]
268435455
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Report
8/15/2016 9:29:26 AM
7/13/2016 9:08:47 AM
\\prog044\users\aschwarm\Downloads\DSL Template.mrt
22d5564367d24191b7ffa8c01d3ee5ae
Report
Inches
2016.1.0
CSharp