Connection1 41Tdb2Fd+m3jXf2E5czo44tckcLnXfpB8W19zOJ09uPiFGXCTkq76cJcuUziRKPr8ci9iVYFu1ly Rzl4avTs5w== Connection1 RegistrantsList Reg_ID,System.Int32 Member_ID,System.String Prefix,System.String First_Name,System.String Middle_Name,System.String Last_Name,System.String Suffix,System.String Credentials,System.String Title,System.String Company,System.String Address_1,System.String Address_2,System.String Address_3,System.String City,System.String State,System.String Zip,System.String Country,System.String Phone,System.String Cell,System.String Fax,System.String Email,System.String Reg_Type_ID,System.Int32 City_State,System.String Barcode_2D,System.String 30 RegistrantsList Connection1 Select lRegID as Reg_ID, sMemberID as Member_ID, sPrefix as Prefix, sFirstName as First_Name, sMiddleName as Middle_Name, sLastName as Last_Name, sSuffix as Suffix, sCredentials as Credentials, sTitle as Title, sCompany as Company, sAddress1 as Address_1, sAddress2 as Address_2, sAddress3 as Address_3, sCity as City, sState as State, sZip as Zip, sCountry as Country, sPhone as Phone, sCell as Cell, sFax as Fax, sEmail as Email, lRegType as Reg_Type_ID, IF(CONCAT(sCity,",",sState)=",", "",CONCAT(sCity,",",sState)) as City_State, CONCAT('~',lRegID, '|',char(13),char(10),sFirstName,'|',' ','|',sLastName,'|',char(13),char(10) ,sTitle,'|', char(13),char(10) ,sCompany,'|',char(13),char(10) ,sAddress1,'|',char(13),char(10) ,sAddress2,'|',char(13),char(10) ,sCity,'|',', ','|',sState,'|',' ','|',sZip,'|',char(13),char(10) ,sCountry, '|',char(13),char(10) ,sPhone, '|',char(13),char(10) ,sFax,'|',char(13),char(10) ,sEmail,'|',char(13),char(10),char(13),char(10),char(13),char(10),char(13),char(10),'^') as Barcode_2D from Registrants where laccountid = {user_id} and leventid = {event_id} EventInfo Event_Name,System.String Event_Location,System.String Event_Start_Date,System.String Event_End_Date,System.String 30 EventInfo Connection1 Select sName as Event_Name, sLocation as Event_Location, dtStart as Event_Start_Date, dtEnd as Event_End_Date From Events where laccountid = {user_id} and leventid = {event_id} RegTypes Reg_Type_Code,System.String Reg_Type_Name,System.String Reg_Type_ID,System.String 30 RegTypes Connection1 Select lRegTypeID as Reg_Type_ID, sCode as Reg_Type_Code, sName as Reg_Type_Name From RegTypes where laccountid = {user_id} and leventid = {event_id} Relation1 Reg_Type_ID Relation1 Relation1 Reg_Type_ID EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,8,3 2 4 Transparent True 0.1,0.5,3.8,0.4 Arial,20 Center 0,0,0,0 txtFullName True {RegistrantsList.First_Name} {RegistrantsList.Last_Name} Black Expression White 1 False 10 5 Byte 10 3 0.3,1.9,3.6,1 1 Adrianna Ruiz Director Of Marketing and Communications TitleTeam 111 N Magnolia Ave Suite 150 Orlando, FL 32801 USA 407.591.3726 ext 711  adrianna@titleteamfl.com  Arial,8,Bold,Pixel Black Center txtBarcode2D White 1.6,0.1,2.3,0.3 {RegistrantsList.Reg_ID} Arial,8,Bold,Pixel Black Right txtBarcode1D Transparent 0.1,1,3.8,0.3 Arial,14 Center 0,0,0,0 txtCompany True {RegistrantsList.Company} Black Expression Transparent 0.1,1.5,3.8,0.2 Arial,12 Center 0,0,0,0 txtCityState True {RegistrantsList.City}, {RegistrantsList.State} Black Expression RegistrantsList 3 3 3 DataBand1 dfe46109bb5d987f7deb4f38a983e487 0.25,0.25,1,0.25 Page1 11 8.5 Letter Arial,100 [50:0:0:0] Laser_5293_6up TSL 05/18/2015 02:34:39 PM 05/13/2015 02:40:23 PM Report3 764328a198c9a4b8950568f2edf89b6b Laser_5293_6up Inches 2015.1.4 CSharp