Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Row count column in executionlogstorage in reportserver db Expand / Collapse
Author
Message
Posted Tuesday, September 10, 2013 5:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 5:35 AM
Points: 7, Visits: 38
The reportserver db has a column rowcount in the executionlogstorage table, the table show incorrect values...even if the report shows some 3 rows as output the rowcount column shows 5 as value..when report query gives 8019 rows ..the rowcount column shows 8058 as values. Has anyone faced the same problem?we have reports that show users who all executed the reports and how much the rowcount was in each execution. But this value what we get is wrong it seems. Is there any workaround for this?
Post #1493103
Posted Tuesday, September 10, 2013 7:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:10 PM
Points: 11,322, Visits: 13,115
If you have multiple datasets the rowcount is the sum of all rows returned by all datasets in the report, not just the main dataset.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1493174
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse