!!Version!!10.0.25.0
!!SourceTables!!SQLUser_Payment_History
!!TableCount!!0
!!EmbedExpressions!!True
!!ReportField!!dbo!!SQLUser_Payment_History!!ACCOUNT_NUM!!Data Field!!
!!ReportField!!dbo!!SQLUser_Payment_History!!OCCURENCE_DATE!!Data Field!!
!!ReportField!!dbo!!SQLUser_Payment_History!!LAST_WORK_DATE!!Data Field!!
!!ReportField!!dbo!!SQLUser_Payment_History!!WAIT_DATE!!Data Field!!
!!AdvancedFilteringOption!!False
!!AdvancedFiltering!! (dbo.SQLUser_Payment_History.ACCOUNT_NUM IN (7386063,7387176,7388624,7392214,7392716,7392830,7401323,7402068,7403000,7405544,7408563,7408563,7408563))
!!ReportTable!!dbo.SQLUser_Payment_History!!SQLUser_Payment_History!!dbo!!30!!25!!400!!300!!False!!!!False
!!FromStatement!!
!!HavingStatement!!
!!CSGrouping!!True
!!CSSorting!!True
!!ReplaceNumericNulls!!True
!!ChartType!!
!!GraphValueType!!
!!ChartOption1!!
!!ChartOption2!!
!!ShowTrend!!False
!!ChartTitle!!
!!SortByY!!False
!!ShowAvg!!False
!!Animate!!False
!!SmartLabels!!False
!!3D!!False
!!Chart1ShowLegend!!False
!!Chart1DateTime!!False
!!Chart1ML1!!
!!Chart1ML2!!
!!Chart1ML3!!
!!Chart1ML4!!
!!Chart1ML5!!
!!Chart1BollingerBands!!False
!!ChartType2!!
!!GraphValueType2!!
!!ChartOption1_2!!
!!ChartOption2_2!!
!!ShowTrend2!!False
!!ChartTitle2!!
!!SortByY2!!False
!!ShowAvg2!!False
!!Animate2!!False
!!SmartLabels2!!False
!!3D2!!False
!!Chart2ShowLegend!!False
!!Chart2DateTime!!False
!!Chart2ML1!!
!!Chart2ML2!!
!!Chart2ML3!!
!!Chart2ML4!!
!!Chart2ML5!!
!!Chart2BollingerBands!!False
!!ChartAdvanced!!True
!!ExportTitle!!
!!ExportSubTitle1!!
!!ExportSubTitle2!!
!!ExportImage!!
!!ExportImageXAxis!!1
!!ExportImageYAxis!!1
!!ExportImageHeight!!160
!!ExportImageWidth!!160
!!ExportTitleLocation!!
!!ExportFirstRow!!
!!ExportAlternateRowColor!!False
!!DateGroupingOptions!!
!!DateGroupingIndex!!0
!!SummaryOnlyView!!False
!!SelectDistinct!!False
!!AdvancedDetails!!
!!UseAdvancedQuery!!False
!!GaugeValue!!
!!GaugeAggregate!!SUM
!!GaugeTotal!!False
!!GaugeBackGround!!White
!!GaugeTitleColor!!Black
!!INORDER!!False
!!CityLocation!!
!!StateLocation!!
!!ShowDetail!!False
!!MapType!!US
!!MapState!!
!!Value!!
!!FinishedReportDataTable!!Details
!!SummaryPivotTable!!False
!!ExpandableGroups!!False
!!VisualizeAutoRefresh!!False
!!VisualizeInterval!!10
!!VisualizeSlideShow!!False
!!VisualizeSlideShowInterval!!30
!!RestoreBetweenSlides!!False
!!NativeSQL!!False
!!UseTableAlias!!True
!!DefaultControl!!Details
!!VoVSummaryType!!
!!VoVConnection!!
!!VoVType!!
!!VoVViewPath!!
!!VoVViewName!!
!!VoVUnionAll!!False
!!MDXCube!!
!!NullValueText!!
!!NumberOfParameterPages!!1
!!StartDVGDetails!!
@3,Width=1.6@3,Height=1.6
False
False
false
CellSelect
true
VisibleAlways
false
true
true
True
True
true
True
true
false
true
2
-1
-1
0
-1
Always
Auto
-1
-1
{0}: [#image]{1} {2}
-1
-1
-1
LiveVertScroll, LiveHorzScroll
CellFocus
0
true
-1
colACCOUNT_NUM
Far
26
ACCOUNT_NUM
0
true
208
40
0
colOCCURENCE_DATE
Far
2
OCCURENCE_DATE
1
true
240
40
0
colLAST_WORK_DATE
Far
2
LAST_WORK_DATE
2
true
238
40
0
colWAIT_DATE
Far
2
WAIT_DATE
3
true
173
40
0
Default
true
Top
GridView1
350
false
!!EndDVGDetails!!
!!StartDVGDetailsAlternate!!
@3,Width=1.6@3,Height=1.6
False
False
false
CellSelect
true
VisibleAlways
false
true
true
True
True
true
True
true
false
true
2
-1
-1
0
-1
Always
Auto
-1
-1
{0}: [#image]{1} {2}
-1
-1
-1
LiveVertScroll, LiveHorzScroll
CellFocus
0
true
-1
colACCOUNT_NUM
Far
26
ACCOUNT_NUM
0
true
208
40
0
colOCCURENCE_DATE
Far
2
OCCURENCE_DATE
1
true
240
40
0
colLAST_WORK_DATE
Far
2
LAST_WORK_DATE
2
true
238
40
0
colWAIT_DATE
Far
2
WAIT_DATE
3
true
173
40
0
Default
true
Top
GridView1
350
false
!!EndDVGDetailsAlternate!!
!!StartDVGSummary!!
@3,Width=1.6@3,Height=1.6
False
False
false
CellSelect
true
VisibleAlways
false
true
true
True
True
true
True
true
false
true
2
-1
-1
0
-1
Always
Auto
-1
-1
{0}: [#image]{1} {2}
-1
-1
-1
LiveVertScroll, LiveHorzScroll
CellFocus
0
true
-1
Default
true
Top
GridView2
350
false
!!EndDVGSummary!!
!!StartDVGSummaryAlternate!!
@3,Width=1.6@3,Height=1.6
False
False
false
CellSelect
true
VisibleAlways
false
true
true
True
True
true
True
true
false
true
2
-1
-1
0
-1
Always
Auto
-1
-1
{0}: [#image]{1} {2}
-1
-1
-1
LiveVertScroll, LiveHorzScroll
CellFocus
0
true
-1
Default
true
Top
GridView2
350
false
!!EndDVGSummaryAlternate!!
!!StartChartInfo!!
!!EndChartInfo!!
!!StartGaugeInfo!!
~Xtra#NULL
Empty
true
~Xtra#NULL
6
6
@4,Width=2151@4,Height=1042
Default
{1:F2}
None
Gauges
CircularGauge
@1,X=6@1,Y=6@4,Width=2139@4,Height=1030
true
0
White
White
0
White
White
0
0
Tahoma, 11pt
0, 0, 0, 0
Center
Center
Character
NoClip
Black
true
2
Binary
0
false
125, 125
100
100
-240
60
0
100
0.05
0.05
false
true
true
true
1, 1
0
Circular_Style1_3
4
1
0
-15
true
false
LeftToRight
{0:F0}
true
true
true
1, 1
-3.5
Circular_Style1_4
11
Empty
0
Scales
ArcScaleComponent
circularScaleComponent1
false
0
0.5, 0.5
@3,Width=250@3,Height=250
CircularFull_Default
Empty
1000
BackgroundLayers
circularScaleComponent1
ArcScaleBackgroundLayerComponent
circularBackgroundLayerComponent1
-4.4
0
Circular_Default
Empty
-50
Needles
circularScaleComponent1
ArcScaleNeedleComponent
circularNeedleComponent1
!!EndGaugeInfo!!
!!StartPivotInfo!!
@3,Width=1.6@3,Height=1.6
-1
fieldOCCURENCEDATE
OCCURENCE_DATE
OCCURENCE_DATE
d
DateTime
0
0
32
160
-1
fieldLASTWORKDATE
LAST_WORK_DATE
LAST_WORK_DATE
d
DateTime
1
1
32
160
false
true
Always
200
2
true
true
42
2
!!EndPivotInfo!!
!!StartFilterInfo!!
Filter
Bound
TreeListColumn4
Bound
TreeListColumn4
Bound
AndOr
Bound
Bound
Enabled
Bound
MDS Only
Bound
dbo.SQLUser_Payment_History.ACCOUNT_NUM |
Is any of |
(7386063,7387176,7388624,7392214,7392716,7392830,7401323,7402068,7403000,7405544,7408563,7408563,7408563) |
And |
|
true |
|
!!EndFilterInfo!!
!!StartGroupInfo!!
Filter
Bound
Option
Bound
Returned Name
Bound
Add/Remove
Bound
|
None |
|
|
!!EndGroupInfo!!
!!StartSummaryInfo!!
Field
Bound
Function
Bound
Returned Name
Bound
Add/Remove
Bound
|
Count |
|
|
!!EndSummaryInfo!!
!!StartSortingInfo!!
Field
Bound
Function
Bound
Add/Remove
Bound
|
ASC |
|
!!EndSortingInfo!!
!!StartTableInfo!!
ACCOUNT_NUM
26
False
False
AGY_A_INT
26
False
False
AGY_ATY_FEE
26
False
False
AGY_INT
26
False
False
AGY_LIST3
26
False
False
AGY_LIST4
26
False
False
AGY_MISC1
26
False
False
AGY_PJ_INT
26
False
False
AGY_PRN
26
False
False
AGYPCT_OM_MISC1
1
False
False
AGYPCT_ON_A_INT
1
False
False
AGYPCT_ON_ATY_FEE
1
False
False
AGYPCT_ON_INT
1
False
False
AGYPCT_ON_LIST3
1
False
False
AGYPCT_ON_LIST4
1
False
False
AGYPCT_ON_PJ_INT
1
False
False
AGYPCT_ON_PRN
1
False
False
ALTERNATE_BAL
1
False
False
AMT_APPLIED
26
False
False
AMT_DUE_AGY
26
False
False
AMT_DUE_CLIENT
26
False
False
AMT_OVERPAID
26
False
False
AMT_PD_TO_AGY
26
False
False
AMT_PD_TO_CLT
26
False
False
AMT_REFUNDED
26
False
False
APPLY_TO_A_INT
26
False
False
APPLY_TO_ATYFEE
26
False
False
APPLY_TO_CC
26
False
False
APPLY_TO_CR_BAL
1
False
False
APPLY_TO_INT
26
False
False
APPLY_TO_LIST3
26
False
False
APPLY_TO_LIST4
26
False
False
APPLY_TO_MISC1
26
False
False
APPLY_TO_PJ_INT
26
False
False
APPLY_TO_PRN
26
False
False
ATY_FORW_FEEPCT
1
False
False
ATY_FORW_ID
1
False
False
ATY_FORW_NET_GR
1
False
False
ATYFEE_REPD_AGY
26
False
False
BAL_AFTER_TRANS
26
False
False
BAL_BEFORE_TRAN
26
False
False
BATCH_NUMBER
26
False
False
BILL_BACK_ATY
1
False
False
CASHIER_DATE
1
False
False
CC_REPAID_AGY
26
False
False
CLIENT_BILL_TYP
1
False
False
CLIENT_CREDIT
1
False
False
CLT_BAL_BEF_TRN
26
False
False
COLLECTOR
1
False
False
DATE_OF_ENTRY
2
False
False
DATE_STAMP
1
False
False
DEF_COLL_CREDIT
1
False
False
DEFPCT_ON_A_INT
1
False
False
DEFPCT_ON_ATY_FEE
1
False
False
DEFPCT_ON_INT
1
False
False
DEFPCT_ON_LIST3
1
False
False
DEFPCT_ON_LIST4
1
False
False
DEFPCT_ON_MISC1
1
False
False
DEFPCT_ON_PJ_INT
1
False
False
DEFPCT_ON_PRN
1
False
False
DISP_CODE
1
False
False
DUE_AGENCY
1
False
False
DUE_CLIENT
1
False
False
FEE_TO_OTHER
26
False
False
FEE_TO_OTHER_DEF
26
False
False
G_L_INTERFACE
1
False
False
HISTORY_INDEX_80
26
False
False
HOW_PAYMNT_RCV
1
False
False
INDEX_REVERSED
26
False
False
INT_PAYMNT_CTR
1
False
False
LAST_LTR_SENT
1
False
False
LAST_WORK_DATE
2
False
False
LI3_PAYMNT_CTR
1
False
False
LI4_PAYMNT_CTR
1
False
False
OCCURENCE_DATE
2
False
False
PAID_AGENCY
1
False
False
PAID_CLIENT
1
False
False
PAY_DATE
2
False
False
PAYMENT_CODE
26
False
False
Payment_History_ROWID
1
False
False
PAYMENT_TYPE
1
False
False
PCK_DTE_TO_CASH
26
False
False
PHASE_OF_ACCT
26
False
False
RECOV_ADV_CC
26
False
False
RECOV_COLL_COST
26
False
False
REFERENCE_NUM
1
False
False
REVERSE_CODE
1
False
False
REVERSED_PAY_TYP
1
False
False
SRV_DATE_BL
26
False
False
STEP_INT_SPLIT
1
False
False
STMT_RUN_BL
1
False
False
SUPVSR_OF_COL
1
False
False
TOT_BAL_AFT_TRN
26
False
False
TOT_PAYMENT_AMT
26
False
False
TRANS_STATUS
1
False
False
WAIT_DATE
2
False
False
!!EndTableInfo!!
!!StartMDXColumnInfo!!
Tables
String
Value
String
tvColumnDescription
Bound
!!EndMDXColumnInfo!!
!!StartMDXRowInfo!!
Tables
String
Value
String
tvColumnDescription
Bound
!!EndMDXRowInfo!!
!!StartMDXMeasuresInfo!!
Tables
String
Value
String
tvColumnDescription
Bound
!!EndMDXMeasuresInfo!!
!!StartNotesInfo!!
{\rtf1\deff0 \stshfdbch3\stshfloch2\stshfhich2\stshfbi1{\fonttbl{\f0 Calibri;}{\fbiminor\f1 Times New Roman;}{\fhiminor\f2 Calibri;}{\fdbminor\f3 Times New Roman;}}{\colortbl ;\red0\green0\blue255 ;}{\*\defchp \fcs1\f1\fcs1\f1\hich\af2\loch\af2\dbch\af3\cgrid1\fs22}{\stylesheet {\ql\fcs1\f1\fcs1\f1\hich\af2\loch\af2\dbch\af3\fs22 Normal;}{\*\cs1\fcs1\f1\fcs1\f1\hich\af2\loch\af2\dbch\af3\fs22 Default Paragraph Font;}{\*\cs2\sbasedon1\fcs1\f1\fcs1\f1\hich\af2\loch\af2\dbch\af3\fs22 Line Number;}{\*\cs3\fcs1\f1\fcs1\f1\hich\af2\loch\af2\dbch\af3\fs22\ul\cf1 Hyperlink;}{\*\ts4\tsrowd\fcs1\f1\fcs1\f1\hich\af2\loch\af2\dbch\af3\fs22\ql\tscellpaddfl3\tscellpaddl108\tscellpaddfb3\tscellpaddfr3\tscellpaddr108\tscellpaddft3\tsvertalt\cltxlrtb Normal Table;}{\*\ts5\tsrowd\sbasedon4\fcs1\f1\fcs1\f1\hich\af2\loch\af2\dbch\af3\fs22\ql\trbrdrt\brdrs\brdrw10\trbrdrl\brdrs\brdrw10\trbrdrb\brdrs\brdrw10\trbrdrr\brdrs\brdrw10\trbrdrh\brdrs\brdrw10\trbrdrv\brdrs\brdrw10\tscellpaddfl3\tscellpaddl108\tscellpaddfr3\tscellpaddr108\tsvertalt\cltxlrtb Table Simple 1;}}{\*\listoverridetable}{\*\generator DevExpress Office File API/20.1.6.0}{\info{\author Tony Coffman}{\operator Tony Coffman}{\creatim\yr2020\mo11\dy18\hr13\min3}{\revtim\yr2020\mo11\dy18\hr16\min14}{\version12}}\nouicompat\htmautsp\splytwnine\alntblind\expshrtn\spltpgpar\nogrowautofit\utinl\nobrkwrptbl\ftnlytwnine\formshade\sectd\endnhere\pard\plain\ql\fcs1\af1\ltrch\fcs0\hich\af2\dbch\af3\loch\f2\fs22\par{\*\themedata
504b03041400020008000000210201159325ae000000270100000b0000005f72656c732f2e72656c738d8f310ec2300c45af1279a76e1910424dbbb07460415c204a9d34a24da224457036068ec415c8d82206164b5ffe7efffbfd7cd5ed7d1ad98d4234
ce72a88a121859e97a63358739a9cd1edaa63ed3285276c4c1f8c8f2898d1c8694fc0131ca8126110be7c9e68d72611229cba0d10b79159a705b963b0c4b06ac99aceb3984aeaf805d1e9efe613ba58ca4a393f34436fd88f87264b2089a12879499848b
791236b70c454e00864d8dab779b0f504b0304140002000800000021027f624aeb730000007b0000001c0000007468656d652f7468656d652f7468656d654d616e616765722e786d6c0d8cc10d83300c005789fc2f4e7954554460820e61810991888392
b465b73e3a5257a89fa7d3ddeff31da633ede6c5a5c62c1eae9d05c332e7254af0f06cebe50ed338906b1b277e9050e062b491eac8c3d6dae110ebac966a970f16756b2e899a6209b8147aeb2bedd85b7bc34451c0e0f807504b03041400020008000000
21020a5d705ea60000000c010000270000007468656d652f7468656d652f5f72656c732f7468656d654d616e616765722e786d6c2e72656c738dcf3d0ec2300c05e0ab44dea95b068450d32e2c5d11178852278d687e94a408cec6c091b8021113951818
9fecf7597e3d9e6d7fb333bb524cc63b0e4d55032327fd689ce6b064b5d943dfb5279a452e1b693221b1527189c39473382026399115a9f2815c99281fadc825468d41c88bd084dbbade61fc36606db261e41087b10176be07fac7f64a1949472f174b2e
ff3881b974a980226aca1c3eb1a90a030cbb16573f756f504b0304140002000800000021026d52debf9f050000fd1b0000160000007468656d652f7468656d652f7468656d65312e786d6ced594f6fdb3614ff2a84eead2c5b729da06e113b76bb356983
c4ebd0232dd3126b4a14483aa96f437b1c30605837ec3260b71d866d015a608765d887c9d661eb807c8551b42c5136d5244d566c587cb045eaf7deeffde17b22e5939f7eb979fb4944c03e621cd3b86d39d76b1640b14f47380edad6548cafb5acdbb76e
c27511a20801098ef93a6c5ba110c9ba6d735f4e437e9d262896f7c6944550c8210bec118307524944ec7aadd6b42388630bc430426debc1788c7d0406a94a2b57de23f22b163c9df009dbf315a32ea1b0a38993fef019ef1206f621695b9267440f06e8
89b000815cc81b6daba63e16b06fddb47329222a8435c1befa2c043389d1a4ae045930cc259dbebb7663b360a8cf195681bd5eafdb730a8d0a017d5f7aebac80dd7ecbe9e45a35d4fc72557bb7e6d5dc25018da1b122b0d6e974bcb5b240a3107057045a
b5a6bb512f0bb88580b7ea4367a3db6d9605bc42a0b922d0bfb1d6749704142a24389eacc0d3cc1629ca31634aee1af12d896fe56ba180d9da4a9b2b8845d5ba8be063cafa12a0b20c058e819825680c7d89ebc268c830540c701d41ed5636e7f3d5b994
0e709fe144b4adf713280ba4c09c1c7d7772f4029c1c1d1e3f7d79fcf4c7e367cf8e9ffe6092bc0be340977cfdcda77f7df511f8f3c5d7af9f7f5e21c07581dfbefff8d79f3fab400a1df9ea8bc3df5f1ebefaf2933fbe7d6ec26f3038d4f1031c210eee
a303b04ba3d43f03051ab2738a0c42884b2230945013b227c212f2fe0c1223b083ca317cc8645b3022ef4c1f97ecdd0bd9546013f25e189590db94920e65669fee293acda7691c54f0b3a90edc8570df48df5dca726f9ac8958d8d4abb212a99ba4364e2
61806224407a8f4e1032c93dc2b814df6dec33cae95880471874203607668087c22c751747324133a38d32eba5086d3f041d4a8c049b68bf0c95150289512922a568de81530123b3d530223a740b8ad068e8de8cf9a5c07321931e2042416f8438370a3d
60b392c9f7a06c51e615b04d665119ca049e18a15b90521dba4927dd104689d96e1c873af83d3e912b16821d2acc76d072cda4639910185767fe2146e29cc5fe010e42f36249ef4c99b146102dd7e88c8c218a170f80522b8f70fca6be4eb06cec577d7d
a9af6fc8879db19e96bb7925f03fdac337e134de41699d5cb5f0ab167ed5c2df50e1ff44e32e7ab5adefd6959ea872eb3ec684ec8919415b5c75792e5d1cf5e5a41a28a1fca89084f272c15702060caa6bc0a8f8108b702f8489e4711445c033dd010709
e5f28862552a57275e2cbd56735e7e4c957028b6e9683edf289d5f73456a14709daa91aa382b5de3c645e99c39f28c7c8e57c1e7bd99cfd6622acb08c0f47d84d3ac6766721f12344aa33f572d3041bbc81799be45ae2e3d6f3c84239425ce317be634ce
1ac9d6e981d4f8d61a17e53b4be67442b78ad0bb8cd4d54e4b9dbd5ab9242e8fc08134d3ab7b16f0a344eae4693b832488db962f32874e2df665b72b56ac53ab76bb4492302e36210fe762ea56feee272eecae7b6eaaee02869bbad419c91b2de7dd93db
cb0944e3b14c7cc54c31cceed1a9406c2f1c1d802199b25d282d77e74b6a84b97c78d41703268bd3cd565bb9e8b3c5bffc2e292b0a48921066eda9a5e77a8e57d7b9116aa4d9675718ff96be342ed117efffec4bba7ce526b83152a735b9356010a4ebb4
6d5126422adb4d1262bfcfe466429149c3803c06aafe44d277e2a9b1687fd1afec859279770b42b18b03c0b06c71226408ed88ccd353b4398b76989547a629eb2db9c13c99ff0ed13e2283b4729b69082c10e60d248b85022e27ce36d5d830e8ff9b3744
6ed586e8941d4341e59e6783e2eaed5e7b0aac5dd48a733e6deb156ed7bdb33f6d13799e01e9976ce498f9a4d8fe0ea87ac416fb4db924afb5b252cc2787d2ea96ee5faaeb5d6eaf8ab4b4aa56c1a5ee53b5f837aae27f0ae1dbc7df3384df3b57f4edd5
62b6b593901a2dfdb7b698b9f537504b030414000200080000002102e9278183ee00000010020000130000005b436f6e74656e745f54797065735d2e786d6cad914d4ec3301085af62795bc54e5920849274012cf959708191334e2ce21fd993aa9c8d05
47e20a4cd382102a48486c2cd9efcdfb66c66f2fafcd66e727b1c55c5c0cad5cab5a0a0c26f62e0cad9cc9561772d3358fcf098b606b28ad1c89d2a5d6c58ce8a1a89830b06263f6407ccd834e609e60407d56d7e7dac44018a8a27d86ec9a6bb4304f24
6e76fc7cc0669c8a145707e39ed54a486972068875bd0dfd374a752428ae5c3c6574a9acd820853e8958a41f091f85f7bc89ec7a140f90e90e3cdb34f198f8f55cabdfc34eb41bad7506fb6866cf256a8959fd097a0b81e7cdff833e867d76a097ffedde
01504b010214001400020008000000210201159325ae000000270100000b00000000000000000000000000000000005f72656c732f2e72656c73504b01021400140002000800000021027f624aeb730000007b0000001c00000000000000000000000000
d70000007468656d652f7468656d652f7468656d654d616e616765722e786d6c504b01021400140002000800000021020a5d705ea60000000c0100002700000000000000000000000000840100007468656d652f7468656d652f5f72656c732f7468656d
654d616e616765722e786d6c2e72656c73504b01021400140002000800000021026d52debf9f050000fd1b000016000000000000000000000000006f0200007468656d652f7468656d652f7468656d65312e786d6c504b01021400140002000800000021
02e9278183ee000000100200001300000000000000000000000000420800005b436f6e74656e745f54797065735d2e786d6c504b050600000000050005005d010000610900000000}{\*\colorschememapping 3c3f786d6c2076657273696f6e3d22312e
302220656e636f64696e673d227574662d38223f3e3c613a636c724d617020786d6c6e733a613d22687474703a2f2f736368656d61732e6f70656e786d6c666f726d6174732e6f72672f64726177696e676d6c2f323030362f6d61696e22206267313d22
6c743122207478313d22646b3122206267323d226c743222207478323d22646b322220616363656e74313d22616363656e74312220616363656e74323d22616363656e74322220616363656e74333d22616363656e74332220616363656e74343d226163
63656e74342220616363656e74353d22616363656e74352220616363656e74363d22616363656e74362220686c696e6b3d22686c696e6b2220666f6c486c696e6b3d22666f6c486c696e6b22202f3e}}
!!EndNotesInfo!!
!!StartFinishedReport!!
///
/// DevExpress.XtraReports.v20.1, Version=20.1.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a
/// C:\Program Files\Ontario Reports\DevExpress.XtraReports.v20.1.dll
/// DevExpress.XtraReports.UI.XtraReport
/// en-US
/// 20.1
///
///
/// zsrvvgEAAACRAAAAbFN5c3RlbS5SZXNvdXJjZXMuUmVzb3VyY2VSZWFkZXIsIG1zY29ybGliLCBWZXJzaW9uPTQuMC4wLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjc3YTVjNTYxOTM0ZTA4OSNTeXN0ZW0uUmVzb3VyY2VzLlJ1bnRpbWVSZXNvdXJjZVNldAIAAAAAAAAAAAAAAFBBRFBBRFC0AAAA
///
///
namespace XtraReportSerialization {
public class XtraReport : DevExpress.XtraReports.UI.XtraReport {
private DevExpress.XtraReports.UI.TopMarginBand TopMargin;
private DevExpress.XtraReports.UI.DetailBand Detail;
private DevExpress.XtraReports.UI.XRLabel label9;
private DevExpress.XtraReports.UI.XRLabel label4;
private DevExpress.XtraReports.UI.XRLabel label3;
private DevExpress.XtraReports.UI.XRLabel label2;
private DevExpress.XtraReports.UI.XRLabel label1;
private DevExpress.XtraReports.UI.BottomMarginBand BottomMargin;
private DevExpress.XtraReports.UI.PageHeaderBand PageHeader;
private DevExpress.XtraReports.UI.XRLabel label10;
private DevExpress.XtraReports.UI.XRLabel label8;
private DevExpress.XtraReports.UI.XRLabel label7;
private DevExpress.XtraReports.UI.XRLabel label6;
private DevExpress.XtraReports.UI.XRLabel label5;
private DevExpress.XtraReports.UI.CalculatedField calculatedField1;
private DevExpress.XtraReports.UI.CalculatedField calculatedField2;
private DevExpress.XtraReports.UI.CalculatedField calculatedField3;
private System.Resources.ResourceManager _resources;
private string _resourceString;
public XtraReport() {
this._resourceString = DevExpress.XtraReports.Serialization.XRResourceManager.GetResourceFor("XtraReportSerialization.XtraReport");
this.InitializeComponent();
}
private System.Resources.ResourceManager resources {
get {
if (_resources == null) {
this._resources = new DevExpress.XtraReports.Serialization.XRResourceManager(this._resourceString);
}
return this._resources;
}
}
private void InitializeComponent() {
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand();
this.label9 = new DevExpress.XtraReports.UI.XRLabel();
this.label4 = new DevExpress.XtraReports.UI.XRLabel();
this.label3 = new DevExpress.XtraReports.UI.XRLabel();
this.label2 = new DevExpress.XtraReports.UI.XRLabel();
this.label1 = new DevExpress.XtraReports.UI.XRLabel();
this.label10 = new DevExpress.XtraReports.UI.XRLabel();
this.label8 = new DevExpress.XtraReports.UI.XRLabel();
this.label7 = new DevExpress.XtraReports.UI.XRLabel();
this.label6 = new DevExpress.XtraReports.UI.XRLabel();
this.label5 = new DevExpress.XtraReports.UI.XRLabel();
this.calculatedField1 = new DevExpress.XtraReports.UI.CalculatedField();
this.calculatedField2 = new DevExpress.XtraReports.UI.CalculatedField();
this.calculatedField3 = new DevExpress.XtraReports.UI.CalculatedField();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// TopMargin
//
this.TopMargin.Name = "TopMargin";
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.label9,
this.label4,
this.label3,
this.label2,
this.label1});
this.Detail.HeightF = 23F;
this.Detail.Name = "Detail";
//
// BottomMargin
//
this.BottomMargin.Name = "BottomMargin";
//
// PageHeader
//
this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.label10,
this.label8,
this.label7,
this.label6,
this.label5});
this.PageHeader.HeightF = 23F;
this.PageHeader.Name = "PageHeader";
//
// label9
//
this.label9.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[calculatedField3]")});
this.label9.LocationFloat = new DevExpress.Utils.PointFloat(300F, 0F);
this.label9.Multiline = true;
this.label9.Name = "label9";
this.label9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.label9.SizeF = new System.Drawing.SizeF(100F, 23F);
this.label9.StylePriority.UseTextAlignment = false;
this.label9.Text = "label4";
this.label9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// label4
//
this.label4.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[calculatedField2]")});
this.label4.LocationFloat = new DevExpress.Utils.PointFloat(200F, 0F);
this.label4.Multiline = true;
this.label4.Name = "label4";
this.label4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.label4.SizeF = new System.Drawing.SizeF(100F, 23F);
this.label4.StylePriority.UseTextAlignment = false;
this.label4.Text = "label4";
this.label4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// label3
//
this.label3.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[calculatedField1]")});
this.label3.LocationFloat = new DevExpress.Utils.PointFloat(100F, 0F);
this.label3.Multiline = true;
this.label3.Name = "label3";
this.label3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.label3.SizeF = new System.Drawing.SizeF(100F, 23F);
this.label3.StylePriority.UseTextAlignment = false;
this.label3.Text = "label3";
this.label3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// label2
//
this.label2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[ACCOUNT_NUM]")});
this.label2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
this.label2.Multiline = true;
this.label2.Name = "label2";
this.label2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.label2.SizeF = new System.Drawing.SizeF(100F, 23F);
this.label2.StylePriority.UseTextAlignment = false;
this.label2.Text = "label2";
this.label2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// label1
//
this.label1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "Min(Min([calculatedField1],[calculatedField2]),[calculatedField3])\n\n")});
this.label1.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold);
this.label1.LocationFloat = new DevExpress.Utils.PointFloat(400F, 0F);
this.label1.Multiline = true;
this.label1.Name = "label1";
this.label1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.label1.SizeF = new System.Drawing.SizeF(100F, 23F);
this.label1.StylePriority.UseFont = false;
this.label1.StylePriority.UseTextAlignment = false;
this.label1.Text = "label1";
this.label1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// label10
//
this.label10.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold);
this.label10.LocationFloat = new DevExpress.Utils.PointFloat(300F, 0F);
this.label10.Multiline = true;
this.label10.Name = "label10";
this.label10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.label10.SizeF = new System.Drawing.SizeF(100F, 23F);
this.label10.StylePriority.UseFont = false;
this.label10.StylePriority.UseTextAlignment = false;
this.label10.Text = "calcField3";
this.label10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// label8
//
this.label8.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold);
this.label8.LocationFloat = new DevExpress.Utils.PointFloat(400F, 0F);
this.label8.Multiline = true;
this.label8.Name = "label8";
this.label8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.label8.SizeF = new System.Drawing.SizeF(100F, 23F);
this.label8.StylePriority.UseFont = false;
this.label8.StylePriority.UseTextAlignment = false;
this.label8.Text = "Lowest";
this.label8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// label7
//
this.label7.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold);
this.label7.LocationFloat = new DevExpress.Utils.PointFloat(200F, 0F);
this.label7.Multiline = true;
this.label7.Name = "label7";
this.label7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.label7.SizeF = new System.Drawing.SizeF(100F, 23F);
this.label7.StylePriority.UseFont = false;
this.label7.StylePriority.UseTextAlignment = false;
this.label7.Text = "calcField2";
this.label7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// label6
//
this.label6.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold);
this.label6.LocationFloat = new DevExpress.Utils.PointFloat(100F, 0F);
this.label6.Multiline = true;
this.label6.Name = "label6";
this.label6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.label6.SizeF = new System.Drawing.SizeF(100F, 23F);
this.label6.StylePriority.UseFont = false;
this.label6.StylePriority.UseTextAlignment = false;
this.label6.Text = "calcField1";
this.label6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// label5
//
this.label5.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold);
this.label5.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
this.label5.Multiline = true;
this.label5.Name = "label5";
this.label5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.label5.SizeF = new System.Drawing.SizeF(100F, 23F);
this.label5.StylePriority.UseFont = false;
this.label5.StylePriority.UseTextAlignment = false;
this.label5.Text = "Account Num";
this.label5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// calculatedField1
//
this.calculatedField1.DataMember = "Details";
this.calculatedField1.Expression = "DateDiffDay([LAST_WORK_DATE],Today()) -100";
this.calculatedField1.FieldType = DevExpress.XtraReports.UI.FieldType.Decimal;
this.calculatedField1.Name = "calculatedField1";
//
// calculatedField2
//
this.calculatedField2.DataMember = "Details";
this.calculatedField2.Expression = "DateDiffDay([OCCURENCE_DATE],Today())\n";
this.calculatedField2.FieldType = DevExpress.XtraReports.UI.FieldType.Decimal;
this.calculatedField2.Name = "calculatedField2";
//
// calculatedField3
//
this.calculatedField3.DataMember = "Details";
this.calculatedField3.Expression = "DateDiffDay([WAIT_DATE],Today())";
this.calculatedField3.FieldType = DevExpress.XtraReports.UI.FieldType.Decimal;
this.calculatedField3.Name = "calculatedField3";
//
// XtraReport
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.Detail,
this.BottomMargin,
this.PageHeader});
this.CalculatedFields.AddRange(new DevExpress.XtraReports.UI.CalculatedField[] {
this.calculatedField1,
this.calculatedField2,
this.calculatedField3});
this.DataMember = "Details";
this.DisplayName = "Ticket14147";
this.Name = "XtraReport";
this.PageHeight = 1100;
this.PageWidth = 850;
this.Version = "20.1";
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
}
}
!!EndFinishedReport!!
!!StartDetailData!!
7386063
2016-07-06T00:00:00-05:00
2016-02-02T00:00:00-06:00
2016-07-11T00:00:00-05:00
7387176
2016-07-06T00:00:00-05:00
2016-01-14T00:00:00-06:00
2016-07-28T00:00:00-05:00
7388624
2016-07-06T00:00:00-05:00
2016-06-27T00:00:00-05:00
2016-07-06T00:00:00-05:00
7392214
2016-07-06T00:00:00-05:00
2016-06-30T00:00:00-05:00
2016-12-05T00:00:00-06:00
7392716
2016-07-06T00:00:00-05:00
2016-06-08T00:00:00-05:00
2016-06-25T00:00:00-05:00
7392830
2016-07-06T00:00:00-05:00
2016-04-29T00:00:00-05:00
2016-06-17T00:00:00-05:00
7401323
2016-07-06T00:00:00-05:00
2016-06-30T00:00:00-05:00
2016-07-10T00:00:00-05:00
7402068
2016-07-06T00:00:00-05:00
2016-03-04T00:00:00-06:00
2016-07-08T00:00:00-05:00
7403000
2016-07-06T00:00:00-05:00
2016-07-06T00:00:00-05:00
2016-07-10T00:00:00-05:00
7405544
2016-07-06T00:00:00-05:00
2016-06-27T00:00:00-05:00
2016-12-02T00:00:00-06:00
7408563
2016-07-06T00:00:00-05:00
2016-05-06T00:00:00-05:00
2016-07-14T00:00:00-05:00
7408563
2016-07-06T00:00:00-05:00
2016-05-06T00:00:00-05:00
2016-07-14T00:00:00-05:00
7408563
2016-07-06T00:00:00-05:00
2016-05-06T00:00:00-05:00
2016-07-14T00:00:00-05:00
7401323
2016-08-08T00:00:00-05:00
2016-06-30T00:00:00-05:00
2016-08-08T00:00:00-05:00
7402068
2016-08-08T00:00:00-05:00
2016-03-04T00:00:00-06:00
2016-08-08T00:00:00-05:00
7405544
2016-08-08T00:00:00-05:00
2016-06-27T00:00:00-05:00
2016-12-02T00:00:00-06:00
7386063
2016-08-09T00:00:00-05:00
2016-02-02T00:00:00-06:00
2016-08-11T00:00:00-05:00
7387176
2016-08-10T00:00:00-05:00
2016-01-14T00:00:00-06:00
2016-08-28T00:00:00-05:00
7392214
2016-08-16T00:00:00-05:00
2016-06-30T00:00:00-05:00
2016-12-05T00:00:00-06:00
7392716
2016-08-17T00:00:00-05:00
2016-08-15T00:00:00-05:00
2016-09-05T00:00:00-05:00
7386063
2016-09-06T00:00:00-05:00
2016-02-02T00:00:00-06:00
2016-09-11T00:00:00-05:00
7401323
2016-09-06T00:00:00-05:00
2016-06-30T00:00:00-05:00
2016-09-08T00:00:00-05:00
7402068
2016-09-06T00:00:00-05:00
2016-03-04T00:00:00-06:00
2016-09-08T00:00:00-05:00
7405544
2016-09-06T00:00:00-05:00
2016-06-27T00:00:00-05:00
2016-12-02T00:00:00-06:00
7387176
2016-09-07T00:00:00-05:00
2016-01-14T00:00:00-06:00
2016-09-28T00:00:00-05:00
7392830
2016-09-08T00:00:00-05:00
2016-07-19T00:00:00-05:00
2016-07-23T00:00:00-05:00
!!EndDetailData!!