Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Extending Microsoft Dynamics NAV 2016 Cookbook

You're reading from  Extending Microsoft Dynamics NAV 2016 Cookbook

Product type Book
Published in Jan 2017
Publisher Packt
ISBN-13 9781786460608
Pages 458 pages
Edition 1st Edition
Languages
Author (1):
Alexander Drogin Alexander Drogin
Profile icon Alexander Drogin
Toc

Table of Contents (17) Chapters close

Extending Microsoft Dynamics NAV 2016 Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface
1. Writing Basic C/AL Code 2. Advanced C/AL Development 3. Reporting and Data Analysis 4. .NET Interoperability in C/AL 5. Extending C/AL with COM Components 6. SharePoint Integration 7. Control Add-ins 8. Web Services 9. Events and Extension Packages 10. PowerShell

Designing server-side reports in SQL Server Reporting Studio


In the next recipe we will create a report based on NAV data, but not connected to the NAV server or client in any way. Server-side reports, as the name implies, are rendered on the server and published on a web portal through IIS server. Users can access these reports simply in a web browser from any computer connected to the corporate network.

The process of developing a server-side report is very similar to creating a client-side one, except that the source dataset is provided by an SQL query instead of a NAV server instance.

In source files: folder NAV Report, Visual Studio solution NAVReport.sln.

Getting ready

Download and install SQL Server Data Tools for your version of Visual Studio. The SSDT package is available on MSDN.

Internet Information Services must be installed and running on the computer that the report is going to be deployed on.

How to do it...

The report developed in the recipe shows the top 5 customers generating...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at AU $19.99/month. Cancel anytime}