BI Bites 17: SQL Report Builder 3.0

This video continues my series of bite-sized BI demos by introducing another reporting tool. In this demo, I introduce SQL Server Report Builder 3.0 and show how to use the inbuilt wizard to create a report table based on SQL Server data.

For more information and videos about Microsoft Business Intelligence, check out my blog at http://blogs.technet.com/jessmeats

Category:

Science & Technology

Tags:

• BI
• Business Intelligence
• SQL
• SQL Server
• SQL Server Report Builder 3
• Report Builder
• reporting
• reports
• Microsoft

[carvaj1]

JessMeats,

I have been working with RB3 and love it. However, I have to do things like Variance which calculate previous years total profit minus current years total profit and RB 3 does not provide a way to do that. RB3 calculate totals really well but when you start calculating variables independent from the wizard, it does work well.

Is this a matter of creating tables first in SQL before using RB3?

Thanks.

[JessMeats]

@carvaj1 Yes, one way to do this would be to have the calculated column in the SQL table which you could then consume in RB3.

[jesuslaborda1]

video is boring

[vidvid70]

@zainabAmir

Report Builder 3 works only with SQL Server 2008 R2

[zainabAmir]

Hi,

am installing SQL 2008 in single server and I tried to use the builder to build a report following the abovr video, but there is error when I try to connect to the database, The report builder cannot detect the server.!!

Please advice