EasyBuildConnection 9FrBz0hKQ91FWvn0dFikY9FUlWNIS5LNa1/tCMOE9RPVcJsLaUuChPlH6L13SeO/5VTLaENo+hlGRL3sZz1rRtFa0YNNekvVahW9+E+AokbTVI+JXXoBreFJ+Vw= EasyBuildConnection Company CompanyID,System.Int32 LetterheadName,System.String CompanyStart,System.String Website,System.String ABN,System.String Address,System.String Phone,System.String Fax,System.String Email,System.String BankName,System.String BSB,System.String AccountNumber,System.String CategoryID,System.Int32 CountryID,System.Int32 ABNLabel,System.String BuildersLicenceNumber,System.String 30 Company EasyBuildConnection SELECT c.ID CompanyID, c.LetterheadName, CASE WHEN c.ID = 30 THEN '1993' ELSE '1953' END CompanyStart, c.Website, c.ABN,c.BuildersLicenceNumber, RTRIM(RTRIM(RTRIM(RTRIM(RTRIM(ISNULL(c.StreetNumber,'') + ' ' + ISNULL(c.StreetName,'')) + ' ' + ISNULL(c.StreetType,'')) + ', ' + ISNULL(c.Suburb,'')) + ', ' + ISNULL(c.State,'')) + ' ' + ISNULL(c.postcode,'')) Address, c.Phone, c.Fax, c.Email, c.BankName, c.BSB, c.AccountNumber, c.CategoryID, c.CountryID, CASE WHEN c.CountryID = 2 THEN 'GST No.' WHEN c.CountryID = 4 THEN 'EIN' ELSE 'ABN' END ABNLabel FROM JobDetails jd INNER JOIN Company c ON c.ID = jd.CompanyID WHERE jd.ID = {JobID} CompanyLogos CompanyID,System.Int32 Logo,System.Byte[] 30 CompanyLogos EasyBuildConnection SELECT cl.CompanyID, cl.Logo FROM JobDetails jd INNER JOIN CompanyLogos cl ON cl.CompanyID = jd.CompanyID WHERE jd.ID = {JobID} PropertyRepairDetails BrkAdjIns,System.String InsuredDetails,System.String ClaimDetails,System.String InsuredText,System.String Ins,System.String BrkAdjInsPhone,System.String InsPhone,System.String BrkAdjInsFax,System.String InsFax,System.String BrkAdjInsEmail,System.String InsEmail,System.String AdjusterReference,System.String BrokerReference,System.String SupervisorName,System.String SupervisorPhone,System.String SupervisorEmail,System.String SupervisorFax,System.String QuoteRef,System.String ClaimNumber,System.String CustomerName,System.String SiteAddress,System.String CustomerPhone,System.String DateRequested,System.DateTime InsuredResidedYears,System.Decimal CustomerCalled,System.DateTime AppointmentDate,System.DateTime EstimatorNotes,System.String DateOfLoss,System.DateTime InsID,System.Int32 30 PropertyRepairDetails EasyBuildConnection SELECT ({Title} + ' - ' + CASE WHEN jd.BrokerContactID IS NULL OR ISNULL(jd.AppointedByBroker,0) = 0 THEN (CASE WHEN jd.AdjusterContactID IS NULL THEN icom.Name ELSE acom.Name END) ELSE bcom.Name END )as BrkAdjIns, 'Insured Details' as InsuredDetails, 'Claim Details' as ClaimDetails, 'Insured' as InsuredText, icom.Name Ins, icom.ID As InsID, CASE WHEN jd.AdjusterContactID IS NULL THEN Case WHEN ioff.SmartPhone IS NULL THEN Case WHEN icon.Phone IS NULL THEN ioff.Phone ELSE icon.Phone END ELSE ioff.SmartPhone END ELSE CASE WHEN aoff.SmartPhone IS NULL THEN Case WHEN acon.Phone IS NULL THEN aoff.Phone ELSE acon.Phone END ELSE aoff.SmartPhone END END AdjInsPhone, CASE WHEN ioff.SmartPhone IS NULL THEN CASE WHEN icon.Phone IS NULL THEN ioff.Phone ELSE icon.Phone END END InsPhone, CASE WHEN jd.AdjusterContactID IS NULL THEN Case WHEN icon.Fax IS NULL THEN ioff.Fax ELSE icon.Fax END ELSE Case WHEN acon.Fax IS NULL THEN aoff.Fax ELSE acon.Fax END END AdjInsFax, CASE WHEN icon.Fax IS NULL THEN ioff.Fax ELSE icon.Fax END InsFax, CASE WHEN jd.AdjusterContactID IS NULL THEN Case WHEN icon.Email IS NULL THEN ioff.Email ELSE icon.Email END ELSE Case WHEN acon.Email IS NULL THEN aoff.Email ELSE acon.Email END END AdjInsEmail, Case WHEN icon.Email IS NULL THEN ioff.Email ELSE icon.Email END InsEmail, jdc.AdjusterReference, ISNULL(e.FirstName,'') + ' ' + ISNULL(e.LastName,'') SupervisorName, Case WHEN e.Mobile IS NULL THEN c.Phone ELSE e.Mobile END SupervisorPhone, Case WHEN e.Email IS NULL THEN c.Email ELSE e.Email END SupervisorEmail, c.Fax SupervisorFax, ISNULL(jd.ProjectID,'') + '/' + CONVERT(VARCHAR(3), ISNULL(est.Version,'')) + LEFT(ISNULL(e.loginname,''),2) QuoteRef, jdc.ClaimNumber, ISNULL(jc.FirstName,'') + ' ' + ISNULL(jc.LastName,'') CustomerName, sa.SiteAddress, Case WHEN jcp.Phone1 IS NULL THEN Case WHEN jcp.Mobile IS NULL THEN jcp.Phone2 ELSE jcp.Mobile END ELSE jcp.Phone1 END CustomerPhone, jdi.AllocationDate DateRequested, ISNULL(jdi.InsuredResidedYears,0) InsuredResidedYears, prinote.CustomerCalled, jdi.AppointmentDate, est.GeneralNotes EstimatorNotes, jdi.DateOfLoss FROM JobDetails jd LEFT JOIN [Case] cs ON cs.ID = {CaseID} LEFT JOIN ClientContact icon ON icon.ID = jd.InsuranceContactID LEFT JOIN ClientOffice ioff ON ioff.ID = icon.ClientOfficeID LEFT JOIN ClientCompany icom ON icom.ID = ioff.ClientCompanyID LEFT JOIN ClientContact acon ON acon.ID = jd.AdjusterContactID LEFT JOIN ClientOffice aoff ON aoff.ID = acon.ClientOfficeID LEFT JOIN ClientCompany acom ON acom.ID = aoff.ClientCompanyID LEFT JOIN ClientContact bcon ON bcon.ID = jd.BrokerContactID LEFT JOIN ClientOffice boff ON boff.ID = bcon.ClientOfficeID LEFT JOIN ClientCompany bcom ON bcom.ID = boff.ClientCompanyID LEFT JOIN JobDetailsClaim jdc ON jdc.JobID = jd.ID LEFT JOIN JobDetailsManager jdm ON jdm.JobID = jd.ID AND jdm.Type = 6 AND jdm.PrimaryType = 1 LEFT JOIN Employees e ON e.RecordID = jdm.EmployeeID LEFT JOIN Company c ON c.ID = jd.CompanyID LEFT JOIN JobContact jc ON jc.JobID = jd.ID AND jc.KeyContact = 1 LEFT JOIN JobContactPhoneDetails jcp ON jcp.JobContactID = jc.ID LEFT JOIN vw_JobSiteAddress sa ON sa.JobID = jd.ID LEFT JOIN JobDetailsImportantDates jdi ON jdi.JobID = jd.ID LEFT JOIN (SELECT TOP 1 ed.JobID, ed.Version, ed.GeneralNotes FROM EstimateDetails ed WHERE ed.JobID = {JobID} AND ed.StatusID <> 4 ORDER BY ed.Version) est ON est.JobID = jd.ID LEFT JOIN (SELECT jn.JobID, MIN(jn.InsertedDate) CustomerCalled FROM JobNote jn WHERE jn.TypeID = 7 GROUP BY jn.JobID) prinote ON prinote.JobID = jd.ID WHERE jd.ID = {JobID} JobAssessment Recommendation,System.String ReferralReason,System.String ReferToInsurerReason,System.String InsuredResponsibility,System.String ClientWillingToProceed,System.String ReportsOrdered,System.String RiskAssessmentRequired,System.String HomeOwnerWarranty,System.String DoAndCharge,System.String BuildingType,System.String DesignType,System.String ConstructionType,System.String RoofType,System.String OverallCondition,System.String OtherHazardsOnSite,System.String FoundationType,System.String StructureSizeSquares,System.Decimal StructureSizeSquareMeters,System.Decimal StructureAgeYears,System.Decimal MainRoofDamage,System.Boolean MainRoofDamageText,System.String RoofDamagePercent,System.Decimal TarpOnRoof,System.String JLGTarp,System.String HabitabilityID,System.Int32 ResidenceHabitable,System.Int32 ResidenceHabitableText,System.String Habitability,System.String EventType,System.String OptionalCover,System.String IncidentConfirmed,System.String ClientInformedNextSteps,System.String MakesafeTypeID,System.Int32 MakesafeType,System.String DidMakesafeAttend,System.String MakeSafeCompletionDate,System.DateTime MakesafeCost,System.Decimal SumInsuredAdequate,System.String TradeRequired,System.String PreviousClaimLodged,System.String StrataClaim,System.String EstimatedRoofRepairCompletionDate,System.DateTime RoofRepairCompleted,System.String RepairsByInsuredPrior,System.String ClaimedIncident,System.String ActionTakenAfterIncident,System.String ResultantDamage,System.String BuildersAssessmentOfCause,System.String FurtherSiteComments,System.String EstimatedRepairTimeDays,System.Decimal ActionRequiredByInsured,System.String ActionRequiredByInsurer,System.String ActionRequiredByJLG,System.String ActionRequiredByInsuredDetails,System.String RoofDate,System.Int32 CashSettlementID,System.Int32 CashSettlement,System.String CashSettlementDetails,System.String OtherHazards,System.String PolicyCoversContents,System.String ContentsInvolved,System.String ActionRelatedToContents,System.String ActionRelatedToContentsOther,System.String ClaimedEvent,System.String ClaimedDamage,System.String BuildingOrDesignFaults,System.String BuildingFaultsOrMaintenanceIssues,System.String InspectionDetails,System.String WhatHappenedAndWhen,System.String WhatHappenedAndWhen2,System.String WhatHappenedAndWhen3,System.String MaintenanceIssues,System.String PreviousHistory,System.String InsuredAwareRepairResponsibility,System.String GlassRequired,System.String GlassComments,System.String AluminiumRequired,System.String AluminiumComments,System.String ScaffoldRequired,System.String ScaffoldComments,System.String PermitsRequired,System.String PermitsComments,System.String MenRequired,System.Int32 HoursRequired,System.Int32 PlantRequired,System.String PlantComments,System.String InductionRequired,System.String InductionComments,System.String AbseilersRequired,System.String AbseilersComments,System.String AsbestosPresent,System.String AsbestosComments,System.String MouldPresent,System.String TrafficManagementRequired,System.String TrafficManagementComments,System.String DamageToInternalAreas,System.String DamageToExternalAreas,System.String GeneralRoofConditionComments,System.String StormCreatedOpeningText,System.String StormCreatedOpening,System.Boolean StormCreatedOpeningComments,System.String CeilingCavityInspectionText,System.String CeilingCavityInspection,System.Boolean CeilingCavityInspectionComments,System.String GuttersDownpipesSufficientText,System.String GuttersDownpipesSufficient,System.Boolean GuttersDownpipesSufficientComments,System.String AdditionalFixturesOnRoofText,System.String AdditionalFixturesOnRoof,System.Boolean AdditionalFixturesOnRoofComments,System.String ValleysAndGuttersCleanText,System.String ValleysAndGuttersClean,System.Boolean ValleysAndGuttersCleanComments,System.String WaterBreachComments,System.String ClaimedDamageConsistentText,System.String ClaimedDamageConsistent,System.Boolean ClaimedDamageConsistentComments,System.String BuildingFaultsContributingText,System.String BuildingFaultsContributing,System.Boolean MaintenanceIssuesContributingText,System.String MaintenanceIssuesContributing,System.Boolean InsuredAwareMaintenanceIssuesText,System.String InsuredAwareMaintenanceIssues,System.Boolean InsuredAwareMaintenanceIssuesComments,System.String NotHabitableTimeDays,System.Decimal RepairLimitationsComments,System.String 30 JobAssessment EasyBuildConnection SELECT jr.Description Recommendation, jrr.Description ReferralReason, ja.ReferToInsurerReason, CASE WHEN ISNULL(InsuredAwareRepairResponsibility,0) = 1 THEN 'Yes' ELSE 'No' END InsuredResponsibility, CASE WHEN ISNULL(ClientWillingToProceed,0) = 1 THEN 'Yes' ELSE 'No' END ClientWillingToProceed, Case WHEN ISNULL(Reports.ReportsOrdered,0) > 0 THEN 'Yes' ELSE 'No' END ReportsOrdered, CASE WHEN ISNULL(RiskAssessmentRequired,0) = 1 THEN 'Yes' ELSE 'No' END RiskAssessmentRequired, wt.Description HomeOwnerWarranty, CASE WHEN ISNULL(DoAndCharge,0) = 1 THEN 'Yes' ELSE 'No' END DoAndCharge, bt.Description BuildingType, dt.Description DesignType, ct.Description ConstructionType, rt.Description RoofType, oc.Description OverallCondition, CASE WHEN ISNULL(OtherHazardsOnSite,0) = 1 THEN 'Yes' ELSE 'No' END OtherHazardsOnSite, ft.Description FoundationType, ja.StructureSizeSquares, ja.StructureSizeSquareMeters, ja.StructureAgeYears, ja.MainRoofDamage, CASE WHEN ISNULL(MainRoofDamage,0) = 1 THEN 'Yes' ELSE 'No' END MainRoofDamageText, ja.RoofDamagePercent, CASE WHEN ISNULL(ja.TarpOnRoof,0) = 1 THEN 'Yes' ELSE 'No' END TarpOnRoof, CASE WHEN ISNULL(ja.JLGTarp,0) = 1 THEN 'Yes' ELSE 'No' END JLGTarp, HabitabilityID, CASE WHEN ISNULL(HabitabilityID,0) IN (1, 3) THEN 1 ELSE 0 END ResidenceHabitable, CASE WHEN ISNULL(HabitabilityID,0) IN (1, 3) THEN 'Yes' ELSE 'No' END ResidenceHabitableText, h.Description Habitability, et.Description EventType, ocov.Description OptionalCover, CASE WHEN ISNULL(IncidentConfirmed,0) = 1 THEN 'Yes' ELSE 'No' END IncidentConfirmed, CASE WHEN ISNULL(ClientInformedNextSteps,0) = 1 THEN 'Yes' ELSE 'No' END ClientInformedNextSteps, ja.MakesafeTypeID, mt.Description MakesafeType, CASE WHEN mt.Description = 'None' THEN 'No' ELSE 'Yes' END DidMakesafeAttend, ja.MakeSafeCompletionDate, CASE WHEN ja.MakesafeCost < 0 THEN 0 ELSE ISNULL(ja.MakesafeCost, 0) END MakesafeCost, CASE WHEN ISNULL(SumInsuredAdequate,0) = 1 THEN 'Yes' ELSE 'No' END SumInsuredAdequate, t.Description TradeRequired, CASE WHEN ISNULL(PreviousClaimLodged,0) = 1 THEN 'Yes' ELSE 'No' END PreviousClaimLodged, CASE WHEN ISNULL(StrataClaim,0) = 1 THEN 'Yes' ELSE 'No' END StrataClaim, ja.EstimatedRoofRepairCompletionDate, CASE WHEN ISNULL(RoofRepairCompleted,0) = 1 THEN 'Yes' ELSE 'No' END RoofRepairCompleted, ja.RepairsByInsuredPrior, ja.ClaimedIncident, ja.ActionTakenAfterIncident, ja.ResultantDamage, ja.BuildersAssessmentOfCause, ja.FurtherSiteComments, ja.EstimatedRepairTimeDays, a1.Description ActionRequiredByInsured, a2.Description ActionRequiredByInsurer, a3.Description ActionRequiredByJLG, ja.ActionRequiredByInsured ActionRequiredByInsuredDetails, Case WHEN ja.EstimatedRoofRepairCompletionDate IS NULL THEN 0 ELSE 1 END RoofDate, ISNULL(ja.CashSettlementID,0) CashSettlementID, cs.Description CashSettlement, ja.CashSettlementDetails, ja.OtherHazards, CASE WHEN ISNULL(ja.PolicyCoversContents,0) = 1 THEN 'Yes' ELSE 'No' END PolicyCoversContents, CASE WHEN ISNULL(ja.ContentsInvolved,0) = 1 THEN 'Yes' ELSE 'No' END ContentsInvolved, ca.Description ActionRelatedToContents, ja.ActionRelatedToContentsOther, ja.ClaimedEvent, ja.ClaimedDamage, ja.BuildingOrDesignFaults, ja.BuildingFaultsOrMaintenanceIssues, ja.InspectionDetails, ja.WhatHappenedAndWhen, ja.WhatHappenedAndWhen2, ja.WhatHappenedAndWhen3, ja.MaintenanceIssues, ja.PreviousHistory, CASE WHEN ISNULL(InsuredAwareRepairResponsibility,0) = 1 THEN 'Yes' ELSE 'No' END InsuredAwareRepairResponsibility, Case WHEN Exists (Select ID FROM JobAssessmentGlass WHERE JobAssessmentID = ja.ID) THEN 'Yes' ELSE 'No' END GlassRequired, GlassComments, Case WHEN Exists (Select ID FROM JobAssessmentAluminium WHERE JobAssessmentID = ja.ID) THEN 'Yes' ELSE 'No' END AluminiumRequired, AluminiumComments, CASE WHEN ISNULL(Scaffold,0) = 1 THEN 'Yes' ELSE 'No' END as ScaffoldRequired, ScaffoldComments, CASE WHEN ISNULL(Permits,0) = 1 THEN 'Yes' ELSE 'No' END as PermitsRequired, PermitsComments, MenRequired, HoursRequired, CASE WHEN ISNULL(PlantRequired,0) = 1 THEN 'Yes' ELSE 'No' END PlantRequired,PlantComments, CASE WHEN ISNULL(InductionRequired,0) = 1 THEN 'Yes' ELSE 'No' END InductionRequired, InductionComments, CASE WHEN ISNULL(AbseilersRequired,0) = 1 THEN 'Yes' ELSE 'No' END AbseilersRequired, AbseilersComments, CASE WHEN ISNULL(AsbestosPresent,0) = 1 THEN 'Yes' ELSE 'No' END AsbestosPresent, AsbestosComments, CASE WHEN ISNULL(MouldPresent,0) = 1 THEN 'Yes' ELSE 'No' END MouldPresent, CASE WHEN ISNULL(TrafficManagement,0) = 1 THEN 'Yes' ELSE 'No' END as TrafficManagementRequired, TrafficManagementComments, DamageToInternalAreas, DamageToExternalAreas, GeneralRoofConditionComments, CASE WHEN ISNULL(StormCreatedOpening,0) = 1 THEN 'Yes' ELSE 'No' END StormCreatedOpeningText, StormCreatedOpening, StormCreatedOpeningComments, CASE WHEN ISNULL(CeilingCavityInspection,0) = 1 THEN 'Yes' ELSE 'No' END CeilingCavityInspectionText, CeilingCavityInspection, CeilingCavityInspectionComments, CASE WHEN ISNULL(GuttersDownpipesSufficient,0) = 1 THEN 'Yes' ELSE 'No' END GuttersDownpipesSufficientText, GuttersDownpipesSufficient, GuttersDownpipesSufficientComments, CASE WHEN ISNULL(AdditionalFixturesOnRoof,0) = 1 THEN 'Yes' ELSE 'No' END AdditionalFixturesOnRoofText, AdditionalFixturesOnRoof, AdditionalFixturesOnRoofComments, CASE WHEN ISNULL(ValleysAndGuttersClean,0) = 1 THEN 'Yes' ELSE 'No' END ValleysAndGuttersCleanText, ValleysAndGuttersClean, ValleysAndGuttersCleanComments, WaterBreachComments, CASE WHEN ISNULL(ClaimedDamageConsistent,0) = 1 THEN 'Yes' ELSE 'No' END ClaimedDamageConsistentText, ClaimedDamageConsistent, ClaimedDamageConsistentComments, CASE WHEN ISNULL(BuildingFaultsContributing,0) = 1 THEN 'Yes' ELSE 'No' END BuildingFaultsContributingText, BuildingFaultsContributing, CASE WHEN ISNULL(MaintenanceIssuesContributing,0) = 1 THEN 'Yes' ELSE 'No' END MaintenanceIssuesContributingText, MaintenanceIssuesContributing, CASE WHEN ISNULL(InsuredAwareMaintenanceIssues,0) = 1 THEN 'Yes' ELSE 'No' END InsuredAwareMaintenanceIssuesText, InsuredAwareMaintenanceIssues, InsuredAwareMaintenanceIssuesComments, NotHabitableTimeDays, RepairLimitationsComments FROM JobAssessment ja LEFT JOIN MenuJobAssessmentRecommendation jr ON jr.ID = ja.RecommendationID LEFT JOIN MenuJobAssessmentReferralReason jrr ON jrr.ID = ja.ReferralReasonID LEFT JOIN (SELECT ro.JobAssessmentID, COUNT(ro.JobAssessmentID) ReportsOrdered FROM JobAssessmentReportOrdered ro GROUP BY ro.JobAssessmentID) Reports ON Reports.JobAssessmentID = ja.ID LEFT JOIN MenuJobAssessmentWarrantyType wt ON wt.ID = ja.WarrantyTypeID LEFT JOIN MenuJobAssessmentBuildingType bt ON bt.ID = ja.BuildingTypeID LEFT JOIN MenuJobAssessmentMakesafeType mt ON mt.ID = ja.MakesafeTypeID LEFT JOIN MenuJobAssessmentDesignType dt ON dt.ID = ja.DesignTypeID LEFT JOIN MenuJobAssessmentConstructionType ct ON ct.ID = ja.ConstructionTypeID LEFT JOIN MenuJobAssessmentRoofType rt ON rt.ID = ja.RoofTypeID LEFT JOIN MenuJobAssessmentOverallCondition oc ON oc.ID = ja.OverallConditionID LEFT JOIN MenuJobAssessmentFoundationType ft ON ft.ID = ja.FoundationTypeID LEFT JOIN MenuJobAssessmentHabitability h ON h.ID = ja.HabitabilityID LEFT JOIN MenuJobAssessmentEventType et ON et.ID = ja.EventTypeID LEFT JOIN MenuJobAssessmentTrade t ON t.ID = ja.TradeID LEFT JOIN MenuJobAssessmentInsuredAction a1 ON a1.ID = ja.ActionRequiredByInsuredID LEFT JOIN MenuJobAssessmentInsurerAction a2 ON a2.ID = ja.ActionRequiredByInsurerID LEFT JOIN MenuJobAssessmentJLGAction a3 ON a3.ID = ja.ActionRequiredByJLGID LEFT JOIN MenuJobAssessmentCashSettlement cs ON cs.ID = ja.CashSettlementID LEFT JOIN MenuJobAssessmentContentsAction ca ON ca.ID = ja.ActionRelatedToContentsID LEFT JOIN MenuJobAssessmentOptionalCover ocov ON ca.ID = ja.OptionalCoverID WHERE ja.JobID = {JobID} JobImages FilePath,System.String Description,System.String JobImage,System.Byte[] 30 JobImages EasyBuildConnection SessionID,SessionID,14,0 SELECT FilePath, DocumentFile As [JobImage], Metadata As [Description] FROM AttachSessionDocumentTemp WHERE SessionIdentifier = @SessionID EstimateDetails Header,System.String Description,System.String Level1Sort,System.Decimal Level2Sort,System.Decimal Version,System.Int32 UnitOfMeasure,System.String RecordID,System.Int32 lv1ID,System.Int32 HeaderNumberDisp,System.String DescriptionNumber,System.Int64 HeaderAndDescNumberDisp,System.String 30 EstimateDetails EasyBuildConnection DECLARE @EstID AS INT SET @EstID = {EstimateID} SELECT hdr.ID AS lv1ID, hdr.Name, hdr.SortOrder AS Level1Sort , itm.RecordID, itm.Header, itm.Description, itm.Level2Sort, itm.Version, itm.UnitOfMeasure , hdr.HeaderNumber AS HeaderNumberDisp, itm.ItemNumber AS DescriptionNumber, CAST(HeaderNumber AS NVARCHAR) + '.' + CAST(ItemNumber AS NVARCHAR) HeaderAndDescNumberDisp FROM ( -- Get all level-1 Headers SELECT lv1.ID, Name, SortOrder, e.Version, ROW_NUMBER() OVER (ORDER BY lv1.SortOrder,lv1.ID) AS HeaderNumber FROM EstimateDetails e INNER JOIN EstimateHeader lv1 ON e.ID = lv1.DetailsID WHERE e.ID = @EstID And PreviewInScope = 1 ) hdr INNER JOIN ( -- Get all level-2 Items SELECT lv1.ID lv1ID, lv2.ID RecordID, lv1.Name Header, lv2.Description, lv1.SortOrder Level1Sort, lv2.SortOrder Level2Sort, Version, lv2.UnitOfMeasure, ROW_NUMBER() over (PARTITION BY lv1.ID ORDER BY lv1.ID ASC,lv2.SortOrder asc) AS ItemNumber FROM EstimateItem lv2 INNER JOIN ( SELECT lv1.ID, Name, SortOrder, e.Version FROM EstimateDetails e INNER JOIN EstimateHeader lv1 ON e.ID = lv1.DetailsID WHERE e.ID = @EstID And PreviewInScope = 1 ) lv1 ON lv1.ID = lv2.HeaderID ) itm ON Itm.lv1ID = Hdr.ID ORDER BY HeaderNumber, ItemNumber SELECT hdr.ID AS lv1ID, hdr.Name, hdr.SortOrder AS Level1Sort , itm.RecordID, itm.Header, itm.Description, itm.Level2Sort, itm.Version, itm.UnitOfMeasure , hdr.HeaderNumber AS HeaderNumberDisp, itm.ItemNumber AS DescriptionNumber, CAST(HeaderNumber AS NVARCHAR) + '.' + CAST(ItemNumber AS NVARCHAR) HeaderAndDescNumberDisp FROM ( -- Get all level-1 Headers SELECT lv1.ID, Name, SortOrder, e.Version, ROW_NUMBER() OVER (ORDER BY lv1.SortOrder,lv1.ID) AS HeaderNumber FROM EstimateDetails e INNER JOIN EstimateHeader lv1 ON e.ID = lv1.DetailsID WHERE e.ID = @EstID And PreviewInScope = 1 ) hdr INNER JOIN ( -- Get all level-2 Items SELECT lv1.ID lv1ID, lv2.ID RecordID, lv1.Name Header, lv2.Description, lv1.SortOrder Level1Sort, lv2.SortOrder Level2Sort, Version, lv2.UnitOfMeasure, ROW_NUMBER() over (PARTITION BY lv1.ID ORDER BY lv1.ID ASC,lv2.SortOrder asc) AS ItemNumber FROM EstimateItem lv2 INNER JOIN ( SELECT lv1.ID, Name, SortOrder, e.Version FROM EstimateDetails e INNER JOIN EstimateHeader lv1 ON e.ID = lv1.DetailsID WHERE e.ID = @EstID And PreviewInScope = 1 ) lv1 ON lv1.ID = lv2.HeaderID ) itm ON Itm.lv1ID = Hdr.ID ORDER BY HeaderNumber, ItemNumber Costing CostCode,System.String LabourTotal,System.Double MaterialsTotal,System.Double MarginTotal,System.Double LabourTotalExclMargin,System.Double MaterialsTotalExclMargin,System.Double 30 Costing EasyBuildConnection DECLARE @EstID AS INT SET @EstID = {EstimateID} SELECT Summary.CostCode,SUM(CASE WHEN Summary.category='Labour' THEN ISNULL(Total,0) + ISNULL(MarginTotal,0) ELSE 0 end) LabourTotal, SUM(case when Summary.category='Materials' THEN ISNULL(Total,0) + ISNULL(MarginTotal,0) ELSE 0 end) MaterialsTotal,SUM(MarginTotal) MarginTotal ,SUM(case when Summary.category='Labour' THEN ISNULL(Total,0) ELSE 0 end) LabourTotalExclMargin , SUM(case when Summary.category='Materials' THEN ISNULL(Total,0) ELSE 0 end) MaterialsTotalExclMargin FROM (SELECT Results.CostCode, CASE WHEN Results.Category = 'LAB' THEN 'Labour' ELSE 'Materials' END Category, SUM(Results.Total) Total, SUM(Results.MarginTotal) MarginTotal FROM (SELECT CASE WHEN eid.CostCode IS NULL AND ei.CostCode IS NULL THEN '' WHEN eid.CostCode IS NULL THEN ei.CostCode ELSE eid.CostCode END CostCode, CASE WHEN (eid.Category IS NULL OR eid.Category = '') AND (ei.Category IS NULL OR ei.Category = '') THEN 'MAT' WHEN eid.Category IS NULL THEN ei.Category ELSE eid.Category END Category, CASE WHEN eid.TotalPrice IS NULL THEN (ei.Quantity * ei.SalePrice) ELSE ((eid.Quantity * eid.SalePrice) * ei.Quantity) END Total, CASE WHEN eid.TotalPrice IS NULL THEN ei.TotalPrice - (ei.Quantity * ei.SalePrice) ELSE (eid.TotalPrice * ei.Quantity) - ((eid.Quantity * eid.SalePrice) * ei.Quantity) END MarginTotal, CASE WHEN ei.Category = '' THEN 'MAT' ELSE ISNULL(ei.Category,'MAT') END Lv2Cat, CASE WHEN eid.Category = '' THEN 'MAT' ELSE ISNULL(eid.Category,'MAT') END Lv3Cat FROM EstimateDetails e INNER JOIN EstimateHeader eh ON e.ID = eh.DetailsID INNER JOIN EstimateItem ei ON eh.ID = ei.HeaderID LEFT JOIN EstimateItemDetails eid ON ei.ID = eid.ItemID WHERE e.ID = @EstID) Results WHERE Results.Lv2Cat = 'MAT' AND Results.Lv3Cat = 'MAT' GROUP BY Results.CostCode, Results.Category HAVING SUM(Results.Total) > 0 UNION SELECT Results.CostCode, CASE WHEN Results.Category = 'LAB' THEN 'Labour' ELSE 'Materials' END Category, SUM(Results.Total) Total, SUM(Results.MarginTotal) MarginTotal FROM (SELECT CASE WHEN eid.CostCode IS NULL AND ei.CostCode IS NULL THEN '' WHEN eid.CostCode IS NULL THEN ei.CostCode ELSE eid.CostCode END CostCode, CASE WHEN (eid.Category IS NULL OR eid.Category = '') AND (ei.Category IS NULL OR ei.Category = '') THEN 'MAT' WHEN eid.Category IS NULL THEN ei.Category ELSE eid.Category END Category, CASE WHEN eid.TotalPrice IS NULL THEN (ei.Quantity * ei.SalePrice) ELSE ((eid.Quantity * eid.SalePrice) * ei.Quantity) END Total, CASE WHEN eid.TotalPrice IS NULL THEN ei.TotalPrice - (ei.Quantity * ei.SalePrice) ELSE (eid.TotalPrice * ei.Quantity) - ((eid.Quantity * eid.SalePrice) * ei.Quantity) END MarginTotal, CASE WHEN ei.Category = '' THEN 'MAT' ELSE ISNULL(ei.Category,'MAT') END Lv2Cat, CASE WHEN eid.Category = '' THEN 'MAT' ELSE ISNULL(eid.Category,'MAT') END Lv3Cat FROM EstimateDetails e INNER JOIN EstimateHeader eh ON e.ID = eh.DetailsID INNER JOIN EstimateItem ei ON eh.ID = ei.HeaderID LEFT JOIN EstimateItemDetails eid ON ei.ID = eid.ItemID WHERE e.ID = @EstID) Results WHERE Results.Lv2Cat = 'LAB' OR Results.Lv3Cat = 'LAB' GROUP BY Results.CostCode, Results.Category HAVING SUM(Results.Total) > 0) Summary group by Summary.CostCode Defaults GST,System.Decimal 30 Defaults EasyBuildConnection DECLARE @CompanyID as Int SELECT @CompanyID=CompanyID FROM JobDetails WHERE ID={JobID} SELECT [dbo].[fn_CompanyJobGST](@CompanyID,{JobID}) GST HazardsFound HazardTypes,System.String 30 HazardsFound EasyBuildConnection DECLARE @listStr VARCHAR(MAX) SELECT @listStr = COALESCE(@listStr+',' ,'') + ht.Description FROM JobAssessment ja LEFT JOIN JobAssessmentHazardFound hf ON hf.JobAssessmentID = ja.ID LEFT JOIN MenuJobAssessmentHazardType ht ON ht.ID = hf.JobAssessmentHazardTypeID WHERE ja.JobID = {JobID} SELECT @listStr HazardTypes ReportsOrdered ReportsOrdered,System.String 30 ReportsOrdered EasyBuildConnection DECLARE @listStr VARCHAR(MAX) SELECT @listStr = COALESCE(@listStr+',' ,'') + rt.Description FROM JobAssessment ja LEFT JOIN JobAssessmentReportOrdered ro ON ro.JobAssessmentID = ja.ID LEFT JOIN MenuJobAssessmentReportType rt ON rt.ID = ro.JobAssessmentReportTypeID WHERE ja.JobID = {JobID} SELECT @listStr ReportsOrdered EstimatingContractType EstimatingContractID,System.Int32 30 EstimatingContractType EasyBuildConnection SELECT cccr.EstimatingLetterID AS EstimatingContractID FROM ClientCompanyClientReport cccr JOIN ClientCompany cc ON cc.ID = cccr.ClientCompanyID WHERE cc.ID = (SELECT CASE WHEN jd.AdjusterContactID IS NULL THEN comins.ID ELSE comadj.ID END FROM JobDetails jd LEFT OUTER JOIN ClientContact AS ccadj ON jd.AdjusterContactID = ccadj.ID LEFT OUTER JOIN ClientOffice AS coadj ON ccadj.ClientOfficeID = coadj.ID LEFT OUTER JOIN ClientCompany AS comadj ON coadj.ClientCompanyID = comadj.ID LEFT OUTER JOIN ClientContact AS ccins ON jd.InsuranceContactID = ccins.ID LEFT OUTER JOIN ClientOffice AS coins ON ccins.ClientOfficeID = coins.ID LEFT OUTER JOIN ClientCompany AS comins ON coins.ClientCompanyID = comins.ID WHERE jd.ID = {JobID}) Questionnaire Question,System.String Answer,System.String RenderAsTable,System.Boolean 30 Questionnaire EasyBuildConnection SELECT Question, ISNULL(ModifiedAnswer, Answer) AS Answer, RenderAsTable FROM JobFormQuestionnaireDetails WHERE HeaderId = {QuestionnaireID} AND Ignore = 0 AND Visible = 1 AND RenderAsTable = 0 QuestionnaireSubForm Question,System.String Answer,System.String RenderAsTable,System.Boolean DisplayOrder,System.Int16 SubFormTable,System.Int32 30 QuestionnaireSubForm EasyBuildConnection SELECT Question, ISNULL(ModifiedAnswer, Answer) AS Answer, RenderAsTable,DisplayOrder,SubFormTable FROM JobFormQuestionnaireDetails WHERE HeaderId = 66332 AND Ignore = 0 AND Visible = 1 AND RenderAsTable = 1 QuestionnaireDetails Question,System.String SubForm1,System.String SubForm2,System.String SubForm3,System.String SubForm4,System.String SubForm5,System.String 30 QuestionnaireDetails EasyBuildConnection IF 1=0 BEGIN SET FMTONLY OFF END DECLARE @QuestionnaireID int = {QuestionnaireID} DECLARE @SubformsCount int DECLARE @i int DECLARE @QuestionsCount int DECLARE @ColName varchar(100) DECLARE @DynamicSQL nvarchar(250) DECLARE @dml AS NVARCHAR(MAX) CREATE Table #Question ( Question varchar(100), SubForm1 varchar(100), SubForm2 varchar(100), SubForm3 varchar(100), SubForm4 varchar(100), SubForm5 varchar(100) ) ----------------fetch the columns number of subforms----------- Select @SubformsCount = count(distinct SubFormTable) FROM JobFormQuestionnaireDetails WHERE HeaderId = 66332 AND Ignore = 0 AND Visible = 1 AND RenderAsTable = 1 IF @SubformsCount > 1 BEGIN ---------------Create the table with Questions and columns equal to number of subforms------------- --SET @i = 1 -- WHILE (@i <= @SubformsCount) -- BEGIN -- SET @ColName='SubForm' + CAST(@i AS varchar(10)); -- SET @DynamicSQL = 'ALTER TABLE #Question ADD ['+ CAST(@ColName AS VARCHAR(100)) +'] VARCHAR(100) NULL' -- EXEC(@DynamicSQL) -- SET @i = @i + 1 -- END ----------------------------------------------------- --- Add Questions and Answers---------------------------------- ----fetch how many questions are in one subform Insert into #Question select Question,'','','','','' FROM JobFormQuestionnaireDetails WHERE HeaderId = @QuestionnaireID AND Ignore = 0 AND Visible = 1 AND RenderAsTable = 1 AND SubFormTable = 1 order by DisplayOrder SET @i = 1 WHILE (@i <= @SubformsCount) BEGIN DECLARE @Col varchar(20) SET @Col = CONCAT('SubForm',@i) SET @dml = N'Update #Question set '+@Col+' = ISNULL(ModifiedAnswer, Answer) FROM JobFormQuestionnaireDetails WHERE HeaderId = '+CAST(@QuestionnaireID AS varchar(10))+' AND Ignore = 0 AND Visible = 1 AND RenderAsTable = 1 AND SubFormTable = '+CAST(@i AS varchar(10))+' and JobFormQuestionnaireDetails.Question = #Question.Question' print @dml EXEC sp_executesql @dml SET @i = @i + 1 ENd SElect * from #Question END QuestionnaireHeader Question,System.String DisplayOrder,System.Int16 30 QuestionnaireHeader EasyBuildConnection SELECT distinct Question,DisplayOrder FROM JobFormQuestionnaireDetails WHERE HeaderId = 66332 AND Ignore = 0 AND Visible = 1 AND RenderAsTable = 1 order by DisplayOrder ,JobID,JobID,System.Int32,_x0039_63145,False,False ,CaseID,CaseID,System.Int32,_x0031_424365,False,False ,UserID,UserID,System.Int32,_x0032_009,False,False ,HideCosting,HideCosting,System.Int32,_x0030_,False,False ,EstimateID,EstimateID,System.Int32,_x0034_16292,False,False ,SessionID,SessionID,System.Guid,,False,False ,QuestionnaireID,QuestionnaireID,System.Int32,_x0036_6332,False,False ,Title,Title,Prefix_x0020_used_x0020_in_x0020_title,System.String,,False,False,False ,HideScopeOfWork,HideScopeOfWork,System.Int32,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,97,26,1 All;Black;2;None;False;4;Black Transparent 8.2,0.38,2.6,0.4 Arial,9 Center 0,0,0,0 Text181 {PageNofM} Black Expression Transparent 12.4,0.22,6.6,0.8 Company.CategoryID,EqualTo,_x0034_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None Company.CategoryID,EqualTo,_x0035_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None ed27b004e6dd407a8f5892b4561cb2e2 Right iVBORw0KGgoAAAANSUhEUgAAAN8AAAAeCAIAAAAjL1xqAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAXEQAAFxEByibzPwAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAnCSURBVHhe7ZhbbFXHFYbHAaUXmjZSH/qUvqDS0KpCStSXqKmriFIppYFCo6I0waGQIgLGmFIMgYATNwRisE0M2IAvXIyPMRcTgwnXpIAaQinYGAy+YGzA2ICDDTiogJrS75x/Mx2fcyjGGAVF+9fS1po1a9ZaM/PvOXuOueXDx8MKn50+Hl747HywGFrWlF5xyWv4uEf47HyA+Hr2CZNTb1Y0xm4555l83At8dvY8iqov982v23fu2sLcwKM51Wb1GVPU/I3i5n3n/+V5+OgafHb2MGZ93GAyT5is2phlJyfl7Fi0ZOkv8g6YDRdM6aWYsrZpFVc8Px9dgM/OHkNs4CSnZk3tyWF5/4hZVmfyGzg1++UeSsvInLpk3SObW82Oq0jfnW2N1/7tjfHxf+Gzswewvb69V+oRk3bUvH980IYTGzdtTinYHQM7A+fM+vMm0PjX9OzZqZmPbmoym1pN6WePb2srarrhDfZxZ/jsvC/sO/t545UbHR2fD19ZATXNkhrDqbm8KrB2fdbqjWb1KfPBZ0GCLj8+I3Xpm7PeGpe5gUuSWXPWrDufXu9/ht4FPju7CUjZN/u4mVvee/6RvEMtnx44+Hrh4ZjsOpN7yqw6bVbUw85lOfk/gLWcqRnHzOLq+LQ106bPSExO/c6G08FDtKw99uC1uoYzE+ITAoG1XlwfDnx2dhMrDl145L1yM6/CLKiMyahKLz28d9/f55ccCB2NTWZdi1nblLzqQ25FiYs2msxKEyLuC0s/mpw0Mz5x6i/XVwS/QTc3FH+4e2rS9B07d3lxfTi4Z3YeDqGjo8NtWlh7bW0tzebmFjUF6wOkA9cnbJQcLGzwMET22vhRjS0tLVKA6xCWHUU+FrILN27c2F91pldapcmoMouqTXbt+MDhXbv/Vli62xScNiUXzZY2EzibklXMrSh5YZ5ZVinifm/N0fg33x3z2tixc5c89dTTXrjbUA0uZLfFu3CXLtLB64i2F3LGjh6ZEcjtS0cndlJ0WdnWPXv2eu1oeOaZnyFMgFkNGvQrNV3JyFiI2/jxE9BzcnI1SpCD5i8dGTnyVUsRd5T0MKE8ebpQFzG9dmgihMXIM8xC2G5nZ77W+Ysv/nO26dy+ipO9Fh0Pnouhf91/X1ixZev2VSXbTVGD2X4l+BmaUTUha8u89xa8PTftJ/kHTXFL6GLU/NrrE/v06ZOQkKBogMhRk2oKbs2uaLXZssi9wKLlcuclKBp29KhJhw37ncvmLwud2MkEUlLeoTLNOSpUPdPDE4W52Q1juHrRI1cEqJexWh1Ea0ooOdhRUF+9do0oCYsWNAzYEWJ67RCoiolgV3BLVuzKjn6n7Gw2CmJj2mhFRf/7QISd9acaPjpU3Wt5XfBcLDhr1jb/uDB4Z+dW9HigxqQfM4tOmKV1Q5fvSXlnLreil3N3fmv9yaGvjBk+/EVjTHl5uRfr9uq5U0ZRhZBMNbvTxyh/dFWelDRNe8FTy0XNttfdCzdaWC9JtVauPwFp4kkKmqRGZ91UKjrLwhM7bvho3bCwkjwxatnpkpFeKkRo8qQXRdFo6qUC4WcnIwmhWUUFdSNkIlzYHEBYL08crNheIF0sRLTrNiaVaGMoxg6nNuxK5EIRiOm1b8Oe7i41sSs7XbYMLYfNjsg/FMb7chAsdcDF1lbYWXW8esenR83KWlPUHPzXffOl3sUNsHNVQWBazlaTVRs8Vlee/m7BsZkpc6f8JemJJ77//PODn3tu4IABA7xAISipXhXq9PKFQFKe9FKhnIFeIZed+KgLyB9Bt/NSF3CjRfay5ljc91A0YhRLSl7owROjlghndNXPkykQQXZ0+bPCjCUCTVszw9XETpOxTJxRdpE7sZOgCJnw8EwRXy10IQqH4s4KhPVSFooV2wukM4RVsHb5KCZN5mbHimdRXxs73Gs7sATlaacQNTueNjuCQlP+cpC487XsrDhSyZ3dFNab0ktm22WuOz/NP5xbUMydPSm3zOTXhf5Cahk/Z/GoUaNh50t/eOWxx76dn5/vBQpBSRXfVmiThlmsuG+1uwLuHO281AXUqwmqN1Lc95DVg0bS2RQYgoKD3HjCKinYCY4/Ck2VRGp4hQO5tB0Y0RUTBQfoKxLbQwF0YicjmS3pNV5Q9XZu6MoqEustEdhg9aoOFHdFgHoZC6TLroxkl6JaiaBVELC4Q1zITkyv3RmRlYRlZwroZGdd5MmqySIHQW5unCtXrrrs5M7ee10jZ6dZzOfmsa9ll2flFnBnn5O12hTWjBg3ZUJ8wuDBL/Tr98MRI17iZ729vd0LFILeE3dvgEqiSzWzfxQgUT3yj6xNU0DQI1dAvdjR1cvTRqaXHZSnQBa9BgAHbbqCoOhpFZWqJj4oIrSeOh0xklFbptQoLLgIii50Yqc4QR08PZNDHYxaLG2b3hUEI10IdjXppYmurBbypyZNAJGdihVZwihLdEVGqFtNDXEhT1uGxOuLVklkdgWXyFMWnopmy9NyC5Hs5M7+6+z9wT84M09wi/9mXmXasgLu7EOHDmPsGzNmPflk/8G/GfLssz+Pi4vzotwGZdgFDEuqny8UjJ5351mIKHKQqKnXmxmhawclSiQeyDlsp8KgowFPeMm+M5zaeCo+XXKTosLUtJ5MASJpPbHjg8ITNxRlxwFP1gFd6MTOqMAbvjKeyhiPYl8sUtJESEChKJb4KDSV3kLODEekex1OKESj3OCaAOKWbqGuMPH6olXSlez42Fnb7LjJX7h+/XokO7mzzy7ca7JqzPLgLX70klLYyX4MGfLb+ImT+Fl/+ZU4Ds6SkhIvigNbBkkRFGpQUtVslxeEzQKCqmmrdZ21COyRwiL2NYu6U5Fg5RliV8DV7VgpeEph1gTH0+6adHp5Mlx2FOaCQuUQLOTo4e7s9HEn3Lx5Myo7ubPPXvOxyauNS5oz+c9TuaqzT3xxvjpqdP/+P4KdsbGxXoivNHRGeo27gdeGU9byWPDZeV+42tERlZ3c2UfGjeJHfHZyyvgJCexT4uQpAwcOnDQp0X7AfeWhM9Jr3A3uEWvhs/N+0X75clR2Qk1kftrCP40dBzunTZ/Bz/onn+z3hvnoAnx29gAutbWFsXNVQUDs5M4+fPiLI0fGJb+VUlxc7A3w0TX47OwZXGxtddmZ8f5iqDnqj2NS56dzcHLt8Px83At8dvYYzp+/YNmZuiADdk5/YyZXosiPfR9dhM/OnkRNbZ3YOefdebBz0wel27Zt96nZbfjs7GFUHDkKO2cnvw07KyuPelYf3YLPzp7HPw+VT0xI3LVrt9f20V347HwgaGhs9DQf9wGfnT4eVty69V8EUot+RUAVMAAAAABJRU5ErkJggg== Image1 Transparent 0.2,0.5,7.6,0.4 _x007B_Company.BuildersLicenceNumber_x0021__x003D__x0022__x0022__x007D_,Black,Transparent,Arial_x002C_8,True,False,,,None False Arial,8 003e8811a2b3466cb7f21e93c8221dec 0,0,0,0 Text21 Builders Licence Number: {Company.BuildersLicenceNumber} Black Expression 0,-0.3,19,0.0254 MidnightBlue Black 4c7f8591818f4c49a9259d84d796ef49 HorizontalLinePrimitive29 2 Black PageFooterBand1 Transparent 0,0.4,26,2.6 Transparent 9.2,0,9.8,0.4 Arial,8.25 335847810ffa40b3b73c76e9fa8d46ab Right 0,0,0,0 Text11 {Company.LetterheadName} Black DataColumn Transparent 9.2,1,9.8,0.4 Arial,8.25 f7eac7dc5f224ad5b0e69e30e5bd9e59 Right 0,0,0,0 Text110 {Company.Address} Black Expression Transparent 14.3,1.4,2.1,0.4 Arial,8.25 3bb3d9544218407989128103db835169 Center 0,0,0,0 Text111 {Company.Phone} Black Expression Transparent 16.9,1.4,2.1,0.4 Arial,8.25 be251d653c2245179c2e84043d2eedf2 Right 0,0,0,0 Text115 {Company.Fax} Black Expression Transparent 15.8,1.8,3.2,0.4 Company.CountryID,EqualTo,_x0034_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,8.25 a2f0017520ed41299d5450af125cf7fc Right 0,0,0,0 Text116 {Company.Website} Black DataColumn Transparent 16.9,0.4,2.1,0.4 Arial,6 4f0f8bdca41a41e3bd7180413da67f6d Right 0,0,0,0 Text117 {Company.ABNLabel} {Company.ABN} Black Expression Transparent 14,1.4,0.3,0.4 Arial,8,Bold fa8c0d3a89214c86a4f1de028fca4216 Right 0,0,0,0 Text118 P Black Expression Transparent 16.6,1.4,0.3,0.4 Arial,8.25,Bold ec6b226d78154aafba400f6f3eb99239 Right 0,0,0,0 Text119 F Black Expression Transparent 14,0.4,2.8,0.4 Arial,6 f7e34fda07f54beb9d4e83ef6bf4756f Right 0,0,0,0 Text120 A Johns Lyng Group Company Black Expression Transparent 0,0,8.4,2 CompanyLogos.CompanyID,EqualTo,null,,Numeric,Red,Transparent,Arial_x002C_8,False,False, CompanyLogos.Logo b814edb46a8a4cd2acfc548279e10b8b Image5 f75a0e65abf54c5c820cfe29cd22b06c ReportTitleBand1 Transparent 0,3.8,26,3.8 [210:234:240] 0,0,19,0.6 Arial,10,Bold 347dbbc7f12e4809ac68b14e27c2938e 0,0,0,0 Text4 {PropertyRepairDetails.BrkAdjIns} [47:54:153] Expression Center Transparent 0,0.8,2.4,0.4 Arial,8,Bold 513bfdbdb960457f83d7f83774894dc9 0,0,0,0 Text1 To Black Expression Center Transparent 0,1.2,2.4,0.4 Arial,8,Bold b8a8d45ddfd146efab04cf67736f6bbc 0,0,0,0 Text2 Telephone Black Expression Center Transparent 0,1.6,2.4,0.4 Arial,8,Bold afe934fa8c804baeab3004045539500f 0,0,0,0 Text3 Fax Black Expression Center Transparent 0,2,2.4,0.4 Arial,8,Bold 237ba71a04f14d0895c154cd559b0738 0,0,0,0 Text5 Email Black Expression Center Transparent 0,2.4,2.4,0.4 Arial,8,Bold 8c0b7e94c2dc477a8c3d7aa3ac7c8310 0,0,0,0 Text6 Adjuster Ref Black Expression Center Transparent 0,3.2,2.4,0.4 Arial,8,Bold eb1b537f2e024fc48bc289810fe3734d 0,0,0,0 Text7 Date Black Expression Center Transparent 10.2,0.8,4.6,0.4 Arial,8,Bold cde22e39a3794f1b9f0545f97ec5f250 0,0,0,0 Text8 Completed By Black Expression Center Transparent 10.2,1.2,4.6,0.4 Arial,8,Bold bb0a295537444ab993c7a834f66740f2 0,0,0,0 Text9 Telephone Black Expression Center Transparent 10.2,1.6,4.6,0.4 Arial,8,Bold 09b2051dfedb4fbbb5d9a1ccab9f07f5 0,0,0,0 Text10 Fax Black Expression Center Transparent 10.2,2,4.6,0.4 Arial,8,Bold e37cfdad34be49cba3f82c794662897e 0,0,0,0 Text12 Email Black Expression Center Transparent 10.2,2.4,4.6,0.4 Arial,8,Bold 59a9bc4321d74b959135181015f14ae2 0,0,0,0 Text13 Quote Ref Black Expression Center Transparent 10.2,2.8,4.6,0.4 Arial,8,Bold 6c71d9c4fec1402d94159b60fe5ac067 0,0,0,0 Text14 Claim No Black Expression Center All;Black;2;None;False;4;Black Transparent 2.4,0.8,7.8,0.4 Arial,8 0,0,0,0 Text28 {PropertyRepairDetails.Ins} Black DataColumn Center All;Black;2;None;False;4;Black Transparent 2.4,1.2,7.8,0.4 Arial,8 0,0,0,0 Text29 {PropertyRepairDetails.InsPhone} Black Expression Center All;Black;2;None;False;4;Black Transparent 2.4,1.6,7.8,0.4 Arial,8 0,0,0,0 Text30 {PropertyRepairDetails.InsFax} Black DataColumn Center All;Black;2;None;False;4;Black Transparent 2.4,2,7.8,0.4 Arial,8 0,0,0,0 Text32 {PropertyRepairDetails.InsEmail} Black DataColumn Center All;Black;2;None;False;4;Black Transparent 2.4,2.4,7.8,0.4 Arial,8 0,0,0,0 Text34 {PropertyRepairDetails.AdjusterReference} Black Center All;Black;2;None;False;4;Black Transparent 2.4,3.2,7.8,0.4 Arial,8 0,0,0,0 Text31 {Format("{0:dd/MM/yyyy}", Today)} Black Expression Center All;Black;2;None;False;4;Black Transparent 14.8,0.8,4.2,0.4 Arial,8 0,0,0,0 Text33 {PropertyRepairDetails.SupervisorName} Black Expression Center All;Black;2;None;False;4;Black Transparent 14.8,1.2,4.2,0.4 Arial,8 0,0,0,0 Text35 {Company.Phone} Black Expression Center All;Black;2;None;False;4;Black Transparent 14.8,1.6,4.2,0.4 Arial,8 0,0,0,0 Text36 {Company.Fax} Black Expression Center All;Black;2;None;False;4;Black Transparent 14.8,2,4.2,0.4 Arial,8 0,0,0,0 Text37 {Company.Email} Black Expression All;Black;2;None;False;4;Black Transparent 14.8,2.4,4.2,0.4 Arial,8 0,0,0,0 Text38 {PropertyRepairDetails.QuoteRef} Black Center All;Black;2;None;False;4;Black Transparent 14.8,2.8,4.2,0.4 Arial,8 0,0,0,0 Text39 {PropertyRepairDetails.ClaimNumber} Black Center Transparent 0,2.8,2.4,0.4 Arial,8,Bold 10a5313868f94ec8acc27c22e97bd1c3 0,0,0,0 Text350 Broker Ref Black Expression Center All;Black;2;None;False;4;Black Transparent 2.4,2.8,7.8,0.4 Arial,8 f6ea8941342b465da5e95ed0dabddb9a 0,0,0,0 Text351 {PropertyRepairDetails.BrokerReference} Black DataColumn Center 0,0,19,0.0254 MidnightBlue Black 0a5621a060264658a19c964534e6865e HorizontalLinePrimitive4 2 Black 0,0.6,19,0.0254 MidnightBlue Black de3b550b124c4d36b4e94309151ca335 HorizontalLinePrimitive3 2 Black DataBand1 Transparent 0,8.4,26,2.2 [210:234:240] 0,0,19,0.6 Arial,10,Bold ca5cc7d876174212a51856c27b696242 0,0,0,0 Text177 {PropertyRepairDetails.InsuredDetails} [47:54:153] Expression Center Transparent 0,0.8,2.4,0.4 Arial,8,Bold 74a0d0e07e484f9b85e5bc56f1560cf9 0,0,0,0 Text204 Name Black Expression Center All;Black;2;None;False;4;Black Transparent 2.4,0.8,16.6,0.4 Arial,8 1fe159214ab04d1bb81bce7c25ed67f0 0,0,0,0 Text229 {PropertyRepairDetails.CustomerName} Black Center All;Black;2;None;False;4;Black Transparent 2.4,1.2,16.6,0.4 Arial,8 0,0,0,0 Text42 {PropertyRepairDetails.SiteAddress} Black Center Transparent 0,1.2,2.4,0.4 Arial,8,Bold b61ad8967bbc49ffb1d151c3ab03cf35 0,0,0,0 Text16 Site Address Black Expression Center Transparent 0,1.6,2.4,0.4 Arial,8,Bold ffaeac5ec4144b8cb280b8a08e9e3c1b 0,0,0,0 Text17 Telephone Black Expression Center All;Black;2;None;False;4;Black Transparent 2.4,1.6,16.6,0.4 Arial,8 0,0,0,0 Text44 {PropertyRepairDetails.CustomerPhone} Black Center 0,0.6,19,0.0254 MidnightBlue Black 4aa5903791a84d8097f98c29fe0821c4 HorizontalLinePrimitive23 2 Black 0,0,19,0.0254 MidnightBlue Black 3992746f47824ba982c9c054b5c3d468 HorizontalLinePrimitive25 2 Black b8858333e3e64440b80410c576ddce29 DataBand18 Transparent 0,11.4,26,0.6 [210:234:240] 0,0,19,0.6 Arial,10,Bold 76fca4f8421e4b439d5cc4625fe70800 0,0,0,0 Text40 {PropertyRepairDetails.ClaimDetails} [47:54:153] Expression Center 0,0,19,0.0254 MidnightBlue Black 3cbecc0cdf174309bad987f6b56a04dc HorizontalLinePrimitive26 2 Black 3dbf0b8a1fcc44c9bb5a42f324aec4da DataBand19 Transparent 0,12.8,26,1.4 Transparent 0,0.2,4.8,0.4 Arial,8,Bold 9f087e04969142d9a72d705c5cc9cd95 0,0,0,0 Text247 Date Instructed Black Expression Center Transparent 0,0.6,4.6,0.4 Arial,8,Bold 57c88d4214ea4cc0ba24bf30a7f8ce04 0,0,0,0 Text248 Date Contacted {PropertyRepairDetails.InsuredText} Black Expression Center Transparent 0,1,4.6,0.4 Arial,8,Bold f0a9241de2824b488847618e47340045 0,0,0,0 Text249 Site Appointment Date Black Expression Center All;Black;2;None;False;4;Black Transparent 4.6,0.2,14.4,0.4 Arial,8 6b9f0a2cd8a543608ae65641a62bf063 0,0,0,0 Text250 {Format("{0:dd/MM/yyyy}", PropertyRepairDetails["DateRequested"])} Black Expression All;Black;2;None;False;4;Black Transparent 4.6,0.6,14.4,0.4 Arial,8 0b496f2a60384000b243c44ba6d12bfc 0,0,0,0 Text251 {Format("{0:dd/MM/yyyy}", PropertyRepairDetails["CustomerCalled"])} Black Expression Center All;Black;2;None;False;4;Black Transparent 4.6,1,14.4,0.4 Arial,8 5dd4f358394042019f293f79bcdb75ac 0,0,0,0 Text252 {Format("{0:dd/MM/yyyy}", PropertyRepairDetails["AppointmentDate"])} Black Expression Center 0,0,19,0.0254 MidnightBlue Black ad3843aa5a344292b3bc80642039371c HorizontalLinePrimitive24 2 Black cd52ef436efa436b9ab0f6d74b38799c DataBand48 Transparent 0,15,26,0.8 [210:234:240] 0,0.2,19,0.6 Arial,10,Bold e2d04bbcf91d4316ba33c5fc09822b93 0,0,0,0 Text127 {Substring(Title,1,Length(Title)-2)} [47:54:153] Expression Center 0,0.2,19,0.0254 MidnightBlue Black d3c78fe6e3c149cbb75adc2f9433ba65 HorizontalLinePrimitive27 2 Black bfe5b31e543b463099f56b2c704c9a0c DataBand2 Transparent 0,16.6,26,1.81 True Transparent True 0,0.8,19,0.6 Arial,8 True 0,0,0,0 Text15 {Questionnaire.Answer} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent 0,0.2,19,0.6 Arial,8.25,Bold 0,0,0,0 Text18 {Questionnaire.Question} Black Expression 0,0,19,0.0254 MidnightBlue Black a6037a67f25b487e96133c155e82f553 HorizontalLinePrimitive28 2 Black Questionnaire False RenderAsTable,EqualTo,false,,Boolean DataBand3 Transparent 0,19.21,26,3.35 DownThenAcross 14 All;Black;1;Solid;False;4;Black DarkGray 0.04,0.25,1.28,1.02 Arial,8 0,0,0,0 Text68 {QuestionnaireSubForm.Question} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn All;Black;1;Solid;False;4;Black Transparent 0.05,1.31,1.27,1.96 Arial,8 0,0,0,0 Text69 {QuestionnaireSubForm.Answer} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn QuestionnaireSubForm RenderAsTable,EqualTo,true,,Boolean DataBand7 Transparent 0,23.36,26,1.44 All;Black;1;Solid;False;4;Black DimGray 0,0.02,2.94,1.4 Arial,8 0,0,0,0 Text67 {QuestionnaireDetails.Question} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn All;Black;1;Solid;False;4;Black Transparent 2.93,0.01,2.88,1.42 Arial,8 e03cc19c8aec426ebafb2b0adbef80a4 0,0,0,0 Text70 {QuestionnaireDetails.SubForm1} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn All;Black;1;Solid;False;4;Black Transparent 5.82,0.01,2.93,1.43 Arial,8 f51f07665b904d6b8797a148a8c5f155 0,0,0,0 Text71 {QuestionnaireDetails.SubForm2} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn All;Black;1;Solid;False;4;Black Transparent True 8.77,0.02,2.91,1.42 Arial,8 174301bfe48246feb5a84b4e96a9ce54 0,0,0,0 Text73 {QuestionnaireDetails.SubForm3} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn All;Black;1;Solid;False;4;Black Transparent True 11.69,0,2.94,1.44 Arial,8 07cc545376b2483685b9ed5b1f2a26a4 0,0,0,0 Text74 {QuestionnaireDetails.SubForm4} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn All;Black;1;Solid;False;4;Black Transparent True 14.65,0.01,2.98,1.42 Arial,8 f070b7a57f4447d6a81a6a6338093892 0,0,0,0 Text75 {QuestionnaireDetails.SubForm5} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn QuestionnaireDetails DataBand8 Transparent 0,25.6,26,1.4 Transparent 0,0,1.8,1.4 All;Black;1;Solid;False;4;Black Transparent 0,0,1.8,1.4 Arial,8 bb732b47df2a4fcd9c0a22557c5059c0 0,0,0,0 Text72 {QuestionnaireHeader.Question} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn {QuestionnaireHeader.Question} 51e15beafc474976868611470c21ae41 CrossGroupHeaderBand1 Transparent True 1.8,0,1.8,1.4 QuestionnaireHeader cc1f4a06b50a4cccb818596eb88a93e1 CrossDataBand2 29ac47f9027b4037a2ec2b39f5411465 HeaderBand1 Transparent 0,27.8,26,1 Transparent 0,0,1.8,1 All;Black;1;Solid;False;4;Black Transparent 0,0,1.8,1 Arial,8 98979195b242491b83959464bd3e4a3b 0,0,0,0 Text76 {QuestionnaireSubForm.Answer} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Relation Sheet1Data 988b576ebfac4b19a02e69ac5616dd05 CrossDataBand1 QuestionnaireSubForm 33ddb48842ac4e2692b151a372951c38 DataDataSource1 ff310ad78fe247c78108f021149c5e15 1,1,1,1 Page1 100 28 A4 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.7,19,1 All;Black;2;None;False;4;Black Transparent 8.4,0.4,2.6,0.4 Arial,9 1d330aad98d1499fa844a02c8494b828 Center 0,0,0,0 Text183 {PageNofM} Black Expression Transparent 12,0.23,7,0.8 Company.CategoryID,EqualTo,_x0034_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None Company.CategoryID,EqualTo,_x0035_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None 24d2669847fd4baa8c05ad23ec97d75c Right iVBORw0KGgoAAAANSUhEUgAAAN8AAAAeCAIAAAAjL1xqAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAXEQAAFxEByibzPwAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAnCSURBVHhe7ZhbbFXHFYbHAaUXmjZSH/qUvqDS0KpCStSXqKmriFIppYFCo6I0waGQIgLGmFIMgYATNwRisE0M2IAvXIyPMRcTgwnXpIAaQinYGAy+YGzA2ICDDTiogJrS75x/Mx2fcyjGGAVF+9fS1po1a9ZaM/PvOXuOueXDx8MKn50+Hl747HywGFrWlF5xyWv4uEf47HyA+Hr2CZNTb1Y0xm4555l83At8dvY8iqov982v23fu2sLcwKM51Wb1GVPU/I3i5n3n/+V5+OgafHb2MGZ93GAyT5is2phlJyfl7Fi0ZOkv8g6YDRdM6aWYsrZpFVc8Px9dgM/OHkNs4CSnZk3tyWF5/4hZVmfyGzg1++UeSsvInLpk3SObW82Oq0jfnW2N1/7tjfHxf+Gzswewvb69V+oRk3bUvH980IYTGzdtTinYHQM7A+fM+vMm0PjX9OzZqZmPbmoym1pN6WePb2srarrhDfZxZ/jsvC/sO/t545UbHR2fD19ZATXNkhrDqbm8KrB2fdbqjWb1KfPBZ0GCLj8+I3Xpm7PeGpe5gUuSWXPWrDufXu9/ht4FPju7CUjZN/u4mVvee/6RvEMtnx44+Hrh4ZjsOpN7yqw6bVbUw85lOfk/gLWcqRnHzOLq+LQ106bPSExO/c6G08FDtKw99uC1uoYzE+ITAoG1XlwfDnx2dhMrDl145L1yM6/CLKiMyahKLz28d9/f55ccCB2NTWZdi1nblLzqQ25FiYs2msxKEyLuC0s/mpw0Mz5x6i/XVwS/QTc3FH+4e2rS9B07d3lxfTi4Z3YeDqGjo8NtWlh7bW0tzebmFjUF6wOkA9cnbJQcLGzwMET22vhRjS0tLVKA6xCWHUU+FrILN27c2F91pldapcmoMouqTXbt+MDhXbv/Vli62xScNiUXzZY2EzibklXMrSh5YZ5ZVinifm/N0fg33x3z2tixc5c89dTTXrjbUA0uZLfFu3CXLtLB64i2F3LGjh6ZEcjtS0cndlJ0WdnWPXv2eu1oeOaZnyFMgFkNGvQrNV3JyFiI2/jxE9BzcnI1SpCD5i8dGTnyVUsRd5T0MKE8ebpQFzG9dmgihMXIM8xC2G5nZ77W+Ysv/nO26dy+ipO9Fh0Pnouhf91/X1ixZev2VSXbTVGD2X4l+BmaUTUha8u89xa8PTftJ/kHTXFL6GLU/NrrE/v06ZOQkKBogMhRk2oKbs2uaLXZssi9wKLlcuclKBp29KhJhw37ncvmLwud2MkEUlLeoTLNOSpUPdPDE4W52Q1juHrRI1cEqJexWh1Ea0ooOdhRUF+9do0oCYsWNAzYEWJ67RCoiolgV3BLVuzKjn6n7Gw2CmJj2mhFRf/7QISd9acaPjpU3Wt5XfBcLDhr1jb/uDB4Z+dW9HigxqQfM4tOmKV1Q5fvSXlnLreil3N3fmv9yaGvjBk+/EVjTHl5uRfr9uq5U0ZRhZBMNbvTxyh/dFWelDRNe8FTy0XNttfdCzdaWC9JtVauPwFp4kkKmqRGZ91UKjrLwhM7bvho3bCwkjwxatnpkpFeKkRo8qQXRdFo6qUC4WcnIwmhWUUFdSNkIlzYHEBYL08crNheIF0sRLTrNiaVaGMoxg6nNuxK5EIRiOm1b8Oe7i41sSs7XbYMLYfNjsg/FMb7chAsdcDF1lbYWXW8esenR83KWlPUHPzXffOl3sUNsHNVQWBazlaTVRs8Vlee/m7BsZkpc6f8JemJJ77//PODn3tu4IABA7xAISipXhXq9PKFQFKe9FKhnIFeIZed+KgLyB9Bt/NSF3CjRfay5ljc91A0YhRLSl7owROjlghndNXPkykQQXZ0+bPCjCUCTVszw9XETpOxTJxRdpE7sZOgCJnw8EwRXy10IQqH4s4KhPVSFooV2wukM4RVsHb5KCZN5mbHimdRXxs73Gs7sATlaacQNTueNjuCQlP+cpC487XsrDhSyZ3dFNab0ktm22WuOz/NP5xbUMydPSm3zOTXhf5Cahk/Z/GoUaNh50t/eOWxx76dn5/vBQpBSRXfVmiThlmsuG+1uwLuHO281AXUqwmqN1Lc95DVg0bS2RQYgoKD3HjCKinYCY4/Ck2VRGp4hQO5tB0Y0RUTBQfoKxLbQwF0YicjmS3pNV5Q9XZu6MoqEustEdhg9aoOFHdFgHoZC6TLroxkl6JaiaBVELC4Q1zITkyv3RmRlYRlZwroZGdd5MmqySIHQW5unCtXrrrs5M7ee10jZ6dZzOfmsa9ll2flFnBnn5O12hTWjBg3ZUJ8wuDBL/Tr98MRI17iZ729vd0LFILeE3dvgEqiSzWzfxQgUT3yj6xNU0DQI1dAvdjR1cvTRqaXHZSnQBa9BgAHbbqCoOhpFZWqJj4oIrSeOh0xklFbptQoLLgIii50Yqc4QR08PZNDHYxaLG2b3hUEI10IdjXppYmurBbypyZNAJGdihVZwihLdEVGqFtNDXEhT1uGxOuLVklkdgWXyFMWnopmy9NyC5Hs5M7+6+z9wT84M09wi/9mXmXasgLu7EOHDmPsGzNmPflk/8G/GfLssz+Pi4vzotwGZdgFDEuqny8UjJ5351mIKHKQqKnXmxmhawclSiQeyDlsp8KgowFPeMm+M5zaeCo+XXKTosLUtJ5MASJpPbHjg8ITNxRlxwFP1gFd6MTOqMAbvjKeyhiPYl8sUtJESEChKJb4KDSV3kLODEekex1OKESj3OCaAOKWbqGuMPH6olXSlez42Fnb7LjJX7h+/XokO7mzzy7ca7JqzPLgLX70klLYyX4MGfLb+ImT+Fl/+ZU4Ds6SkhIvigNbBkkRFGpQUtVslxeEzQKCqmmrdZ21COyRwiL2NYu6U5Fg5RliV8DV7VgpeEph1gTH0+6adHp5Mlx2FOaCQuUQLOTo4e7s9HEn3Lx5Myo7ubPPXvOxyauNS5oz+c9TuaqzT3xxvjpqdP/+P4KdsbGxXoivNHRGeo27gdeGU9byWPDZeV+42tERlZ3c2UfGjeJHfHZyyvgJCexT4uQpAwcOnDQp0X7AfeWhM9Jr3A3uEWvhs/N+0X75clR2Qk1kftrCP40dBzunTZ/Bz/onn+z3hvnoAnx29gAutbWFsXNVQUDs5M4+fPiLI0fGJb+VUlxc7A3w0TX47OwZXGxtddmZ8f5iqDnqj2NS56dzcHLt8Px83At8dvYYzp+/YNmZuiADdk5/YyZXosiPfR9dhM/OnkRNbZ3YOefdebBz0wel27Zt96nZbfjs7GFUHDkKO2cnvw07KyuPelYf3YLPzp7HPw+VT0xI3LVrt9f20V347HwgaGhs9DQf9wGfnT4eVty69V8EUot+RUAVMAAAAABJRU5ErkJggg== Image8 Transparent 0.2,0.5,7.6,0.4 _x007B_Company.BuildersLicenceNumber_x0021__x003D__x0022__x0022__x007D_,Black,Transparent,Arial_x002C_8,True,False,,,None False Arial,8 638ce33757de4ed1b428e3fbdf5fe5ec 0,0,0,0 Text63 Builders Licence Number: {Company.BuildersLicenceNumber} Black Expression 906d611bd6314f72af89590fd69787f6 PageFooterBand3 Transparent 0,0.4,19,2.4 Transparent 9.2,0,9.8,0.4 Arial,8.25 3eb986ae0381479c94a51016d47fbf70 Right 0,0,0,0 Text141 {Company.LetterheadName} Black DataColumn Transparent 9.2,1,9.8,0.4 Arial,8.25 e14e5d1fb3ff41c996e838365911ff5b Right 0,0,0,0 Text142 {Company.Address} Black Expression Transparent 14.3,1.4,2.1,0.4 Arial,8.25 d7bfacb34843437782ffc866818ddb1f Center 0,0,0,0 Text143 {Company.Phone} Black Expression Transparent 16.9,1.4,2.1,0.4 Arial,8.25 bcfe71fe8165401ab1a64268fb02d5d6 Right 0,0,0,0 Text144 {Company.Fax} Black Expression Transparent 15.8,1.8,3.2,0.4 Company.CountryID,EqualTo,_x0034_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,8.25 0b67e7eb2cb0490bb72a54276ef07fcf Right 0,0,0,0 Text145 {Company.Website} Black DataColumn Transparent 16.9,0.4,2.1,0.4 Arial,6 95f02a34c09143edb7dab4ee9e02a7d9 Right 0,0,0,0 Text146 {Company.ABNLabel} {Company.ABN} Black Expression Transparent 14,1.4,0.3,0.4 Arial,8,Bold d327b3de6a044583969c4e388aad2bee Right 0,0,0,0 Text147 P Black Expression Transparent 16.6,1.4,0.3,0.4 Arial,8.25,Bold dc9554c5a4ff42c282552325b52f2549 Right 0,0,0,0 Text148 F Black Expression Transparent 14,0.4,2.8,0.4 Arial,6 5842054141c74729beef14d1a1109342 Right 0,0,0,0 Text149 A Johns Lyng Group Company Black Expression Transparent 0,0,8.4,2 CompanyLogos.CompanyID,EqualTo,null,,Numeric,Red,Transparent,Arial_x002C_8,False,False, CompanyLogos.Logo 541aa3b0524040978e82a9e1b24f732a Image2 cce0197b90ff407999f540f25417ce93 ReportTitleBand3 Transparent 0,3.6,19,0.8 [210:234:240] 0,0,19,0.6 Arial,10,Bold 6d96a9f873144da390d703cb030c8b8c 0,0,0,0 Text150 Supporting Photos [47:54:153] Expression Center 0,0,19,0.0254 MidnightBlue Black 15d6edb6303a4baab04b09258e113631 HorizontalLinePrimitive11 2 Black 0,0.6,19,0.0254 MidnightBlue Black 03f5178b092542b4966d23814e38bd0a HorizontalLinePrimitive12 2 Black b7a9acace6d34ab8ada43bdd01e8d8ec DataBand11 Transparent True 0,5.2,19,11 2 True Transparent 0.1,0.2,9.25,6.9 JobImages.JobImage 7ffa6fb995a64ed0a3fe85356267fe60 Image7 True Transparent True True 0.1,7.2,8.4,0.8 Arial,8 c229068cbdb247b8b071a42d9ea8bbff 0,0,0,0 Text151 {JobImages.Description} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression JobImages False 965c4b50244149409943733d5d8f55a7 DataBand12 JobImages.FilePath,EqualTo,,,String,Red,Transparent,Arial_x002C_8,False,False,,,None a673c4ebe2124e5e98e48d16a1a37fd3 1,1,1,1 PhotosPage 29.7 21 A4 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.7,19,1 All;Black;2;None;False;4;Black Transparent 8.2,0.4,2.6,0.4 Arial,9 9fdb75bb277c408991f4166b2b60804f Center 0,0,0,0 Text189 {PageNofM} Black Expression Transparent 12.8,0.1,6.2,0.8 Company.CategoryID,EqualTo,_x0034_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None Company.CategoryID,EqualTo,_x0035_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None aa640f939a0b4a029cbe3adb1b022111 Right iVBORw0KGgoAAAANSUhEUgAAAN8AAAAeCAIAAAAjL1xqAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAXEQAAFxEByibzPwAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAnCSURBVHhe7ZhbbFXHFYbHAaUXmjZSH/qUvqDS0KpCStSXqKmriFIppYFCo6I0waGQIgLGmFIMgYATNwRisE0M2IAvXIyPMRcTgwnXpIAaQinYGAy+YGzA2ICDDTiogJrS75x/Mx2fcyjGGAVF+9fS1po1a9ZaM/PvOXuOueXDx8MKn50+Hl747HywGFrWlF5xyWv4uEf47HyA+Hr2CZNTb1Y0xm4555l83At8dvY8iqov982v23fu2sLcwKM51Wb1GVPU/I3i5n3n/+V5+OgafHb2MGZ93GAyT5is2phlJyfl7Fi0ZOkv8g6YDRdM6aWYsrZpFVc8Px9dgM/OHkNs4CSnZk3tyWF5/4hZVmfyGzg1++UeSsvInLpk3SObW82Oq0jfnW2N1/7tjfHxf+Gzswewvb69V+oRk3bUvH980IYTGzdtTinYHQM7A+fM+vMm0PjX9OzZqZmPbmoym1pN6WePb2srarrhDfZxZ/jsvC/sO/t545UbHR2fD19ZATXNkhrDqbm8KrB2fdbqjWb1KfPBZ0GCLj8+I3Xpm7PeGpe5gUuSWXPWrDufXu9/ht4FPju7CUjZN/u4mVvee/6RvEMtnx44+Hrh4ZjsOpN7yqw6bVbUw85lOfk/gLWcqRnHzOLq+LQ106bPSExO/c6G08FDtKw99uC1uoYzE+ITAoG1XlwfDnx2dhMrDl145L1yM6/CLKiMyahKLz28d9/f55ccCB2NTWZdi1nblLzqQ25FiYs2msxKEyLuC0s/mpw0Mz5x6i/XVwS/QTc3FH+4e2rS9B07d3lxfTi4Z3YeDqGjo8NtWlh7bW0tzebmFjUF6wOkA9cnbJQcLGzwMET22vhRjS0tLVKA6xCWHUU+FrILN27c2F91pldapcmoMouqTXbt+MDhXbv/Vli62xScNiUXzZY2EzibklXMrSh5YZ5ZVinifm/N0fg33x3z2tixc5c89dTTXrjbUA0uZLfFu3CXLtLB64i2F3LGjh6ZEcjtS0cndlJ0WdnWPXv2eu1oeOaZnyFMgFkNGvQrNV3JyFiI2/jxE9BzcnI1SpCD5i8dGTnyVUsRd5T0MKE8ebpQFzG9dmgihMXIM8xC2G5nZ77W+Ysv/nO26dy+ipO9Fh0Pnouhf91/X1ixZev2VSXbTVGD2X4l+BmaUTUha8u89xa8PTftJ/kHTXFL6GLU/NrrE/v06ZOQkKBogMhRk2oKbs2uaLXZssi9wKLlcuclKBp29KhJhw37ncvmLwud2MkEUlLeoTLNOSpUPdPDE4W52Q1juHrRI1cEqJexWh1Ea0ooOdhRUF+9do0oCYsWNAzYEWJ67RCoiolgV3BLVuzKjn6n7Gw2CmJj2mhFRf/7QISd9acaPjpU3Wt5XfBcLDhr1jb/uDB4Z+dW9HigxqQfM4tOmKV1Q5fvSXlnLreil3N3fmv9yaGvjBk+/EVjTHl5uRfr9uq5U0ZRhZBMNbvTxyh/dFWelDRNe8FTy0XNttfdCzdaWC9JtVauPwFp4kkKmqRGZ91UKjrLwhM7bvho3bCwkjwxatnpkpFeKkRo8qQXRdFo6qUC4WcnIwmhWUUFdSNkIlzYHEBYL08crNheIF0sRLTrNiaVaGMoxg6nNuxK5EIRiOm1b8Oe7i41sSs7XbYMLYfNjsg/FMb7chAsdcDF1lbYWXW8esenR83KWlPUHPzXffOl3sUNsHNVQWBazlaTVRs8Vlee/m7BsZkpc6f8JemJJ77//PODn3tu4IABA7xAISipXhXq9PKFQFKe9FKhnIFeIZed+KgLyB9Bt/NSF3CjRfay5ljc91A0YhRLSl7owROjlghndNXPkykQQXZ0+bPCjCUCTVszw9XETpOxTJxRdpE7sZOgCJnw8EwRXy10IQqH4s4KhPVSFooV2wukM4RVsHb5KCZN5mbHimdRXxs73Gs7sATlaacQNTueNjuCQlP+cpC487XsrDhSyZ3dFNab0ktm22WuOz/NP5xbUMydPSm3zOTXhf5Cahk/Z/GoUaNh50t/eOWxx76dn5/vBQpBSRXfVmiThlmsuG+1uwLuHO281AXUqwmqN1Lc95DVg0bS2RQYgoKD3HjCKinYCY4/Ck2VRGp4hQO5tB0Y0RUTBQfoKxLbQwF0YicjmS3pNV5Q9XZu6MoqEustEdhg9aoOFHdFgHoZC6TLroxkl6JaiaBVELC4Q1zITkyv3RmRlYRlZwroZGdd5MmqySIHQW5unCtXrrrs5M7ee10jZ6dZzOfmsa9ll2flFnBnn5O12hTWjBg3ZUJ8wuDBL/Tr98MRI17iZ729vd0LFILeE3dvgEqiSzWzfxQgUT3yj6xNU0DQI1dAvdjR1cvTRqaXHZSnQBa9BgAHbbqCoOhpFZWqJj4oIrSeOh0xklFbptQoLLgIii50Yqc4QR08PZNDHYxaLG2b3hUEI10IdjXppYmurBbypyZNAJGdihVZwihLdEVGqFtNDXEhT1uGxOuLVklkdgWXyFMWnopmy9NyC5Hs5M7+6+z9wT84M09wi/9mXmXasgLu7EOHDmPsGzNmPflk/8G/GfLssz+Pi4vzotwGZdgFDEuqny8UjJ5351mIKHKQqKnXmxmhawclSiQeyDlsp8KgowFPeMm+M5zaeCo+XXKTosLUtJ5MASJpPbHjg8ITNxRlxwFP1gFd6MTOqMAbvjKeyhiPYl8sUtJESEChKJb4KDSV3kLODEekex1OKESj3OCaAOKWbqGuMPH6olXSlez42Fnb7LjJX7h+/XokO7mzzy7ca7JqzPLgLX70klLYyX4MGfLb+ImT+Fl/+ZU4Ds6SkhIvigNbBkkRFGpQUtVslxeEzQKCqmmrdZ21COyRwiL2NYu6U5Fg5RliV8DV7VgpeEph1gTH0+6adHp5Mlx2FOaCQuUQLOTo4e7s9HEn3Lx5Myo7ubPPXvOxyauNS5oz+c9TuaqzT3xxvjpqdP/+P4KdsbGxXoivNHRGeo27gdeGU9byWPDZeV+42tERlZ3c2UfGjeJHfHZyyvgJCexT4uQpAwcOnDQp0X7AfeWhM9Jr3A3uEWvhs/N+0X75clR2Qk1kftrCP40dBzunTZ/Bz/onn+z3hvnoAnx29gAutbWFsXNVQUDs5M4+fPiLI0fGJb+VUlxc7A3w0TX47OwZXGxtddmZ8f5iqDnqj2NS56dzcHLt8Px83At8dvYYzp+/YNmZuiADdk5/YyZXosiPfR9dhM/OnkRNbZ3YOefdebBz0wel27Zt96nZbfjs7GFUHDkKO2cnvw07KyuPelYf3YLPzp7HPw+VT0xI3LVrt9f20V347HwgaGhs9DQf9wGfnT4eVty69V8EUot+RUAVMAAAAABJRU5ErkJggg== Image9 Transparent 0.2,0.5,7.6,0.4 _x007B_Company.BuildersLicenceNumber_x0021__x003D__x0022__x0022__x007D_,Black,Transparent,Arial_x002C_8,True,False,,,None False Arial,8 9451f1dd1ed141188f126d08e6435419 0,0,0,0 Text64 Builders Licence Number: {Company.BuildersLicenceNumber} Black Expression 0bf6fe02e9ed455db8c8ba8aebba5cf0 PageFooterBand4 Transparent 0,0.4,19,2.4 Transparent 9.2,0,9.8,0.4 Arial,8.25 fd36661d9f4b4a4f8f77967e9c66ae5e Right 0,0,0,0 Text66 {Company.LetterheadName} Black DataColumn Transparent 9.2,1,9.8,0.4 Arial,8.25 346570fd504246acac791d985208e155 Right 0,0,0,0 Text80 {Company.Address} Black Expression Transparent 14.3,1.4,2.1,0.4 Arial,8.25 341888e0f6b44ea7ab265062b7a4ffbd Center 0,0,0,0 Text97 {Company.Phone} Black Expression Transparent 16.9,1.4,2.1,0.4 Arial,8.25 dce75740c138471ca773fb49e0db0072 Right 0,0,0,0 Text108 {Company.Fax} Black Expression Transparent 15.8,1.8,3.2,0.4 Company.CountryID,EqualTo,_x0034_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,8.25 9c4558464d3f46b18913dadea4bfd3ce Right 0,0,0,0 Text184 {Company.Website} Black DataColumn Transparent 16.9,0.4,2.1,0.4 Arial,6 a9ef1496ec2f49508b1a514e0f03cdb9 Right 0,0,0,0 Text185 {Company.ABNLabel} {Company.ABN} Black Expression Transparent 14,1.4,0.3,0.4 Arial,8,Bold 67cf185b44d04aa68bb2582b1ae10a09 Right 0,0,0,0 Text186 P Black Expression Transparent 16.6,1.4,0.3,0.4 Arial,8.25,Bold ba38a7cd0ad24003bccd0d6cf2e86d48 Right 0,0,0,0 Text187 F Black Expression Transparent 14,0.4,2.8,0.4 Arial,6 31b1f199eb9e4aa3bbec99a0e6701aa4 Right 0,0,0,0 Text188 A Johns Lyng Group Company Black Expression Transparent 0,0,8.4,2 CompanyLogos.CompanyID,EqualTo,null,,Numeric,Red,Transparent,Arial_x002C_8,False,False, CompanyLogos.Logo f45d334ff5824da78c353d6ca576220f Image4 054657f6260549688fc9e4cd260e6529 ReportTitleBand4 Transparent 0,3.6,19,0.8 [210:234:240] 0,0,19,0.6 Arial,10,Bold 30fb4622a9454fafa259b798323a5eef 0,0,0,0 Text152 Scope of Works [47:54:153] Expression Center 0,0,19,0.0254 MidnightBlue Black fbe05d6bde8d4e8e908cf1f937e3ada9 HorizontalLinePrimitive13 2 Black 0,0.6,19,0.0254 MidnightBlue Black 7a9cf3abca1a4f989f60fe3751488a65 HorizontalLinePrimitive14 2 Black 830970825724420494331dbcd745d6e9 DataBand13 Transparent 0,5.2,19,0 {EstimateDetails.Level1Sort} 2cec0635362142c19dba8786fa508a6c GroupHeaderBand1 Transparent 0,6,19,0 {EstimateDetails.lv1ID} 45aa7e733363496f805d3473c9ac1a3b GroupHeaderBand3 Transparent 0,6.8,19,1 Transparent 0.6,0.2,18.4,0.6 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,EqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,EqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><FilterMode>Or</FilterMode><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><CanAssignExpression>True</CanAssignExpression><BorderSides>None</BorderSides></StiSerializer> Arial,12,Bold bbd27100d2844ad1b0a279b2e0296b66 0,0,0,0 Text153 {EstimateDetails.Header} Black Expression Transparent True 0,0.2,0.6,0.6 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,EqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,EqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><FilterMode>Or</FilterMode><Enabled>False</Enabled><TextColor>Black</TextColor><BackColor>Transparent</BackColor><Font>Arial, 10.2pt, style=Bold</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12,Bold,Point,False,0 c56c602a4ab64e9d9469901ce73676b2 0,0,0,0 Text155 {EstimateDetails.HeaderNumberDisp} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Transparent 0,0.2,19,0.6 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,NotEqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,NotEqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><Enabled>False</Enabled><TextColor>Black</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12,Bold 6120a9d6d9264fafb53d4934ff627cd3 0,0,0,0 Text156 {EstimateDetails.Header} Black Expression {EstimateDetails.Header} 421a1c18dc7548f1a6caffb8e47a45ab GroupHeaderBand2 Transparent 0,8.6,19,0.8 Transparent True 1.6,0.2,17.4,0.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,EqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,EqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><FilterMode>Or</FilterMode><Enabled>False</Enabled><TextColor>Black</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,10 bc1955fe45c7485fb6ec8e7d3eb40ad2 0,0,0,0 Text154 {EstimateDetails.Description} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent True 0.6,0.2,1,0.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,EqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,EqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><FilterMode>Or</FilterMode><Enabled>False</Enabled><TextColor>Black</TextColor><BackColor>Transparent</BackColor><Font>Arial, 10.2pt, style=Bold</Font><BorderSides>None</BorderSides></StiSerializer> Arial,10 28d61f52d3a74a6f842f2f5f0d5ffdf8 0,0,0,0 Text157 {EstimateDetails.HeaderAndDescNumberDisp} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Transparent True 0.6,0.2,18.4,0.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,NotEqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,NotEqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,10 12d08c995b60406eb60a52d1dfdcbb20 0,0,0,0 Text158 {EstimateDetails.Description} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn EstimateDetails 34d5343d22e243ff917921475616fe95 DataBand14 ASC Level2Sort ASC RecordID Transparent 0,10.2,19,1.8 [210:234:240] 0,0.6,19,0.6 _x007B_HideCosting_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,10,Bold 262be56b9f0946fd871409ba767ae993 0,0,0,0 Text159 Costing [47:54:153] Expression Center Transparent 0,1.2,7.6,0.6 _x007B_HideCosting_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,9,Bold 8823502aaa624c31a68dd1421865aab7 0,0,0,0 Text160 TRADE [47:54:153] Expression Transparent 7.6,1.2,4.2,0.6 Arial,9,Bold a853705a0713447db35e742764c3de85 Right 0,0,0,0 Text161 LABOUR [47:54:153] Expression Transparent 11.8,1.2,3.4,0.6 Arial,9,Bold c5c834f35bd243c5a0985becd02b1e6b Right 0,0,0,0 Text162 MATERIALS [47:54:153] Expression Transparent 15.2,1.2,3.8,0.6 Arial,9,Bold 2fe840dfb4a140fc8ff0df728b67eb52 Right 0,0,0,0 Text163 SUB TOTAL [47:54:153] Expression 0,0.6,19,0.0254 MidnightBlue Black 0b1547c7df43497f80458adc69ab30df HorizontalLinePrimitive15 2 Black _x007B_HideCosting_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None 41c4f6fb36654ad7a0a82405d7639183 GroupHeaderBand4 Transparent 0,12.8,19,0.6 Transparent 8.8,0,3,0.6 Arial,9 d743a9b25eea4e1596797531e979917b Right 0,0,0,0 Text164 {Costing.LabourTotal} Black , 1 0 DataColumn Center Transparent 11.8,0,3.4,0.6 Arial,9 904a44876a744b048b5d6ac9ce9a15f6 Right 0,0,0,0 Text165 {Costing.MaterialsTotal} Black , 1 0 Expression Center Transparent 15.2,0,3.8,0.6 Arial,9 b675da1326974201af1f6d13dc6c2d35 Right 0,0,0,0 Text166 {Costing.LabourTotal+Costing.MaterialsTotal} Black , 1 0 Expression Center Transparent 0,0,8.8,0.6 Arial,9,Bold c47055f8d52a4caa8e507107ec01d8d2 0,0,0,0 Text167 {Costing.CostCode} Black Expression Center 0,0,19,0.0254 MidnightBlue Black c16fbd5e705146d8b5ed84568448569e HorizontalLinePrimitive16 2 Black _x007B_HideCosting_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Costing 8778aff366744463898df1a7ccb0a7a7 DataBand16 Transparent 0,14.2,19,2.2 Transparent 9.6,0.2,6.4,0.6 Arial,9,Bold 3feb144f80394a499d09b1e2689a214b 0,0,0,0 Text168 Subtotal excluding GST Black Expression Center Transparent 16,0.2,3,0.6 Arial,9 a9b8e7e12fd34361b2d444b9f3652f91 Right 0,0,0,0 Text169 {Sum(Costing.LabourTotal + Costing.MaterialsTotal)} Black , 1 0 Expression Center Transparent 9.6,0.8,6.4,0.6 Arial,9,Bold 8f5e681fdb904aef9bd3b3de8db77fe9 0,0,0,0 Text170 GST Black Expression Center Transparent 16,0.8,3,0.6 Arial,9 d58caa2274c248e2989d585ccfdeb38c Right 0,0,0,0 Text171 {Sum(Costing.LabourTotal + Costing.MaterialsTotal) * Defaults.GST} Black , 1 0 Expression Center Transparent 9.6,1.43,6.4,0.6 Arial,9,Bold 85b16e5ea0694c7c8e5ae113458b8d0a 0,0,0,0 Text172 Total incl. GST Black Expression Center Transparent 16,1.35,3,1.2 Arial,9 a3e1b32fed13471eb1a8d6262eea3f25 Right 0,0,0,0 Text173 {Format("{0:C2}", (Sum(Costing.LabourTotal + Costing.MaterialsTotal)) + (Sum(Costing.LabourTotal + Costing.MaterialsTotal) * Defaults.GST))} Black , 1 0 Expression Center 16,1.4,3,0.0254 DarkBlue Black cd1d63a83f554beaa14805c2c270340e HorizontalLinePrimitive18 3 Black 16,2.06,3,0.0254 DarkBlue Black 05d5bf78a2cb45b3afa414949823b101 HorizontalLinePrimitive19 3 Black 0,0.2,19,0.0254 DarkBlue Black 096e3289e1184c23b6c602e9043e126d HorizontalLinePrimitive20 3 Black 0,0,19,0.0254 Black Black 78007824089c447295b41aac7add2623 HorizontalLinePrimitive17 Black _x007B_HideCosting_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None deee663e531e43ea8bc1b757bb2deb19 GroupFooterBand2 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>Company.CountryID,EqualTo,_x0034_,,Numeric</value><value>_x007B_EstimateID_x0020__x003D__x003D__x0020_0_x007D_</value></Filters><FilterMode>Or</FilterMode><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> _x007B_HideScopeOfWork_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None _x007B_PropertyRepairDetails.InsID_x003D__x003D_229_x007D_,Black,Transparent,Arial_x002C_8,False,False,,,None 20106bd075054228a38a07c22a0f4a94 1,1,1,1 ScopeOfWorkPage 29.7 21 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.7,19,1 All;Black;2;None;False;4;Black Transparent 8.2,0.3,2.6,0.4 Arial,9 8dbc9d5cbe364b558921befe385a04e5 Center 0,0,0,0 Text19 {PageNofM} Black Expression Transparent 12.6,0.1,6.4,0.8 Company.CategoryID,EqualTo,_x0034_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None Company.CategoryID,EqualTo,_x0035_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None 62149aa4ce7b42dd88d4c272f40b59e0 Right iVBORw0KGgoAAAANSUhEUgAAAN8AAAAeCAIAAAAjL1xqAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAXEQAAFxEByibzPwAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAnCSURBVHhe7ZhbbFXHFYbHAaUXmjZSH/qUvqDS0KpCStSXqKmriFIppYFCo6I0waGQIgLGmFIMgYATNwRisE0M2IAvXIyPMRcTgwnXpIAaQinYGAy+YGzA2ICDDTiogJrS75x/Mx2fcyjGGAVF+9fS1po1a9ZaM/PvOXuOueXDx8MKn50+Hl747HywGFrWlF5xyWv4uEf47HyA+Hr2CZNTb1Y0xm4555l83At8dvY8iqov982v23fu2sLcwKM51Wb1GVPU/I3i5n3n/+V5+OgafHb2MGZ93GAyT5is2phlJyfl7Fi0ZOkv8g6YDRdM6aWYsrZpFVc8Px9dgM/OHkNs4CSnZk3tyWF5/4hZVmfyGzg1++UeSsvInLpk3SObW82Oq0jfnW2N1/7tjfHxf+Gzswewvb69V+oRk3bUvH980IYTGzdtTinYHQM7A+fM+vMm0PjX9OzZqZmPbmoym1pN6WePb2srarrhDfZxZ/jsvC/sO/t545UbHR2fD19ZATXNkhrDqbm8KrB2fdbqjWb1KfPBZ0GCLj8+I3Xpm7PeGpe5gUuSWXPWrDufXu9/ht4FPju7CUjZN/u4mVvee/6RvEMtnx44+Hrh4ZjsOpN7yqw6bVbUw85lOfk/gLWcqRnHzOLq+LQ106bPSExO/c6G08FDtKw99uC1uoYzE+ITAoG1XlwfDnx2dhMrDl145L1yM6/CLKiMyahKLz28d9/f55ccCB2NTWZdi1nblLzqQ25FiYs2msxKEyLuC0s/mpw0Mz5x6i/XVwS/QTc3FH+4e2rS9B07d3lxfTi4Z3YeDqGjo8NtWlh7bW0tzebmFjUF6wOkA9cnbJQcLGzwMET22vhRjS0tLVKA6xCWHUU+FrILN27c2F91pldapcmoMouqTXbt+MDhXbv/Vli62xScNiUXzZY2EzibklXMrSh5YZ5ZVinifm/N0fg33x3z2tixc5c89dTTXrjbUA0uZLfFu3CXLtLB64i2F3LGjh6ZEcjtS0cndlJ0WdnWPXv2eu1oeOaZnyFMgFkNGvQrNV3JyFiI2/jxE9BzcnI1SpCD5i8dGTnyVUsRd5T0MKE8ebpQFzG9dmgihMXIM8xC2G5nZ77W+Ysv/nO26dy+ipO9Fh0Pnouhf91/X1ixZev2VSXbTVGD2X4l+BmaUTUha8u89xa8PTftJ/kHTXFL6GLU/NrrE/v06ZOQkKBogMhRk2oKbs2uaLXZssi9wKLlcuclKBp29KhJhw37ncvmLwud2MkEUlLeoTLNOSpUPdPDE4W52Q1juHrRI1cEqJexWh1Ea0ooOdhRUF+9do0oCYsWNAzYEWJ67RCoiolgV3BLVuzKjn6n7Gw2CmJj2mhFRf/7QISd9acaPjpU3Wt5XfBcLDhr1jb/uDB4Z+dW9HigxqQfM4tOmKV1Q5fvSXlnLreil3N3fmv9yaGvjBk+/EVjTHl5uRfr9uq5U0ZRhZBMNbvTxyh/dFWelDRNe8FTy0XNttfdCzdaWC9JtVauPwFp4kkKmqRGZ91UKjrLwhM7bvho3bCwkjwxatnpkpFeKkRo8qQXRdFo6qUC4WcnIwmhWUUFdSNkIlzYHEBYL08crNheIF0sRLTrNiaVaGMoxg6nNuxK5EIRiOm1b8Oe7i41sSs7XbYMLYfNjsg/FMb7chAsdcDF1lbYWXW8esenR83KWlPUHPzXffOl3sUNsHNVQWBazlaTVRs8Vlee/m7BsZkpc6f8JemJJ77//PODn3tu4IABA7xAISipXhXq9PKFQFKe9FKhnIFeIZed+KgLyB9Bt/NSF3CjRfay5ljc91A0YhRLSl7owROjlghndNXPkykQQXZ0+bPCjCUCTVszw9XETpOxTJxRdpE7sZOgCJnw8EwRXy10IQqH4s4KhPVSFooV2wukM4RVsHb5KCZN5mbHimdRXxs73Gs7sATlaacQNTueNjuCQlP+cpC487XsrDhSyZ3dFNab0ktm22WuOz/NP5xbUMydPSm3zOTXhf5Cahk/Z/GoUaNh50t/eOWxx76dn5/vBQpBSRXfVmiThlmsuG+1uwLuHO281AXUqwmqN1Lc95DVg0bS2RQYgoKD3HjCKinYCY4/Ck2VRGp4hQO5tB0Y0RUTBQfoKxLbQwF0YicjmS3pNV5Q9XZu6MoqEustEdhg9aoOFHdFgHoZC6TLroxkl6JaiaBVELC4Q1zITkyv3RmRlYRlZwroZGdd5MmqySIHQW5unCtXrrrs5M7ee10jZ6dZzOfmsa9ll2flFnBnn5O12hTWjBg3ZUJ8wuDBL/Tr98MRI17iZ729vd0LFILeE3dvgEqiSzWzfxQgUT3yj6xNU0DQI1dAvdjR1cvTRqaXHZSnQBa9BgAHbbqCoOhpFZWqJj4oIrSeOh0xklFbptQoLLgIii50Yqc4QR08PZNDHYxaLG2b3hUEI10IdjXppYmurBbypyZNAJGdihVZwihLdEVGqFtNDXEhT1uGxOuLVklkdgWXyFMWnopmy9NyC5Hs5M7+6+z9wT84M09wi/9mXmXasgLu7EOHDmPsGzNmPflk/8G/GfLssz+Pi4vzotwGZdgFDEuqny8UjJ5351mIKHKQqKnXmxmhawclSiQeyDlsp8KgowFPeMm+M5zaeCo+XXKTosLUtJ5MASJpPbHjg8ITNxRlxwFP1gFd6MTOqMAbvjKeyhiPYl8sUtJESEChKJb4KDSV3kLODEekex1OKESj3OCaAOKWbqGuMPH6olXSlez42Fnb7LjJX7h+/XokO7mzzy7ca7JqzPLgLX70klLYyX4MGfLb+ImT+Fl/+ZU4Ds6SkhIvigNbBkkRFGpQUtVslxeEzQKCqmmrdZ21COyRwiL2NYu6U5Fg5RliV8DV7VgpeEph1gTH0+6adHp5Mlx2FOaCQuUQLOTo4e7s9HEn3Lx5Myo7ubPPXvOxyauNS5oz+c9TuaqzT3xxvjpqdP/+P4KdsbGxXoivNHRGeo27gdeGU9byWPDZeV+42tERlZ3c2UfGjeJHfHZyyvgJCexT4uQpAwcOnDQp0X7AfeWhM9Jr3A3uEWvhs/N+0X75clR2Qk1kftrCP40dBzunTZ/Bz/onn+z3hvnoAnx29gAutbWFsXNVQUDs5M4+fPiLI0fGJb+VUlxc7A3w0TX47OwZXGxtddmZ8f5iqDnqj2NS56dzcHLt8Px83At8dvYYzp+/YNmZuiADdk5/YyZXosiPfR9dhM/OnkRNbZ3YOefdebBz0wel27Zt96nZbfjs7GFUHDkKO2cnvw07KyuPelYf3YLPzp7HPw+VT0xI3LVrt9f20V347HwgaGhs9DQf9wGfnT4eVty69V8EUot+RUAVMAAAAABJRU5ErkJggg== Image3 Transparent 0.2,0.39,7.6,0.4 _x007B_Company.BuildersLicenceNumber_x0021__x003D__x0022__x0022__x007D_,Black,Transparent,Arial_x002C_8,True,False,,,None False Arial,8 fba33dc8597747e0a424d68ea5730fe2 0,0,0,0 Text65 Builders Licence Number: {Company.BuildersLicenceNumber} Black Expression 4261b4bf4f0743a98caedce4dd086158 PageFooterBand2 Transparent 0,0.4,19,2.4 Transparent 9.2,0,9.8,0.4 Arial,8.25 77160a999acd4a5683bdfc0d4b0698bb Right 0,0,0,0 Text20 {Company.LetterheadName} Black DataColumn Transparent 9.2,1,9.8,0.4 Arial,8.25 abd9a4a27f0145e3a9f88f65ceeba033 Right 0,0,0,0 Text22 {Company.Address} Black Expression Transparent 14.3,1.4,2.1,0.4 Arial,8.25 28ace7c3edcb41d4be0ec7ab5b470070 Center 0,0,0,0 Text23 {Company.Phone} Black Expression Transparent 16.9,1.4,2.1,0.4 Arial,8.25 8ee5758efa8f459b87e351917eda58e2 Right 0,0,0,0 Text24 {Company.Fax} Black Expression Transparent 15.8,1.8,3.2,0.4 Company.CountryID,EqualTo,_x0034_,,Numeric,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,8.25 5c1341d3e2e0400dbb3d9fe3c5d8427f Right 0,0,0,0 Text25 {Company.Website} Black DataColumn Transparent 16.9,0.4,2.1,0.4 Arial,6 816064fc14974f31b2d12363a7aff042 Right 0,0,0,0 Text26 {Company.ABNLabel} {Company.ABN} Black Expression Transparent 14,1.4,0.3,0.4 Arial,8,Bold af0828f81e4e41bab61d08300dd0c7a3 Right 0,0,0,0 Text27 P Black Expression Transparent 16.6,1.4,0.3,0.4 Arial,8.25,Bold 9a5f006e6ebd4793bcbcc7bb3c0b450a Right 0,0,0,0 Text41 F Black Expression Transparent 14,0.4,2.8,0.4 Arial,6 476e5fb1085e406b971f829666a643b0 Right 0,0,0,0 Text43 A Johns Lyng Group Company Black Expression Transparent 0,0,8.4,2 CompanyLogos.CompanyID,EqualTo,null,,Numeric,Red,Transparent,Arial_x002C_8,False,False, CompanyLogos.Logo 0b7b374b168f49c2885b9384abce0975 Image6 d25650e6b3ac4b4f9c6ffb2368e6ac18 ReportTitleBand2 Transparent 0,3.6,19,0.8 [210:234:240] 0,0,19,0.6 Arial,10,Bold 1e867163af5d414b9bd8ed16e506db5c 0,0,0,0 Text45 Scope of Works [47:54:153] Expression Center 0,0,19,0.0254 MidnightBlue Black f8773d46544a40b2881bf38b3605e092 HorizontalLinePrimitive1 2 Black 0,0.6,19,0.0254 MidnightBlue Black 7a656e780aae48de8f930e0e766e9479 HorizontalLinePrimitive2 2 Black 3e7d9506c2804d7b94da4d9297bf8356 DataBand4 Transparent 0,5.2,19,0 {EstimateDetails.Level1Sort} 28598a4ca8354a50adf19719275c80ae GroupHeaderBand5 Transparent 0,6,19,0 {EstimateDetails.lv1ID} afc29fd7e07948eba8672c7da4ae2ba2 GroupHeaderBand6 Transparent 0,6.8,19,1 Transparent 0.6,0.2,18.4,0.6 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,EqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,EqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><FilterMode>Or</FilterMode><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><CanAssignExpression>True</CanAssignExpression><BorderSides>None</BorderSides></StiSerializer> Arial,12,Bold 25a1549e33ec437da1403bce5562a406 0,0,0,0 Text46 {EstimateDetails.Header} Black Expression Transparent True 0,0.2,0.6,0.6 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,EqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,EqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><FilterMode>Or</FilterMode><Enabled>False</Enabled><TextColor>Black</TextColor><BackColor>Transparent</BackColor><Font>Arial, 10.2pt, style=Bold</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12,Bold,Point,False,0 8a06259bfb9c4514976e197b9647c888 0,0,0,0 Text47 {EstimateDetails.HeaderNumberDisp} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Transparent 0,0.2,19,0.6 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,NotEqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,NotEqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><Enabled>False</Enabled><TextColor>Black</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,12,Bold 0a3401dd45a248718588b9ef53ebf0fa 0,0,0,0 Text48 {EstimateDetails.Header} Black Expression {EstimateDetails.Header} 60ee04d0c9814f6ea1f1c88cc27f85bd GroupHeaderBand7 Transparent 0,8.6,19,0.8 Transparent True 1.6,0.2,17.4,0.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,EqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,EqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><FilterMode>Or</FilterMode><Enabled>False</Enabled><TextColor>Black</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,10 d120170d8cbf47328eca82d406cbd777 0,0,0,0 Text49 {EstimateDetails.Description} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent True 0.6,0.2,1,0.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,EqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,EqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><FilterMode>Or</FilterMode><Enabled>False</Enabled><TextColor>Black</TextColor><BackColor>Transparent</BackColor><Font>Arial, 10.2pt, style=Bold</Font><BorderSides>None</BorderSides></StiSerializer> Arial,10 699c5b56bfbb4ce08aeb790e08689690 0,0,0,0 Text50 {EstimateDetails.HeaderAndDescNumberDisp} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Transparent True 0.6,0.2,18.4,0.4 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>EstimateDetails.Header,NotEqualTo,SITE_x0020_SPECIFIC_x0020_COMMENTS,,String</value><value>EstimateDetails.Header,NotEqualTo,STANDARD_x0020_EXCLUSIONS,,String</value></Filters><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> Arial,10 be158bb09327446c80ae4ad3b90ad99e 0,0,0,0 Text51 {EstimateDetails.Description} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn EstimateDetails 2ec2aeb36cc8478fb3f61a885191fc79 DataBand5 ASC Level2Sort ASC RecordID Transparent 0,10.2,19,1.8 [210:234:240] 0,0.6,19,0.6 _x007B_HideCosting_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,10,Bold 4022f26a91d448f5b9ab15694a638d9b 0,0,0,0 Text52 Costing [47:54:153] Expression Center Transparent 0,1.2,7.6,0.6 _x007B_HideCosting_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Arial,9,Bold b0c31a2dd5604c1ca831739a6cb46875 0,0,0,0 Text53 TRADE [47:54:153] Expression Transparent 7.6,1.2,4.2,0.6 Arial,9,Bold 001aced5372c44d5ab269dc02eb28dba Right 0,0,0,0 Text54 LABOUR [47:54:153] Expression Transparent 11.8,1.2,3.4,0.6 Arial,9,Bold e31e1e59821d469cbb659786c9b7be45 Right 0,0,0,0 Text55 MATERIALS [47:54:153] Expression Transparent 15.2,1.2,3.8,0.6 Arial,9,Bold fcb1957549be4452943aedfe563c1b0d Right 0,0,0,0 Text56 SUB TOTAL [47:54:153] Expression 0,0.6,19,0.0254 MidnightBlue Black e8d1a67432734525811029d35c4cd358 HorizontalLinePrimitive5 2 Black 16,0.6,3,0.0254 DarkBlue Black 4f5f3748bb9542e88ed9aab601b71c0f HorizontalLinePrimitive10 3 Black _x007B_HideCosting_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None 1cbb39fb55ca461da197452ac31f6a65 GroupHeaderBand8 Transparent 0,12.8,19,0.6 Transparent 0,0,8.8,0.6 Arial,9,Bold 582ee0275fcf4095b79a60ed3798bead 0,0,0,0 Text57 {Costing.CostCode} Black Expression Center Transparent 8.8,0,3,0.6 Arial,9 1f5aae1b4d534b5888a01e5350ea2747 Right 0,0,0,0 Text427 {Costing.LabourTotalExclMargin} Black , 1 0 Expression Center Transparent 11.8,0,3.4,0.6 Arial,9 997dee5e4d944b62b111c2e0ec203065 Right 0,0,0,0 Text428 {Costing.MaterialsTotalExclMargin} Black , 1 0 Expression Center Transparent 15.4,0,3.6,0.6 Arial,9 853c00f568a144a9bec688b28657b8c9 Right 0,0,0,0 Text429 {Costing.LabourTotalExclMargin+Costing.MaterialsTotalExclMargin} Black , 1 0 Expression Center 0,0,19,0.0254 MidnightBlue Black b3851332c1ca48d18b0150ff4e80b70b HorizontalLinePrimitive6 2 Black _x007B_HideCosting_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None Costing 68d0945eea9a490bbac8580f8aa18acf DataBand6 Transparent 0,14.2,19,3.4 Transparent 9.6,0.2,6.4,0.6 Arial,9,Bold 1a9f882399f940b4843f8b92fe1b491a 0,0,0,0 Text58 Subtotal excluding GST Black Expression Center Transparent 9.6,2,6.4,0.6 Arial,9,Bold c04517ece2804c8c93fe221c5447573a 0,0,0,0 Text59 GST Black Expression Center Transparent 16,2,3,0.6 Arial,9 17923f86b750434d8550d965093cdceb Right 0,0,0,0 Text60 {Sum(Costing.LabourTotal + Costing.MaterialsTotal) * Defaults.GST} Black , 1 0 Expression Center Transparent 9.6,2.8,6.4,0.4 Arial,9,Bold e69dcfccd4d641b6840f6388618cdba2 0,0,0,0 Text61 Total incl. GST Black Expression Center Transparent 16,2.66,3,1 Arial,9 4a7fa5491a9d4a91836c1f3cd822df35 Right 0,0,0,0 Text62 {Format("{0:C2}", (Sum(Costing.LabourTotal + Costing.MaterialsTotal)) + (Sum(Costing.LabourTotal + Costing.MaterialsTotal) * Defaults.GST))} Black , 1 0 Expression Center Transparent 9.6,1.4,6.4,0.6 Arial,9,Bold 10feecf79c264798a2af82584e642ba2 0,0,0,0 Text439 Total Black Expression Center Transparent 9.6,0.8,6.4,0.6 Arial,9,Bold 80e6316237bc48e385286d6e734a6852 0,0,0,0 Text437 Claims Handling Fee ({Format("{0:P2}", Sum(Costing.MarginTotal) / Sum(Costing.LabourTotal + Costing.MaterialsTotal))}) Black Expression Center Transparent 16,0.8,3,0.6 Arial,9 e8043f3e3ddd4faf9f6071c4383cbfb4 Right 0,0,0,0 Text438 {Sum(Costing.MarginTotal)} Black , 1 0 Expression Center Transparent 16,0.2,3,0.6 Arial,9 f3e01f7264694e31ab882981d6692cca Right 0,0,0,0 Text432 {Sum(Costing.LabourTotalExclMargin + Costing.MaterialsTotalExclMargin)} Black , 1 0 Expression Center Transparent 16,1.4,3,0.6 Arial,9 a3c039c74f0f485b92e1e2ed79b39fdc Right 0,0,0,0 Text1900 {Format("{0:C2}", Sum(Costing.LabourTotal + Costing.MaterialsTotal))} Black , 1 0 Expression Center 16,2.6,3,0.0254 DarkBlue Black 2963dc42d1634b4c8ebc4d19b910dc7b HorizontalLinePrimitive7 3 Black 0,0.2,19,0.0254 DarkBlue Black e77606e5ffb94a7abb68ac30cf0172f3 HorizontalLinePrimitive8 3 Black 16,1.4,3,0.0254 DarkBlue Black d439b5e1a326460a9f30f2a82c3f8ea4 HorizontalLinePrimitive49 3 Black 0,0,19,0.0254 Black Black b06584865eaf4402828b97a9f6d6add6 HorizontalLinePrimitive9 Black _x007B_HideCosting_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None 7675f8412f854db88ce3e41fa09eaa21 GroupFooterBand1 Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>Company.CountryID,EqualTo,_x0034_,,Numeric</value><value>_x007B_EstimateID_x0020__x003D__x003D__x0020_0_x007D_</value></Filters><FilterMode>Or</FilterMode><Enabled>False</Enabled><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> _x007B_HideScopeOfWork_x0020__x003D__x003D__x0020_1_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None _x007B_PropertyRepairDetails.InsID_x003D__x003D_229_x007D_,Black,Transparent,Arial_x002C_8,True,False,,,None False a8943d9a901a48fcbca30fa75b97d6c5 1,1,1,1 ScopeOfWorkPage-Hollard 29.7 21 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0,19,27.8 EstDetailedScopeInsurer True All;Black;2;None;False;4;Black Transparent 7.6,26.8,2.6,0.4 Arial,9 ff7084b20b204767ad413c8ef37d5f50 Center 0,0,0,0 Text394 {PageNofM} Black Expression Multi<?xml version="1.0" encoding="utf-16" standalone="yes"?><StiSerializer version="1.02" type="Net" application="State"><Filters isList="true" count="2"><value>_x007B_PropertyRepairDetails.InsID_x0020__x003D__x003D__x0020_178_x0020__x007C__x007C__x0020_PropertyRepairDetails.InsID_x0020__x003D__x003D__x0020_2203_x0020__x007C__x007C__x0020_PropertyRepairDetails.InsID_x0020__x003D__x003D__x0020_2529_x007D_</value><value>EstimatingContractType.EstimatingContractID,NotEqualTo,_x0032_4,,Numeric</value></Filters><TextColor>Red</TextColor><BackColor>Transparent</BackColor><Font>Arial, 8pt</Font><BorderSides>None</BorderSides></StiSerializer> False 0eb2cf2bf662422a83b80631e043eca1 1,1,1,1 DetailedScopeInsurer 29.7 21 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 5/19/2020 1:02:15 PM 10/13/2010 2:22:20 PM C:\Work\Finance\EasyBuildWebService\Reports\AssessmentReportRestorx.mrt e33c0065b726426b89a53661e83416ee Report Centimeters 2013.1.1600 CSharp True Transparent Arial,8 Style1 Black Transparent Arial,8 Style2 Black