Post reply

Matrix counts not agreeing with data

  • October 20, 2010 at 3:15 pm

    #230652

    I have a matrix that give counts of widgets broken out by month (rows) and investor (columns). When I run the same query the report uses in management studio, I get different numbers. For example, the report says 1083 for investor X in September, but the data in management studio says 1196 for the same criteria. Has anyone run into this behavior, or have an idea of what may be going on?

    Thanks in advance,

    Jason

  • October 20, 2010 at 3:34 pm

    #1239976

    I'd start with doublechecking the ssrs is looking at the correct database and doesn't have a filter you aren't seeing. After that I forget if data cache'ing can cause this issue, but it would depend on how recently the data got modified.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply