Hi Team
I have a single query and its below, basically the report is to load this data. But the report on my sql server does not load than show this error. "An error occured during local report processing. The definition of the report'/TermLoadsDOA' is invalid The Y expression for the chart 'Chart3'refers to the field 'TimeDiff'. Report item expression can only refer to the fields within the current dataset scope or, if inside aggregate, the specified dataset scope. Letters in the names of fields must use the correct case".
// sql server query
SELECT Date, LoadNumber, FarmName, TrailerQty, ActualCounter, GrossWeight, Tare, DOA, DOA_Perc, (GrossWeight - Tare) / 450.0 AS Kg_Per_Crate, FarmStart, SlaughterTime, AgeOfBirds, Temperature, NetWeight, DATEDIFF(HOUR, FarmStart, SlaughterTime) AS TimeInCrate FROM [dbo].[sfsf_GetDailyBirdWeight](@StartDate, @EndDate);