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