Guest User

Guest User

  • Tech Writer
  • 2.1k
  • 473.1k

Error when loading my sql server report

Jul 31 2024 4:46 AM

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);

 


Answers (1)