!!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!!