Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Dynamics AX 2012 R3 Reporting Cookbook Update

You're reading from   Microsoft Dynamics AX 2012 R3 Reporting Cookbook Update Over 90 recipes to help you resolve your new SSRS Reporting woes in Dynamics AX 2012 R3

Arrow left icon
Product type Paperback
Published in Mar 2015
Publisher
ISBN-13 9781784395384
Length 352 pages
Edition 1st Edition
Languages
Arrow right icon
Toc

Table of Contents (12) Chapters Close

Preface 1. Understanding and Creating Simple SSRS Reports 2. Enhancing Your Report – Visualization and Interaction FREE CHAPTER 3. Report Programming Model 4. Report Programming Model – RDP 5. Integrating External Datasources 6. Beyond Tabular Reports 7. Upgrading and Analyzing Reports 8. Troubleshooting and Other Advanced Recipes 9. Developing Reports with Complex Databases 10. Unit Test Class and Best Practices Used for Reports Index

Adding ranges from unbound parameters to a query


SSRS reports support using parameters that are not part of a dataset. This recipe will attempt to use the unbound parameters FromDate and ToDate added to the report to set the ranges in the report query. These parameters are added to the report and are not connected to any dataset. The values in these controls will be received and set in the report query.

How to do it...

  1. The first step is to create a contract and UI builder class and bind them together (assuming you have created the parameters as discussed in the first recipe Opening a report through a controller).

  2. Add a UIBuilder class that extends SRSReportDatacontractUIBuilder as follows:

    public class PktRdlItemTransListUIBuilder extends SrsReportDataContractUIBuilder
    {
    
    }
  3. Add a contract class that extends SRSReportRdlDataContract as shown in the following snippet:

    [
        SrsReportNameAttribute(ssrsReportStr(PktRdlItemTransList, ItemTransList)),
        SysOperationContractProcessingAttribute(classstr...
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 $19.99/month. Cancel anytime
Banner background image