mySqlConnection mySqlConnection EventBand EVENT_ID,System.String EVENT_SRL_ID,System.Int32 PARENT_EVENT_SRL_ID,System.Int32 EVENT_SRL_ID_STATUS_ID,System.String EVENT_NAME,System.String EVENT_START_DATE,System.DateTime EVENT_END_DATE,System.Object EVENT_CREATED_DATE,System.DateTime EVENT_TOTAL_PAX,System.Int32 PURCHASE_ORDER,System.String CANCELLATION_REASON,System.String EVENT_STATUS_ID,System.Int32 EVENT_STATUS,System.String EVENT_TYPE,System.String COORDINATOR_NAME,System.String COORDINATOR_PHONE,System.String COORDINATOR_JOB_TITLE,System.String COORDINATOR_EMAIL,System.String CREATE_USER_NAME,System.String EVENT_SOURCE,System.String EVENT_PRIM_CONT_SRL_ID,System.Int32 TENANT_ID,System.Int32 Event_Time,System.String Ev_Start,System.String 30 EventBand mySqlConnection select events_fact.*, date_format(EVENT_START_DATE,"%T") as Event_Time, date_format(EVENT_START_DATE,"%d/%m/%Y") as Ev_Start from events_fact where {eventSearchCriteria} order by event_start_date ,reportResourceUrl,reportResourceUrl,ULR_x0020_to_x0020_report_x0020_loader_x0020_servlet,System.String,_x002F_,False,False,False ,reportTitle,reportTitle,System.String,Event_x0020_Sheet_x0020_Report,False,False ,filterName,filterName,System.String,,False,False ,organisationName,organisationName,System.String,,False,False ,reportSignature,reportSignature,System.String,,False,False ,eventSearchCriteria,eventSearchCriteria,System.String,_x0031__x003D_0,False,False ,commsPrintCriteria,commsPrintCriteria,System.String,_x0031__x003D_1,False,False ,contactsPrintCriteria,contactsPrintCriteria,System.String,_x0031__x003D_1,False,False ,venuesPrintCriteria,venuesPrintCriteria,System.String,_x0031__x003D_1,False,False ,detailsPrintCriteria,detailsPrintCriteria,System.String,_x0031__x003D_1,False,False ,foodPrintCriteria,foodPrintCriteria,System.String,_x0031__x003D_1,False,False ,beveragePrintCriteria,beveragePrintCriteria,System.String,_x0031__x003D_1,False,False ,inventoryPrintCriteria,inventoryPrintCriteria,System.String,_x0031__x003D_1,False,False ,financialsGlobalPrintCriteria,financialsGlobalPrintCriteria,System.String,_x0031__x003D_1,False,False ,bandNameComms,bandNameComms,System.String,Notes,False,False ,bandNameContacts,bandNameContacts,System.String,Contacts,False,False ,bandNameVenues,bandNameVenues,System.String,Venues,False,False ,bandNameDetails,bandNameDetails,System.String,Details,False,False ,bandNameFood,bandNameFood,System.String,Food,False,False ,bandNameBeverage,bandNameBeverage,System.String,Beverage,False,False ,bandNameInventory,bandNameInventory,System.String,Inventory,False,False ,bandNameFinancials,bandNameFinancials,System.String,Financials,False,False ,venueSecurityCriteria,venueSecurityCriteria,System.String,_x0028_0_x0029_,False,False ,packagePrintCriteria,packagePrintCriteria,System.String,_x0031__x003D_1,False,False ,bandNamePackage,bandNamePackage,System.String,Packages,False,False ,loggedTenantId,loggedTenantId,System.String,_x0030_,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent True 0,0.4,19,4.2 True Transparent True 0,0,17.8,2.4 IMAGE_TOP_LEFT True True Transparent True 2.6,0,13.8,2.4 b309aa9beab90e4ae6fc5bb2fe975930 Center IMAGE_TOP_CENTRE True True Transparent True 1,0,18,2.4 5e1f925c1606d6eacf345bb370d32585 Right IMAGE_TOP_RIGHT True Transparent True 0,3.2,19,0.8 Report Title Arial,16,Bold|Italic Center 0,0,0,0 Text3 IncreasingSize, DecreasingSize {reportTitle} Black Expression Center Transparent True 0,2.4,19,0.8 Arial,16,Bold Center 0,0,0,0 Text35 IncreasingSize, DecreasingSize {organisationName} Black Expression Center PageHeader Transparent True 0,79.9,19,3.2 True Transparent True 0,0.7,18.6,2.4 6e981172098a6bf4fac75bbe35fcf57b IMAGE_BOTTOM_LEFT True True Transparent True 0.4,0.7,18.6,2.4 a9183fa21895764a6a4d5bbefa942907 Right IMAGE_BOTTOM_RIGHT True Transparent 0,0.2,6.4,0.4 Data Small 8pt Arial,8 0,0,0,0 Text24 Printed {Time.ToString("dd/MM/yyyy hh:mm tt")} Black Expression Transparent 0,0.2,19,0.4 Data Small 8pt Arial,8 a2cd9e5725d393c907b888d4c720bf88 Center 0,0,0,0 Text84 Report: {reportTitle} / {filterName} Black Expression Transparent 15.2,0.2,3.8,0.4 Data Small 8pt Arial,8 c25b928d3f71edeb757188d55bc69f03 Right 0,0,0,0 Text85 Page: {PageNumber} of {TotalPageCount} Black Expression PageFooter Transparent 0,5.4,19,4 All;Black;1;Solid;False;4;Black Transparent True 0,0.2,19,3.2 Transparent True 0.2,0,18.6,1.2 Arial,14,Bold|Underline Center 0,0,0,0 Text2 {EventBand.EVENT_ID} - {EventBand.EVENT_NAME} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center Transparent 0.2,1.2,2,0.4 Data Small 10pt Arial,12 0,0,0,0 Text1 Start Date: Black Expression Transparent 0.2,1.8,2,0.4 Data Small 10pt Arial,12 ebcde2b7bff1c79d75480338e25f4f87 0,0,0,0 Text5 End Date: Black Expression Transparent 8.6,1.2,2,0.4 Data Small 10pt Arial,12 7793a47c8f37906c726603391cb78b21 0,0,0,0 Text7 Start Time: Black Expression Transparent 8.6,1.8,2,0.4 Data Small 10pt Arial,12 c2be9641f6b282db29a103391cb7c42b 0,0,0,0 Text4 End Time: Black Expression Transparent 2.2,1.2,6.4,0.4 Data Small Bold 10pt Arial,10,Bold 0,0,0,0 Text6 {Format("{0:dddd, dd MMMM yyyy}", EventBand.EVENT_START_DATE)} Black Expression Center Transparent 2.2,1.8,6.4,0.4 Data Small Bold 10pt Arial,10,Bold c8367a77372db4464128033ad55905be 0,0,0,0 Text9 {EventBand.EVENT_END_DATE.ToString("dddd, dd MMMM yyyy")} Black Expression Center Transparent 10.6,1.2,3.6,0.4 Data Small Bold 10pt Arial,10,Bold e519b67045a14cbb7d72033ba44bc2dd 0,0,0,0 Text11 {Format("{0:HH:mm (hh:mm tt)}", EventBand.EVENT_START_DATE)} Black Expression Center Transparent 10.6,1.8,3.6,0.4 Data Small Bold 10pt Arial,10,Bold 943762fe2aebac088116033ba44b9254 0,0,0,0 Text8 {EventBand.EVENT_END_DATE.ToString("HH:mm (hh:mm tt)")} Black Expression Center Top, Left, Right;Black;1;Solid;False;4;Black Transparent 14.2,1.2,4.6,0.4 Arial,8 0,0,0,0 Text10 Event Coordinator Black Expression Center Left, Right, Bottom;Black;1;Solid;False;4;Black Transparent 14.2,1.6,4.6,0.4 Arial,8,Bold 0,0,0,0 Text12 {EventBand.COORDINATOR_NAME} Black DataColumn Center Transparent 0.2,2.6,1.8,0.4 Data Small 10pt Arial,12 0,0,0,0 Text13 Attendance: Black Expression Bottom Transparent 2.4,2.4,2.2,0.6 Arial,12,Bold 0,0,0,0 Text14 {EventBand.EVENT_TOTAL_PAX} Black DataColumn Bottom Transparent 0,2.6,19,0.6 Arial,14,Bold|Italic Center 0,0,0,0 Text15 {EventBand.EVENT_STATUS} [0:0:0] DataColumn Center Transparent 13,2.4,3.6,0.4 Data Small Bold 10pt Arial,10,Bold 632cb46f5ee7b4a02b77ccab644d4f44 0,0,0,0 Text106 {Format("{0:HH:mm (hh:mm tt)}", EventBand.EVENT_TIME)} Black Expression Center Transparent 13,2.8,6,0.4 Data Small Bold 10pt Arial,10,Bold aed2ca4c840ebde157a6ccb04418f562 0,0,0,0 Text107 {Format("{0:dddd, dd MMMM yyyy}", EventBand.Ev_Start)} Black Expression Center PanelEventData Transparent 0,3.4,5.2,0.4 Data Small 8pt Arial,8 c681c99671fa578c3a1ac7487951398a 0,0,0,0 Text87 Event Type: Black Expression Center Transparent 1.8,3.4,5.2,0.4 Data Small Bold 8pt Arial,8,Bold ed552f99cd764f06c804c748795162e7 0,0,0,0 Text83 {EventBand.EVENT_TYPE} Black DataColumn Center EventBand EventBand True True True True f795cd94c8663920eaa4c9d63d3e92dc True 3 1,1,1,1 PageMain 29.7 21 Arial,100 [50:0:0:0] 01.event-sheet 02/08/2019 11:10:22 PM 12/24/2012 09:15:59 AM 01.event-sheet-report.mrt bbf42f3b3a83c8ecd475cd041350990a 01.event-sheet Centimeters 2012.3.1500 CSharp Transparent Arial,16,Bold|Italic Report Title Black Transparent Arial,8 Center Label Small Black Center Transparent Arial,8,Bold|Underline Center Label Small Bold Black Center Transparent Arial,8 Data Small 8pt Black Transparent Arial,8,Bold Data Small Bold 8pt Black All;Black;1;Solid;False;4;Black Silver Arial,10,Bold Center Band Title Black Center Transparent Arial,8,Underline Center Label Small Underline Black Center Linen Arial,8 Odd Backstyle Black Transparent Arial,8 Even Backstyle Black Transparent Arial,12 Data Small 10pt Black Transparent Arial,10,Bold Center Data Small Bold 10pt Black Center