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

Is ReportBuilder V1 usable? Expand / Collapse
Author
Message
Posted Thursday, May 9, 2013 10:02 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 5:31 AM
Points: 1,191, Visits: 793
I am trying to evaluate whether we could get away with ReportBuilder V1 (because our server is SQL 2008) or whether we should upgrade to SQL Server 2012, hence ReportBuilder v3.

I tried a very simple report based on a model I generated out of our datamart.

I just tried (and failed!) to sum some values without any criteria.
It looks like ReportBuilder V1 returns the distinct values instead of the SUM!

I tried to use both "# MyValue" and "Total MyValue" but got the same result.

I then did the same experiment with ReportBuilder V3 and it worked fine...

Based on that simple test, it looks like I should not approach ReportBuilder V1!

Has anyone some advice on this?

Many Thanks
Post #1451234
Posted Friday, May 10, 2013 2:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 5:31 AM
Points: 1,191, Visits: 793
How embarassing... It was my mistake!

I had taken the wrong calculation...

Post #1451471
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse