I have a SQL Server stored procedure that pulls the latest date from a table. When I run that stored procedure, it pulls exactly what I am looking for.
The issue I am having is when I use the stored procedure in my SSRS report, it pulls the second latest date from the table.
In my stored procedure, I have 2 variables, @StartTime
and @Endtime
. When I have those variables as my parameters in SSRS for the report that is suppose to pull the correct times, those SSRS parameters are pulling the second latest date instead of the most recent like the stored procedure does correctly in the first place.
I've already tried refreshing the fields in the SSRS report and that did not work.
Is it possible that SSRS has messed up the times in a way? I can't think of any other reasons why SSRS would display the wrong time and the stored procedure would...