Microsoft Dynamics NAV 2009: Professional Reporting
eBook:
$35.99
Formats:
Formats:
$30.59
save 15%!
save 15%!
Print + free eBook + free PacktLib access to the book:
$95.98
Print cover: $59.99
$59.99
save 37%!
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
| Also available on: |
|
- Get an overview of all the reporting possibilities, in and out of the box
- Understand the new architecture and reporting features in Microsoft Dynamics NAV 2009 with this book and e-book
- Full of illustrations, diagrams, and tips with clear step-by-step instructions and real-world examples
Book Details
Language : EnglishPaperback : 352 pages [ 235mm x 191mm ]
Release Date : October 2011
ISBN : 1849682445
ISBN 13 : 9781849682442
Author(s) : Steven Renders
Topics and Technologies : All Books, Microsoft Dynamics, Enterprise, Microsoft
Table of Contents
PrefaceChapter 1: Charts and Dimensions
Chapter 2: Creating a Report in the Classic Client
Chapter 3: Creating Role Tailored Reports
Chapter 4: Visualization Methods
Chapter 5: Developing Specific Reports
Chapter 6: Other Reporting and Business Intelligence Tools
Chapter 7: A View of the Future
Index
- Chapter 1: Charts and Dimensions
- Role Centers
- Charts
- Chart panes
- Limitations of chart panes
- Chart parts
- Chart security
- Chart performance
- Reports
- List reports
- Test reports
- Posting reports
- Transaction reports
- Document reports
- Other reports
- Printing reports
- Determining print report settings
- Printer selection
- Report selections
- Creating reports without development tools
- What are dimensions?
- Global
- Shortcut
- Budget
- Where are dimensions set up?
- Dimensions and dimension values
- Dimension values
- Dimension combinations
- Default dimensions
- View posted dimension information
- Analysing financial information using dimensions
- Dimension-based reports
- Summary
- Chapter 2: Creating a Report in the Classic Client
- The Report Designer
- Using the report wizard
- Form type report
- Tabular type report
- Label type report
- Creating a simple List report
- Sorting and grouping data in a report
- Sections in a classic report
- Controls
- Triggers
- What happens when a report runs?
- How is a data item processed?
- Properties in a report
- Adding color to a classic report
- What is a ProcessingOnly report?
- Creating an Excel-like layout for a report
- Printing a report to Excel
- What is so special about the Excel Buffer table (370)?
- Report functions
- Summary
- Chapter 3: Creating Role Tailored Reports
- The optional enhanced layout
- Why you cannot call it Reporting Services
- Difference between RDL and RDLC?
- Printed reports versus online reports
- Creating your first enhanced report
- What's happening?
- Adding formatting, grouping, sorting, and filtering to a report
- Report creation workflow
- Using multiple data items
- Using the Create Layout Suggestion option
- Changing the template
- Making a report available in the Role Tailored client
- Limitations of enhanced report design in Dynamics NAV 2009
- Summary
- Chapter 4: Visualization Methods
- Report items
- Common report item properties
- Text box
- List data regions
- Document Outline
- What is the List control used for?
- Undo/Redo
- Matrix boxes
- More advanced matrix techniques
- Using colors in a matrix
- Green bar matrix
- Chart data regions
- Adding images to your report
- Expanding/collapsing report sections
- Interactive sorting
- Using the document map
- Linking reports
- Bookmark links
- Hyperlinks
- Filtering a report
- Filtering a page
- Multi-column reports
- Headers and footers
- Expressions
- The Fields collection
- The Globals collection
- The ReportItems collection
- The User collection
- Functions
- Useful tips and techniques
- Use a title, page numbers, and show applied filters
- Using rectangles, lines, and images
- Adding a report border
- Tracking report usage
- Checking on empty datasets
- Using a report layout setup table
- Blanking properties
- Pagination
- Use rectangles
- Give everything a proper name
- Test, test, and test
- Summary
- Chapter 5: Developing Specific Reports
- Document reports
- The number of copies option
- Displaying data-bound information in the header
- Working with addresses in reports
- Displaying the current page and copy number
- TOP X reports
- Creating a TOP X table
- Creating a TOP X chart
- Using the wizard
- Adding KPIs and conditional formatting
- Simulating data bars
- Simulating spark lines
- Implementing conditional formatting
- Choosing the right colors
- Summary
- Chapter 6: Other Reporting and Business Intelligence Tools
- Knowing your data and database
- Dynamics NAV database design
- How is the Dynamics NAV database created in SQL Server?
- Relations and foreign keys
- Using an Entity Relationship model
- Reporting Services
- Using Report Builder
- Using BIDS
- Comparing RDL and RDLC
- Using Microsoft Excel with Dynamics NAV
- Excel Data Mining Add In
- PowerPivot
- Business Intelligence and NAV
- Business Analytics
- The advantage of having a BI solution
- Summary
- Chapter 7: A View of the Future
- Dynamics NAV 7 and beyond
- Jet Reports Express
- RDLC mandatory and 2008 integration
- Section designer replaced with an extended data item designer
- Dynamics NAV and SharePoint
- Dynamics NAV in the cloud
- What will SQL Server do?
- Project Crescent
- BISM
- Summary
Steven Renders
Sorry, we don't have any reviews for this title yet.
Code Downloads
Download the code and support files for this book.
Submit Errata
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
Sample chapters
You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.
Frequently bought together
+
=
50% Off
the eBooks
the eBooks
Buy both these recommended eBooks together and get 50% off the total price
- Create reports using RDLC technology in the Role Tailored Client
- Use the Visual Studio Report Designer and customize it to meet your requirements
- Develop Document reports
- Estimate the time required to develop specific types of reports
- Explore the hidden Dynamics NAV report capabilities
- Use expressions to simulate conditional formatting in Dynamics NAV reports
- Learn everything about Charts and Chart types in the RTC
- Get a view of the other technologies in the BI world and how to integrate them to the Dynamics NAV database
- Add interactive features such as Visibility Options, Interactive Sort, Document Maps, and Pictures to the report
Microsoft Dynamics NAV is widely used in enterprises with its enhanced reporting features, but there still isn’t a book that covers reporting in depth, until now. This book will show you what’s possible and exactly how to develop reports for Dynamics NAV 2009. Learn why reports are designed in a specific way and then apply this knowledge to your advantage.
Microsoft Dynamics NAV 2009: Professional Reporting is an essential guide to understanding the effort involved in creating reports in Dynamics NAV 2009, and all of the available reporting possibilities. Reading this book will result in a better understanding and it will help you save time during development.
The book starts with an overview of what kind of reports you can create without a developer using charts, dimensions, and analysis views. The next chapter will introduce the new architecture of Role Tailored Client (RTC) reports and the basics on how to create them or have them generated. Moving on we will discuss data visualization, where you will learn how and when to implement all the available Visual Studio controls. Document reports and other types of specific reports are covered next, and you will get to know all the best workarounds for getting them to work correctly.
Knowing other related features is vitally important to obtain a helicopter view of all the reporting possibilities of Dynamics NAV, and the next chapter will introduce Business Intelligence concepts and available technologies that could be used in combination with the Dynamics NAV database. Technology is evolving rapidly and new versions of Dynamics NAV are in the pipeline, so the book will also provide you with a view to the future and how to prepare for it.
This book doesn’t assume any prior experience with Dynamics NAV reporting. It is designed as an easy to follow guide, where each chapter builds upon the previous one, but can also be read completely separately. Basically this book is for everyone who is using Microsoft Dynamics NAV or has an interest on the reporting capabilities of NAV 2009. The book does not have major prerequisites, although it is mainly focused on Dynamics NAV 2009, RDLC and Business Intelligence.
Whether you are a Dynamics NAV consultant, developer, customer, project manager, or just interested in the reporting capabilities of Dynamics NAV, this book can provide you with information from a helicopter view down to the smallest details, tips and tricks, and workarounds. Empowered with the information in this book you should be able to master, analyse and deliver the most challenging reporting requirements in Dynamics NAV.
