Using Indicators to Visualize Data in SQL Server Reporting Services Reports

SQL Server Reporting Services 2008 R2 introduced many features in the area of graphical display of information. According to MSDN, there were three new features introduced in SQL Server 2008 R2—maps, sparklines and data bars and indicators. This final article of a three-part series on data visualization will explore the features of indicators as we […]

Posted on September 28, 2013 at 18:00 by admin · Permalink · Comments Closed
In: Dynamics · Tagged with: , , , , , , ,

Using Indicators to Visualize Data in SQL Server Reporting Services Reports

SQL Server Reporting Services 2008 R2 introduced many features in the area of graphical display of information. According to MSDN, there were three new features introduced in SQL Server 2008 R2—maps, sparklines and data bars and indicators. This final article of a three-part series on data visualization will explore the features of indicators as we […]

Posted on July 23, 2013 at 11:57 by admin · Permalink · Comments Closed
In: Dynamics · Tagged with: , , , , , , ,

Using Sparklines & Data Bars to Visualize Data in SQL Server Reporting Services Reports

SQL Server Reporting Services 2008 R2 introduced many features in the area of graphical display of information. According to MSDN, there were three new features introduced in SQL Server 2008 R2:  maps, covered in a previous blog post, sparklines and data bars and indicators. In this second of three articles on data visualization, we will […]

Posted on May 24, 2013 at 05:45 by admin · Permalink · Comments Closed
In: Dynamics · Tagged with: , , , , , , , ,

Using Maps to Visualize Data in SQL Server Reporting Services Reports

SQL Server Reporting Services 2008 R2 introduced many features in the area of graphical display of information. According to the Microsoft Developer Network, there were three new features introduced in SQL Server 2008 R2:  maps; sparklines and data bars; and indicators. In this first article of a three-part series on data visualization, we will explore […]

Posted on May 15, 2013 at 17:40 by admin · Permalink · Comments Closed
In: Dynamics · Tagged with: , , , , , , ,

Using CTEs with SQL Reporting Services & Dynamics GP

Mike Urbom and I had a great time doing a webinar recently for the GPUG Special Interest Group (SIG) for SQL Reporting Services. We talked about using Common Table Expressions (CTE) to simplify queries for reports. CTEs were new in SQL Server 2005 and can replace using derived tables. Essentially, they create temporary result sets […]

Posted on March 8, 2013 at 18:43 by admin · Permalink · Comments Closed
In: Dynamics · Tagged with: , , , ,

Using CTEs with SQL Reporting Services with Microsoft Dynamics GP

Christina Phillips explores Common Table Expressions (CTEs) and how they can be used to simplify selecting data for comparisons when creating SQL Reports for Microsoft Dynamics GP.  She walks through the structure of a SQL statement containing CTEs and then uses the statement to create a comparative sales report with Report Builder 3.0. BKD presented […]

Posted on March 8, 2013 at 11:51 by admin · Permalink · Comments Closed
In: Dynamics · Tagged with: , , , , ,

Creating Financial Reports with SQL Server Reporting Services

SQL Server Reporting Services (SSRS) combines a single, complete reporting platform with a scalable and extensive architecture to meet a wide variety of reporting needs. SSRS can help management gain access to critical business data. Charles Allen discusses how SSRS can be used to create financial reports, develop financial report tables in SSRS and learn […]

Posted on November 5, 2012 at 11:59 by admin · Permalink · Comments Closed
In: Dynamics · Tagged with: , , , , ,

Professional Services Tools Library – FREE

As a Dynamics GP user, you may be aware of the Professional Services Tools Library (PSTL). This collection of tools enables users to perform various functions or turn on functionality not present in GP. Microsoft had additional tools, not available as part of PSTL, that could be purchased. Historically, this suite of tools had free […]

Posted on May 8, 2012 at 11:42 by admin · Permalink · Comments Closed
In: GP · Tagged with: , , , ,