{"ReportVersion":"2019.1.1","ReportGuid":"e175959da08fc477301f94af3d281237","ReportName":"AttendanceByReg","ReportAlias":"AttendanceByReg","ReportFile":"AttendanceByRegTotalCredits4.mrt","ReportAuthor":"TradeShowLeads","ReportDescription":"AttendanceByReg","ReportCreated":"/Date(12600000+0530)/","ReportChanged":"/Date(12600000+0530)/","EngineVersion":"EngineV2","CalculationMode":"Interpretation","ReportUnit":"Inches","Dictionary":{"Variables":{"0":{"Value":"BB","Name":"Variable1","Alias":"Variable1","Type":"System.String"},"1":{"Name":"VariableEmpty","Alias":"VariableEmpty","Type":"System.String"},"2":{"Value":"101","Name":"user_id","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"user_id","Type":"System.Int64"},"3":{"Value":"309","Name":"event_id","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"event_id","Type":"System.Int64"},"4":{"Value":"d4209dca2576f70c0f4473e5b3edd3cb","Name":"session_id","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"session_id","Type":"System.String"}},"DataSources":{"0":{"Ident":"StiMySqlSource","Name":"BadgeRegistrants","Alias":"BadgeRegistrants","Columns":{"0":{"Name":"Address_1","Index":-1,"NameInSource":"Address_1","Alias":"Address_1","Type":"System.String"},"1":{"Name":"Address_2","Index":-1,"NameInSource":"Address_2","Alias":"Address_2","Type":"System.String"},"2":{"Name":"Address_3","Index":-1,"NameInSource":"Address_3","Alias":"Address_3","Type":"System.String"},"3":{"Name":"Barcode_2D","Index":-1,"NameInSource":"Barcode_2D","Alias":"Barcode_2D","Type":"System.String"},"4":{"Name":"Cell","Index":-1,"NameInSource":"Cell","Alias":"Cell","Type":"System.String"},"5":{"Name":"City","Index":-1,"NameInSource":"City","Alias":"City","Type":"System.String"},"6":{"Name":"City_State","Index":-1,"NameInSource":"City_State","Alias":"City_State","Type":"System.String"},"7":{"Name":"Company","Index":-1,"NameInSource":"Company","Alias":"Company","Type":"System.String"},"8":{"Name":"Country","Index":-1,"NameInSource":"Country","Alias":"Country","Type":"System.String"},"9":{"Name":"Credentials","Index":-1,"NameInSource":"Credentials","Alias":"Credentials","Type":"System.String"},"10":{"Name":"Email","Index":-1,"NameInSource":"Email","Alias":"Email","Type":"System.String"},"11":{"Name":"Fax","Index":-1,"NameInSource":"Fax","Alias":"Fax","Type":"System.String"},"12":{"Name":"First_Name","Index":-1,"NameInSource":"First_Name","Alias":"First_Name","Type":"System.String"},"13":{"Name":"FullNameWithCred","Index":-1,"NameInSource":"FullNameWithCred","Alias":"FullNameWithCred","Type":"System.String"},"14":{"Name":"ID","Index":-1,"NameInSource":"ID","Alias":"ID","Type":"System.Int64"},"15":{"Name":"ID","Index":-1,"NameInSource":"ID","Alias":"ID","Type":"System.Int32"},"16":{"Name":"Last_Name","Index":-1,"NameInSource":"Last_Name","Alias":"Last_Name","Type":"System.String"},"17":{"Name":"Member_ID","Index":-1,"NameInSource":"Member_ID","Alias":"Member_ID","Type":"System.String"},"18":{"Name":"Middle_Name","Index":-1,"NameInSource":"Middle_Name","Alias":"Middle_Name","Type":"System.String"},"19":{"Name":"Phone","Index":-1,"NameInSource":"Phone","Alias":"Phone","Type":"System.String"},"20":{"Name":"Prefix","Index":-1,"NameInSource":"Prefix","Alias":"Prefix","Type":"System.String"},"21":{"Name":"Reg_Type_Code","Index":-1,"NameInSource":"Reg_Type_Code","Alias":"Reg_Type_Code","Type":"System.String"},"22":{"Name":"Reg_Type_Text","Index":-1,"NameInSource":"Reg_Type_Text","Alias":"Reg_Type_Text","Type":"System.String"},"23":{"Name":"State","Index":-1,"NameInSource":"State","Alias":"State","Type":"System.String"},"24":{"Name":"Suffix","Index":-1,"NameInSource":"Suffix","Alias":"Suffix","Type":"System.String"},"25":{"Name":"Title","Index":-1,"NameInSource":"Title","Alias":"Title","Type":"System.String"},"26":{"Name":"Unique_ID","Index":-1,"NameInSource":"Unique_ID","Alias":"Unique_ID","Type":"System.Int32"},"27":{"Name":"Zip","Index":-1,"NameInSource":"Zip","Alias":"Zip","Type":"System.String"},"28":{"Name":"bPrint","Index":-1,"NameInSource":"bPrint","Alias":"bPrint","Type":"System.Int32"},"29":{"Name":"lGuestID","Index":-1,"NameInSource":"lGuestID","Alias":"lGuestID","Type":"System.Int32"},"30":{"Name":"lRegID","Index":-1,"NameInSource":"lRegID","Alias":"lRegID","Type":"System.Int32"},"31":{"Name":"sTicketTopLine","Index":-1,"NameInSource":"sTicketTopLine","Alias":"sTicketTopLine","Type":"System.String"}},"NameInSource":"Connection1","Type":"Table","SqlCommand":"Select lRegID, sMemberID as Member_ID,(CASE WHEN lGuestID <> '' THEN lGuestID ELSE lRegID END) Unique_ID, lGuestID,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, sRegCode as Reg_Type_Code,sRegName as Reg_Type_Text,\r\nIF(sRegCode = \"EXH\" and lRegID < 100000,0,1) as bPrint,\r\nIF(sRegCode = \"EXH\" and lRegID < 100000,sCompany,CONCAT(sFirstName,' ',sLastName)) as sTicketTopLine, \r\nIF(CONCAT(sCity,\", \",sState)=\",\", \"\",CONCAT(sCity,\", \",sState)) as City_State,\r\nIF(sCredentials=\"\", CONCAT(sFirstName, \" \", sLastName),CONCAT(sFirstName, \" \", sLastName,\", \",sCredentials)) as FullNameWithCred,\r\nCONCAT(char(2),char(2),char(2),lRegID, char(3),char(13),char(10),sFirstName,char(3),' ',char(3),sLastName,char(3),char(13),char(10)\r\n,sTitle,char(3), char(13),char(10) \r\n,sCompany,char(3),char(13),char(10) \r\n,sAddress1,char(3),char(13),char(10) \r\n,sAddress2,char(3),char(13),char(10) \r\n,sCity,char(3),', ',char(3),sState,char(3),' ',char(3),sZip,char(3),char(13),char(10) \r\n,sCountry, char(3),char(13),char(10) \r\n,sPhone, char(3),char(13),char(10) \r\n,sFax,char(3),char(13),char(10) \r\n,sEmail,char(3),char(13),char(10),char(13),char(10),char(13),char(10),char(13),char(10),char(26)) as Barcode_2D, REG.ID\r\nfrom BadgeRegistrants as REG where REG.laccountid = {user_id} and REG.leventid =  {event_id} and REG.sSessionID =  '{session_id}'"},"1":{"Ident":"StiMySqlSource","Name":"SessionsAttended","Alias":"SessionsAttended","Columns":{"0":{"Name":"lLeadID","Index":-1,"NameInSource":"lLeadID","Alias":"lLeadID","Type":"System.Int32"},"1":{"Name":"lSessionID","Index":-1,"NameInSource":"lSessionID","Alias":"lSessionID","Type":"System.Int32"},"2":{"Name":"sName","Index":-1,"NameInSource":"sName","Alias":"sName","Type":"System.String"},"3":{"Name":"dCredit1","Index":-1,"NameInSource":"dCredit1","Alias":"dCredit1","Type":"System.Double"},"4":{"Name":"dCredit2","Index":-1,"NameInSource":"dCredit2","Alias":"dCredit2","Type":"System.Double"},"5":{"Name":"dCredit3","Index":-1,"NameInSource":"dCredit3","Alias":"dCredit3","Type":"System.Double"},"6":{"Name":"dCredit4","Index":-1,"NameInSource":"dCredit4","Alias":"dCredit4","Type":"System.Double"},"7":{"Name":"dCredit5","Index":-1,"NameInSource":"dCredit5","Alias":"dCredit5","Type":"System.Double"},"8":{"Name":"IN1","Index":-1,"NameInSource":"IN1","Alias":"IN1","Type":"System.DateTime"},"9":{"Name":"OUT1","Index":-1,"NameInSource":"OUT1","Alias":"OUT1","Type":"System.DateTime"},"10":{"Name":"nMinAttendance","Index":-1,"NameInSource":"nMinAttendance","Alias":"nMinAttendance","Type":"System.Int32"},"11":{"Name":"Attendance","Index":-1,"NameInSource":"Attendance","Alias":"Attendance","Type":"System.Nullable`1[System.Int32]","Ident":"Calc","Expression":"Round((DateDiff(SessionsAttended.OUT1,SessionsAttended.IN1).TotalMinutes)/60,0)"},"12":{"Name":"finalCredit1","Index":-1,"NameInSource":"finalCredit1","Alias":"finalCredit1","Type":"System.Int32","Ident":"Calc","Expression":"IIF(SessionsAttended.nMinAttendance>0,IIF(SessionsAttended.Attendance>=SessionsAttended.nMinAttendance,SessionsAttended.dCredit1,0),SessionsAttended.dCredit1)"},"13":{"Name":"finalCredit2","Index":-1,"NameInSource":"finalCredit2","Alias":"finalCredit2","Type":"System.Int32","Ident":"Calc","Expression":"IIF(SessionsAttended.nMinAttendance>0,\r\nIIF(SessionsAttended.Attendance>=SessionsAttended.nMinAttendance,SessionsAttended.dCredit2,0),SessionsAttended.dCredit2)"},"14":{"Name":"finalCredit3","Index":-1,"NameInSource":"finalCredit3","Alias":"finalCredit3","Type":"System.Int32","Ident":"Calc","Expression":"IIF(SessionsAttended.nMinAttendance>0,\r\nIIF(SessionsAttended.Attendance>=SessionsAttended.nMinAttendance,SessionsAttended.dCredit3,0),SessionsAttended.dCredit3)"},"15":{"Name":"finalCredit4","Index":-1,"NameInSource":"finalCredit4","Alias":"finalCredit4","Type":"System.Int32","Ident":"Calc","Expression":"IIF(SessionsAttended.nMinAttendance>0,\r\nIIF(SessionsAttended.Attendance>=SessionsAttended.nMinAttendance,SessionsAttended.dCredit4,0),SessionsAttended.dCredit4)"},"16":{"Name":"finalCredit5","Index":-1,"NameInSource":"finalCredit5","Alias":"finalCredit5","Type":"System.Int32","Ident":"Calc","Expression":"IIF(SessionsAttended.nMinAttendance>0,\r\nIIF(SessionsAttended.Attendance>=SessionsAttended.nMinAttendance,SessionsAttended.dCredit5,0),SessionsAttended.dCredit5)"},"17":{"Name":"dCredit6","Index":-1,"NameInSource":"dCredit6","Alias":"dCredit6","Type":"System.Nullable`1[System.Double]"},"18":{"Name":"finalCredit6","Index":-1,"NameInSource":"finalCredit6","Alias":"finalCredit6","Type":"System.String","Ident":"Calc","Expression":"IIF(SessionsAttended.nMinAttendance>0,\r\nIIF(SessionsAttended.Attendance>=SessionsAttended.nMinAttendance,SessionsAttended.dCredit6,0),SessionsAttended.dCredit6)"},"19":{"Name":"dCredit7","Index":-1,"NameInSource":"dCredit7","Alias":"dCredit7","Type":"System.Double"},"20":{"Name":"finalCredit7","Index":-1,"NameInSource":"finalCredit7","Alias":"finalCredit7","Type":"System.String","Ident":"Calc","Expression":"IIF(SessionsAttended.nMinAttendance>0,\r\nIIF(SessionsAttended.Attendance>=SessionsAttended.nMinAttendance,SessionsAttended.dCredit7,0),SessionsAttended.dCredit7)"}},"NameInSource":"Connection1","Type":"Table","SqlCommand":"Select b.lLeadID, a.lSessionID, a.sName, a.dCredit1, a.dCredit2, a.dCredit3, a.dCredit4, a.dCredit5,a.dCredit6, a.dCredit7, a.nMinAttendance,\r\n(select min(dtCreatedOn) From SessionsTrackingScans as stsIN WHere stsIN.lAccountID = a.lAccountID and stsIN.lEventID = a.lEventID and stsIN.lNewSessionID = b.lNewSessionID and stsIN.lLeadiD = b.lLeadID and stsIN.bDeleted = 0) as IN1,\r\n(select max(dtCreatedOn) From SessionsTrackingScans as stsIN WHere stsIN.lAccountID = a.lAccountID and stsIN.lEventID = a.lEventID and stsIN.lNewSessionID = b.lNewSessionID and stsIN.lLeadiD = b.lLeadID and stsIN.bDeleted = 0) as OUT1\r\nFROM SessionsTrackingList as a\r\nINNER JOIN SessionsTrackingScans as b ON b.lAccountID = a.lAccountID and b.lEventID = a.lEventID and b.lNewSessionID = a.lSessionID \r\nWhere  a.laccountid =  {user_id}  and a.leventid =  {event_id}   and a.nLiveMode = 1 and b.bDeleted = 0 and\r\nb.lID = (Select sts.lID\r\nFrom SessionsTrackingScans as sts \r\nINNER JOIN SessionsTrackingList as stl ON stl.lAccountID = sts.lAccountID and stl.lEventID = sts.lEventID and stl.lSessionID = sts.lNewSessionID\r\nWhere sts.lAccountID =  {user_id}  and sts.lEventID = {event_id} and sts.lLeadID = b.lLeadID and stl.nGroup = a.nGroup\r\nOrder by sts.lLeadID, sts.dtCreatedOn DESC LIMIT 1)\r\nand b.lAccountID =  {user_id}  and b.lEventID = {event_id}\r\nGroup by  b.lLeadID, a.lSessionID"},"2":{"Ident":"StiMySqlSource","Name":"Answers","Alias":"Answers","Columns":{"0":{"Name":"sOther","Index":-1,"NameInSource":"sOther","Alias":"sOther","Type":"System.String"},"1":{"Name":"lRegID","Index":-1,"NameInSource":"lRegID","Alias":"lRegID","Type":"System.Int32"}},"NameInSource":"Connection1","SqlCommand":"Select lRegID, sOther from RegAnswers ra INNER JOIN QuestionsConfig rq ON ra.lQuestionID = rq.lQUestionID Where  rq.sName like '%NAB%' and rq.bBasicField = 0 \r\nand  ra.lAccountid = {user_id} and ra.leventid =  {event_id}"}},"Databases":{"0":{"Ident":"StiMySqlDatabase","Name":"Connection1","Alias":"Connection1","ConnectionStringEncrypted":"41Tdb2Fd+m3jXf2E5czo44tckcLnXfpB8W19zOJ09uPiFGXCTkq76cJcuUziRKPr8ci9iVYFu1lyRzl4avTs5w=="}},"Relations":{"0":{"Name":"Relation1","ChildColumns":{"0":"lLeadID"},"ParentColumns":{"0":"Unique_ID"},"NameInSource":"Relation1","Alias":"Relation1","IsCloud":null,"ParentSource":"BadgeRegistrants","ChildSource":"SessionsAttended"},"1":{"Name":"RelationAnswer","ChildColumns":{"0":"lRegID"},"ParentColumns":{"0":"lRegID"},"NameInSource":"RelationAnswer","Alias":"RelationAnswer","IsCloud":null,"ParentSource":"Answers","ChildSource":"BadgeRegistrants"}}},"Pages":{"0":{"Ident":"StiPage","Name":"Page1","Guid":"8f2374c6cb90d7d8cbbd6e39235dcfb4","Interaction":{"Ident":"StiInteraction"},"Border":";;2;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Ident":"StiReportTitleBand","Name":"ReportTitleBand1","ClientRectangle":"0,0.2,10.5,0.3","Interaction":{"Ident":"StiInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Ident":"StiText","Name":"Text1","Guid":"abd4728eeb55bb2f3125e2a67a8a8279","ClientRectangle":"0.1,0.1,0.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Reg ID"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"1":{"Ident":"StiText","Name":"Text4","Guid":"40059b86d792294f7bd2b99bca1d764f","ClientRectangle":"0.7,0.1,0.7,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Member ID"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"2":{"Ident":"StiText","Name":"Text14","Guid":"75a34a5931b34c644d58c9a2f7b69bf7","ClientRectangle":"1.6,0.1,0.6,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"FName"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"3":{"Ident":"StiText","Name":"Text15","Guid":"26ff3a5093971472a0cbe5849c044d45","ClientRectangle":"2.4,0.1,0.6,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"LName"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"4":{"Ident":"StiText","Name":"Text16","Guid":"3ec8b74eabdfbe8c430bf38e29a986cc","ClientRectangle":"4.1,0.1,0.6,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Email"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"5":{"Ident":"StiText","Name":"Text17","Guid":"f83d3e973fe877b4df6a24699f464b55","ClientRectangle":"5.2,0,0.5,0.3","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"credit 1\r\ntotal"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"6":{"Ident":"StiText","Name":"Text18","Guid":"faffda4d8c183fcfd922279a31dbd3d8","ClientRectangle":"5.8,0,0.5,0.3","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"credit 2 \r\ntotal"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"7":{"Ident":"StiText","Name":"Text20","Guid":"d4c2c7079b5e95a1d78ee1096d07d0c4","ClientRectangle":"6.4,0,0.5,0.3","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"credit 3 \r\ntotal"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"8":{"Ident":"StiText","Name":"Text23","Guid":"b50788ae48f5f7f4a74473c9c763eaf9","ClientRectangle":"7,0,0.5,0.3","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"credit 4 \r\ntotal"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"9":{"Ident":"StiText","Name":"Text24","Guid":"71e9e7d4a1b95648fd3673ca123aaa5d","ClientRectangle":"7.6,0,0.5,0.3","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"credit 5\r\ntotal"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"10":{"Ident":"StiText","Name":"Text25","Guid":"1852bcf69cc274053efb73ca71c95e7b","ClientRectangle":"8.3,0,0.5,0.3","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"credit 6 \r\ntotal"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"11":{"Ident":"StiText","Name":"Text26","Guid":"26bf6edb7c345129990773cac97590b4","ClientRectangle":"8.9,0,0.5,0.3","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"credit 7 \r\ntotal"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"},"12":{"Ident":"StiText","Name":"Text27","Guid":"1d5a1b3cbc00c0e4fc2e73cb0f378162","ClientRectangle":"9.4,0,0.5,0.3","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Total\r\nCredits"},"Font":";10;;","Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","Type":"Expression"}}},"1":{"Ident":"StiColumnHeaderBand","Name":"ColumnHeaderBand1","ClientRectangle":"0,0.9,10.5,0","Interaction":{"Ident":"StiInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent"},"2":{"Ident":"StiGroupHeaderBand","Name":"GroupHeaderBand1","ClientRectangle":"0,1.3,10.5,0","Interaction":{"Ident":"StiBandInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","SortDirection":"None","Condition":{"Value":"{BadgeRegistrants.lRegID}"}},"3":{"Ident":"StiDataBand","Name":"DataBand1","ClientRectangle":"0,1.7,10.5,0","Interaction":{"Ident":"StiBandInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","DataSourceName":"BadgeRegistrants","Sort":{"0":"ASC","1":"Last_Name","2":"ASC","3":"First_Name"}},"4":{"Ident":"StiGroupFooterBand","Name":"GroupFooterBand2","ClientRectangle":"0,2.1,10.5,0","Interaction":{"Ident":"StiInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent"},"5":{"Ident":"StiGroupHeaderBand","Name":"GroupHeaderBand2","ClientRectangle":"0,2.5,10.5,0","Interaction":{"Ident":"StiBandInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","Condition":{"Value":"{SessionsAttended.lSessionID}"}},"6":{"Ident":"StiDataBand","Name":"DataBand2","ClientRectangle":"0,2.9,10.5,0","Interaction":{"Ident":"StiBandInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","DataSourceName":"SessionsAttended","DataRelationName":"Relation1","MasterComponent":"DataBand1"},"7":{"Ident":"StiColumnFooterBand","Name":"ColumnFooterBand1","ClientRectangle":"0,3.3,10.5,0.2","Interaction":{"Ident":"StiInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Ident":"StiText","Name":"Text2","Guid":"82e90308cdc1ebd7945a06c28515a05b","ClientRectangle":"0.1,0,0.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{BadgeRegistrants.lRegID}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black"},"1":{"Ident":"StiText","Name":"Text3","Guid":"9cae29cba795e8786a5813a9c2d57f44","ClientRectangle":"0.7,0,0.7,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{BadgeRegistrants.Member_ID}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black"},"2":{"Ident":"StiText","Name":"Text5","Guid":"4915afea77a83251eb473d3a79b051d3","ClientRectangle":"1.4,0,1.2,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{BadgeRegistrants.First_Name}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black"},"3":{"Ident":"StiText","Name":"Text6","Guid":"07320583910e7215e158fef0dd7bd237","ClientRectangle":"2.6,0,1.2,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{BadgeRegistrants.Last_Name}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black"},"4":{"Ident":"StiText","Name":"Text7","Guid":"184455eda36964ea4f5bd4cd98244879","ClientRectangle":"3.8,0,1.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{BadgeRegistrants.Email}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black"},"5":{"Ident":"StiText","Name":"Text8","Guid":"c33c40bc4897be6cfb06ca949d0a784b","ClientRectangle":"5.3,0,0.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{Sum(DataBand2,SessionsAttended.finalCredit1)}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","TextQuality":"Wysiwyg","AllowHtmlTags":true,"TextFormat":{"Ident":"StiNumberFormatService","GroupSeparator":",","State":"DecimalDigits"},"Type":"Expression"},"6":{"Ident":"StiText","Name":"Text9","Guid":"cce5ca186d1a33fe28b5fa303c4a279e","ClientRectangle":"5.8,0,0.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{Sum(DataBand2,SessionsAttended.finalCredit2)}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","TextFormat":{"Ident":"StiNumberFormatService","GroupSeparator":",","State":"DecimalDigits"},"Type":"Expression"},"7":{"Ident":"StiText","Name":"Text10","Guid":"8f102ee305c1a224d128c79840eaf804","ClientRectangle":"6.5,0,0.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{Sum(DataBand2,SessionsAttended.finalCredit3)}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","TextFormat":{"Ident":"StiNumberFormatService","GroupSeparator":",","State":"DecimalDigits"},"Type":"Expression"},"8":{"Ident":"StiText","Name":"Text11","Guid":"d51fa1587cd7758029bb7f13b950b808","ClientRectangle":"7.1,0,0.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{Sum(DataBand2,SessionsAttended.finalCredit4)}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","TextFormat":{"Ident":"StiNumberFormatService","GroupSeparator":",","State":"DecimalDigits"},"Type":"Expression"},"9":{"Ident":"StiText","Name":"Text12","Guid":"f01f17766e35663a39a67f0a4c65f326","ClientRectangle":"7.7,0,0.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{Sum(DataBand2,SessionsAttended.finalCredit5)}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","TextFormat":{"Ident":"StiNumberFormatService","GroupSeparator":",","State":"DecimalDigits"},"Type":"Expression"},"10":{"Ident":"StiText","Name":"Text13","Guid":"99cdbbb475a7cdf30bea8700a789ed01","ClientRectangle":"8.4,0,0.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{Sum(DataBand2,SessionsAttended.finalCredit6)}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","TextFormat":{"Ident":"StiNumberFormatService","GroupSeparator":",","State":"DecimalDigits"},"Type":"Expression"},"11":{"Ident":"StiText","Name":"Text19","Guid":"dc3bc16c43b8f32c20ae6c0f74afb1eb","ClientRectangle":"9,0,0.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{Sum(DataBand2,SessionsAttended.finalCredit7)}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","TextFormat":{"Ident":"StiNumberFormatService","GroupSeparator":",","State":"DecimalDigits"},"Type":"Expression"},"12":{"Ident":"StiText","Name":"Text21","Guid":"fb1fe43a947975a3b25f7840c98a4af8","ClientRectangle":"9.5,0,0.5,0.2","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{Sum(DataBand2,SessionsAttended.finalCredit1+SessionsAttended.finalCredit2+SessionsAttended.finalCredit3+SessionsAttended.finalCredit4+SessionsAttended.finalCredit5+SessionsAttended.finalCredit6+SessionsAttended.finalCredit7)}"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","TextBrush":"solid:Black","TextFormat":{"Ident":"StiNumberFormatService","GroupSeparator":",","State":"DecimalDigits"},"Type":"Expression"}}},"8":{"Ident":"StiGroupFooterBand","Name":"GroupFooterBand1","ClientRectangle":"0,3.9,10.5,0","Interaction":{"Ident":"StiInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent"}},"PaperSize":"Letter","LargeHeightFactor":1,"Orientation":"Landscape","PageWidth":11,"PageHeight":8.5,"Watermark":{"TextBrush":"solid:50,0,0,0"},"Margins":{"Left":0.25,"Right":0.25,"Top":0.25,"Bottom":0.25}}}}