September 25, 2015 at 1:44 pm
In an ssrs 2012 report, there are start and end date parameters that are supplied. Regardless of what the start and end dates are that are supplied to the ssrs report, the summarized data always stays the same.
Thus I am guessing there is a problem with the start and end date sql logic. However could there be a potential problem where the data is cached and the values do not change? If this is the case, would you tell me how this can occur and what can I do to prevent the problem from continually occurring?
September 25, 2015 at 2:45 pm
Starting and ending dates seem to be an issue for many people. Are the database fields datetime data types? Then check if the code is considering the time portion of the data.
For example, starting 01/01/2015 and ending on 01/31/2015
Parameters passed from SSRS are interpreted as midnight. Unless the code considers that, the data from 01/31 is left off.
As for caching questions, take a look at this article.
https://msdn.microsoft.com/en-us/library/ms155927.aspx
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply