Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Microsoft Dynamics GP 2013 Reporting - Second Edition
  • Table Of Contents Toc
Microsoft Dynamics GP 2013 Reporting - Second Edition

Microsoft Dynamics GP 2013 Reporting - Second Edition

5 (4)
Buy this Book
close
close
Microsoft Dynamics GP 2013 Reporting - Second Edition

Microsoft Dynamics GP 2013 Reporting - Second Edition

5 (4)
Buy this Book

Overview of this book

Table of Contents (21 chapters)
close
close
close
Microsoft Dynamics GP 2013 Reporting
Icon
Microsoft Dynamics GP 2013 Reporting
Credits
Icon
Credits
About the Author
Icon
About the Author
Acknowledgments
Icon
Acknowledgments
About the Author
Icon
About the Author
Acknowledgments
Icon
Acknowledgments
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
Meeting the Reporting Challenge
Icon
Meeting the Reporting Challenge
Icon
Trends in reporting
Icon
Challenges to developing and writing reports
Icon
Summary
2
Where Is My Data and How Do I Get to It?
Icon
Where Is My Data and How Do I Get to It?
Icon
System databases versus company databases
Icon
Dynamics GP table naming/numbering conventions
Icon
Locating Dynamics GP data using the Resource Descriptions windows
Icon
The Table Import utility
Icon
Accessing data at the table level using SQL Management Studio
Icon
Locating Dynamics GP data with additional tools
Icon
Summary
3
Working with the Builders – SmartList and Excel Reports
Icon
Working with the Builders – SmartList and Excel Reports
Icon
Utilizing default SmartLists to meet basic reporting needs
Icon
Extending SmartList data to Excel by deploying Excel Reports
Icon
Creating and publishing new SmartLists using SmartList Builder
Icon
Deploying new Excel Reports with Excel Report Builder
Icon
Additional tips and tricks for using both Builders
Icon
Summary
4
Report Writer and Word Templates
Icon
Report Writer and Word Templates
Icon
Storing and accessing Report Writer reports
Icon
Opening and navigating the Report Writer windows
Icon
Modifying all reports in the application by using global modifications
Icon
Modifying an existing Dynamics GP report
Icon
Importing and exporting customized reports
Icon
Rendering reports with the Microsoft Word template feature
Icon
Summary
5
Utilizing the SSRS Report Library
Icon
Utilizing the SSRS Report Library
Icon
Getting started with SSRS
Icon
Deploying SSRS reports and metrics
Icon
Using the predefined SSRS reports
Icon
Viewing charts and KPIs using Business Analyzer
Icon
Configuring security for Reporting Services
Icon
Modifying default reports with Visual Studio
Icon
Creating a new reporting metric via Report Builder
Icon
Summary
6
Designing Your Analysis Cubes for the Excel Environment
chevron up
Icon
Designing Your Analysis Cubes for the Excel Environment
Icon
Understanding the components of the Analysis Cubes environment
Icon
Installing Analysis Cubes
Icon
Exploring the Analysis Services database
Icon
Modifying our Analysis Cubes environment
Icon
Considerations for upgrading Analysis Cubes for Excel
Icon
Summary
7
Utilizing Analysis Cubes for Excel for Dynamic Reporting
Icon
Utilizing Analysis Cubes for Excel for Dynamic Reporting
Icon
Using an OLAP viewer to connect to the SSAS database
Icon
Creating a connection to cubes
Icon
Excel PivotTable – Analysis Cubes interface
Icon
Creating ad-hoc reports
Icon
Utilizing Excel CUBE formulas
Icon
Creating dashboards from Analysis Cubes data – a few thoughts
Icon
The seven default cubes
Icon
Summary
8
Designing Financial Reports in Management Reporter
Icon
Designing Financial Reports in Management Reporter
Icon
Management Reporter architecture
Icon
Installing and configuring Management Reporter
Icon
Management Reporter security
Icon
Navigating the Management Reporter Report Designer interface
Icon
Working with the Management Reporter building blocks
Icon
Improvements in Management Reporter 2012
Icon
Tools for reducing building block sprawl
Icon
Summary
9
Viewing Financial Reports in Management Reporter
Icon
Viewing Financial Reports in Management Reporter
Icon
Overview of Report Viewer for Management Reporter
Icon
Report Library permissions
Icon
Generating reports via Report Designer
Icon
Navigating the Report Viewer interface
Icon
Navigating reports via the Web Viewer
Icon
Summary
10
Bringing it all Together
Icon
Bringing it all Together
Icon
Looking back at what we've covered
Icon
Viewing our reporting tools in light of the reporting challenges
Icon
The future of reporting for Dynamics GP
Icon
Summary
1
Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges
Icon
Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges
2
Index
Icon
Index

Exploring the Analysis Services database

Earlier, we discussed connecting to the Analysis Services database via SQL Server Management Studio. As we saw then, connecting to the SSAS database via SQL Server Management Studio is useful in some situations, such as when we need to add or remove users to security roles or when we need to process the entire database at once. By and large, however, most of our access to the Analysis Services database will occur through SQL Server Data Tools. SQL Server Data Tools replaces the more commonly known Business Intelligence Development Studio (BIDS). If you are using SQL 2008 or earlier, then use BIDS in place of SQL Server Data Tools for the remainder of this chapter. Each product is installed as a component of the SQL Server installation, and is found under the same Program Files folder as SQL Server. Those of us who are familiar with Visual Studio will have no problem using SQL Server Data Tools as it's nothing more than a spinoff of Visual Studio...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Microsoft Dynamics GP 2013 Reporting - Second Edition
End of Section 6
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon