SQL Server 2008 Report Builder: start to learn it!

<< Extending Dynamics NAV with Windows Workflow | Home | Consuming a Dynamics NAV Web Service from Excel 2007 >>

SQL Server 2008 Report Builder: start to learn it!

Microsoft has finally released the final version of its Microsoft SQL Server 2008 Report Builder 2.0 RTM, the tool that every NAV developer will use every day more in the near future.

Microsoft SQL Server 2008 Report Builder 2.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 Reporting Services and it permits to easily create reports (RDL format) based on SQL Server databases.

With few clicks you can build interesting graphs also (I've created in a minute a graph with a KPI of the Sales Order in my NAV database)...

Download it absolutely...

Technorati Tag: Dynamics NAV,SQL Server

Print | posted on Monday, October 20, 2008 3:46 PM

Comments on this post

# re: SQL Server 2008 Report Builder: start to learn it!

Hi Stefano,

Congratulations for your excellent blog! Always a pleasure to read you.

Quick one for you on NAV 2009. Do you know if it's possible to create new Charts? (Little parts we can had in Nav pages). I checked in the folder and it's seems to be using xml files and/or Dundee object?

Regards,

Jacques Bolduc
Presales Director
Createchgroup

Left by Jacques on Dec 19, 2008 3:24 PM

# re: SQL Server 2008 Report Builder: start to learn it!

Hi Jacques,
thanks for your words.
Regarding Charts in NAV 2009, they are stored in system table 2000000078 "Chart". You can view them with form 9182 Charts, or from Administration -> Application Setup -> Role Tailored Client -> Charts.
Charts are defined by xml documents which are stored as BLOB fields. You can export a chart to an xml document, then modify the xml document, and import it back as a new chart.

The rules that you've to keep in mind when creating the XML chart definition are:
- You must specify exactly one Table ID
- You can only have one X-Axis
- You can only have one Filters-element, but it can contain multiple Filter-elements.
- You can only have ony Y-Axis, but it can contain multiple measures.
- Measure operator must be either Count or Sum.

I recommend you to check this blog post:
blogs.msdn.com/.../...to-generate-charts-kpis.aspx

Left by Stefano Demiliani on Dec 19, 2008 3:32 PM

# re: SQL Server 2008 Report Builder: start to learn it!

I would like to ask here ...whether each column data can have their own label at the bottom or not?>>.

Left by Eunice on Jul 14, 2009 11:46 AM

# replica jewelry

would like to ask here ...whether each column data can have their own label at the bottom or not?>>.

Left by replica jewelry on Apr 29, 2010 4:04 AM

# re: SQL Server 2008 Report Builder: start to learn it!

08 Report Builder 2.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 Reporting Services and it perm

Left by wholesale laptop adapter on May 23, 2010 2:38 PM

Your comment:

Title:

Name:

Email: (never displayed)

(will show your gravatar)

Website:

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Please add 1 and 1 and type the answer here:

STEFANO DEMILIANI