troubleshooting Question

SSRS Filtering data incorrectly

Avatar of Leo Torres
Leo TorresFlag for United States of America asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008SSRS
4 Comments1 Solution826 ViewsLast Modified:
Not sure whats the best way to explain this be here we go.

OK here are the facts
chart diagram, January 2011 has a Correct value of 20.733(verified inside the query Designer)

My Issue is if I select a range of January 2011 thru June 2011 on the chart my January 2011 value is 14.66 when it should be 20.733

If I select July 2010 thru June 2011 then I get 20.733 value on my chart for January 2011.

Little FYI on these numbers these numbers represent and average for the past 6 months. The 20.733 is the average for January 2011 and 6 Months back.

The 14.66 represents the average for only January 2011 in order to get the correct January 2011 number I have to start 6Months before January 2011.


I want graph to display correct January 2011 of 20.733 if i pick that as the starting point.

I hope this makes sense I have attached images below to help understand... This is happening to first 6 months of report I need to correct issue
EE1.png
EE2.png
ASKER CERTIFIED SOLUTION
Leo Torres
SQL Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros