or
var data = from week in base.Db.WeeklyInputs where week.FranchiseId == franchiseId && week.Year == year select new { week.FranchiseId, week.WeekEnding, week.CleaningWages, week.BonusWages, week.TotalMaidsAbsent, week.TotalMaidsScheduled, week.MaidTurnover, week.TotalMaidMinutes, week.AverageTeamSize, week.TravelTime, week.QualityCardsReturned, week.QualityCardPoints, Cancels = week.CustomerCancellations, Name = week.Franchise.Title, TotalRev = week.WeeklySalesByLocation.Sum(sales => sales.Sales), TotalUnitsCleaned = week.WeeklySalesByLocation.Sum(s => s.UnitsCleaned), AverageQualityPoints = week.QualityCardsReturned == 0 ? 0 : week.QualityCardPoints/week.QualityCardsReturned, AverageHourlyWage = week.TotalMaidMinutes == 0 ? 0 : (week.CleaningWages)*60/(week.TotalMaidMinutes), RegularRev = week.WeeklySalesByLocation .Where(s => s.LocationType == "Regular").Sum(sales => sales.Sales), FirstRev = week.WeeklySalesByLocation .Where(s => s.LocationType == "FirstEntry").Sum(sales => sales.Sales), OnCallRev = week.WeeklySalesByLocation .Where(s => s.LocationType == "OnCall").Sum(sales => sales.Sales), CommercialRev = week.WeeklySalesByLocation .Where(s => s.LocationType == "Commercial").Sum(sales => sales.Sales), Conversions = week.MarketingExpenses .Sum(marketing => marketing.Conversions), Locations = week.WeeklySalesByLocation .Select(l => new { l.Sales, l.LocationType, l.UnitsCleaned, l.TeamMinutes, l.MaidMinutes, AverageSale = l.UnitsCleaned == 0 ? 0 : l.Sales/l.UnitsCleaned, AverageTime = l.UnitsCleaned == 0 ? 0 : l.MaidMinutes/l.UnitsCleaned, AverageRevPerMaidHour = l.MaidMinutes == 0 ? 0 : (l.Sales/l.MaidMinutes)*60 }), AverageRevenuePerInHomeMaidHour = (week.TotalMaidMinutes + (week.TravelTime*week.AverageTeamSize)) == 0 ? 0 : week.WeeklySalesByLocation.Sum(sales => sales.Sales)/ (week.TotalMaidMinutes + (week.TravelTime*week.AverageTeamSize))*60 };Dim rptContract As New rptSinglePageContract Dim rptProcessor As New Telerik.Reporting.Processing.ReportProcessor Dim Contract() As Byte rptContract.reportHeader.ConnectionString = GetSQLConnectionString() rptContract.reportDetails.ConnectionString = GetSQLConnectionString() rptContract.ReportParameters("ID").Value = m_contract.ID Contract = rptProcessor.RenderReport("PDF", rptContract, Nothing).DocumentBytes If printersettings.PrinterName <> "" Then rptProcessor.PrintReport(rptContract, printersettings) End If IO.File.WriteAllBytes(outputcontractfilename, Contract)When I do a new report and I want to select the source of data using the wizard Telerik Reporting in the drop-down combo there is no data source (connection). I want to create a new connection and the following message when I press the button "Object Reference not Set to an instace of a object"
This problem also occurs when I want to add a new source of data in the contextual menu in the configure option
How can solves this problem? Thanks