C#

int TotCount = 0;            
string[] PkgIDs = rptData.Transaction.Where(c =>c.Package_ID.StartsWith("rva") &&
                                c.Received_Date != null ).Select(c => c.Package_ID).ToArray();
            foreach (string PkgID in PkgIDs)
            {
                var eCnt =  rptData.Details.Where(c =>c.Package_ID == PkgID).Select(c =>c.TotalTrans);
                TotCount = Convert.ToInt32(eCnt);
            }


My problem line of code is:    var eCnt =  rptData.Details.Where(c =>c.Package_ID == PkgID).Select(c =>c.TotalTrans);

select COUNT(Tran_ID) as good_count
            from dbo.Trans t
            inner join dbo.table1 iw on iw.pkg_id = t.pkg_id
             inner join dbo.table2 ip on ip.pkg_id  = iw.pkg_id
            inner join dbo.table3  tt on tt.pkg_id = ip.cust_Number
             where (t.cust_Date is not null) and
             SUBSTRING(ip.item_Number,1,3) = 'UC3'

Quote:

Description:
Stopped working

Problem signature:
Problem Event Name: CLR20r3
Problem Signature 01: orderackreport.exe
Problem Signature 02: 1.0.0.0
Problem Signature 03: 505c3a77
Problem Signature 04: CrystalDecisions.CrystalReports.Engine
Problem Signature 05: 12.0.2000.0
Problem Signature 06: 489a2f19
Problem Signature 07: 2f7
Problem Signature 08: 43
Problem Signature 09: System.NullReferenceException
OS Version: 6.0.6002.2.2.0.272.7
Locale ID: 1041