danial tehrani

danial tehrani

  • NA
  • 26
  • 12.8k

How can I use LINQ in Crystal Report

Jun 9 2010 2:27 PM

Hi
I am using Crystal Report for creating a report. I have two tables, Driver_Specifications and Watch.
Primary key of Watch is foreign key of Driver_Specifications. I set some field in my report file to show the data of Driver_Specifications and I want to show a specific field of Watch instead of the foreign key of Driver_Specifications. What is the query of LINQ for this problem?
This is what I have so far:
var q = (from d in taxi_AgencyDataSet.Driver_Specifications 
         orderby d.First_Name, d.ID_Driver 
         select new 
         { 
             d.First_Name, 
             d.Last_Name, 
             d.Car_Name, 
             d.Car_Color, 
             d.WatchRow.Watch_Name, 
             d.ID_Watch 
         }).ToList(); 

I get the following error:
Object reference not set to an instance of an object

Answers (1)