Archive

Archive for the ‘Dynamics Ax’ Category

Productivity tip: Do you need the under score when naming – Dynamics Ax

October 4, 2013 Leave a comment

Well When we sat through the product review there was one simple point that caught our attention, surprisingly it helped us improve our productivity. This post is to share on what we learnt.

Typically i have seen several implementation and product development teams adopting the ‘_'(underscore) naming convention. In fact we followed it through out Dynamics AX 2009. Though at the very first look it appears helpful in hindsight it deters productivity.

How ?

1. While you type holding a shift key is not making typing faster.

2. Every time you declare a variable you are again held up with underscores

3. On the AOT node navigating is definitely not easier.

If you look all these points at a component level it can be ignored but when you do it over and over it adds up to a significant time.

Next time you start a new project or product consider if you need to use the underscore ‘_’ again.

Advertisements

Dynamics Ax 2012 Reporting cookbook published & 5 reasons why you should go for it

September 30, 2013 Leave a comment

Hello everyone,

I’m very happy to inform you that the Dynamics AX reporting cookbook I authored is now published and available through major retailers online.

amazon-com amazon-co-uk barnes-nobleimages

If you had pre-ordered it through packt then you should already have it in your hand. If not and you are still thinking if this book is for you, here are 5 reasons that tells you how buying this book is a good choice.

7720EN_MockupCover_Cookbook

  1. Understand the inners of reporting Framework: This book helps you understand the framework portions like the controller, preprocessing, temptable marshaller to the depth with the help of flowcharts and diagrams. Just because you do it better when you know it better.
  2. Better choice of controllers and data source: The book has one or more examples for all the possible controls including the ones that are not found in the out of the box reports and discusses every possible data source available for the reports with examples. Just because you make a better choice when you know the options better.
  3. Speed up development and testing: Inside the book there are unique techniques that can help you speed up development as well gain time by quick tricks to fasten testing. Just because you get time to be creative when you make your routines easier.
  4. Implementation pattern reference: There are recipes in this book for typical development patterns like validations, defaulting values, building lookups, multi value lookups, inventory & financial dimensions and much more. Just because Google is not your only friend we are here too 🙂
  5. Analyze and Handle issues faster: The book has step by step in detail guidance to approach development issues, upgrades and design. It speaks about additional tools that can help you understand report performance and usage. Just because your mysterious must not remain unresolved.

curious and want to know more before buying ??

Look at the table of contents here  or Download the sample chapter from here

Interested in reviewing this book in  your blog ? Please contact me @casperkamal[at]gmail[dot]com

Interested in learning SSRS – Attend my SSRS session at AXUG see more details here

This blog has more SSRS tips revealed from the book read them here

Dev Tip: Activating document handling for inquiry(read only) forms – Dynamics Ax 2012

September 20, 2013 Leave a comment

This post will explain how document handling can be activated only for specific tables or for all tables.

Activate document handling for selective tables.

To activate document handling for selective tables.

Go to Organization administration -> Setup -> Document management -> Document management parameters

Check the flag “Use active document tables

selective_active_document

Once specified here then document handling is active only for selective list of tables. To specify the active list of tables  go to Organization administration -> Setup -> Document management -> Active document tables. Document handling is now only enabled for the selected tables in a controlled mode.

active_doc_table

Activate document handling for all tables.

Simply unchecking the  “Use active document tables” in Document management parameters makes it activate for all tables. There is a limitation here, in the case where document handling is enabled for all tables the system verifies if the table has edit/delete permission. Only if it is the case document handling is activated otherwise it is disabled. E.g This means tables like Salestable/Salesline will have permission to add/edit documents while forms that uses tables like custInvoiceJour, vendinvoice jour will have document handling disabled.

User’s may ask for document handling to be activated on these read only  forms. In these case there is a way out.

Go to Organization administration -> Setup -> Document management -> Active document tables and enter the table name, say “VendInvoiceJour” also make sure to check the “Always enabled” flag. This is very important since this means the document handling is enabled irrespective of the table permission. So this way you can activate document handling for read only tables

alwayenabled

\Forms\DocuView\Methods\doReSearch – Go to this method

on line Number: 130 – add the following line,

allowEditBasedOnActualForm = true

codeimage

Setting this will enable you to use the full document handling feature even for read only forms.

SSRS Tip: Using invisible parameters in contracts – Dynamics AX 2012

September 18, 2013 3 comments

There can be cases where you wanted a contract in the attribute but do not want the UI builder to expose it to the user. The reporting framework in AX provides a very easy way to incorporate this.

Open the parm method in the contract that you don’t want to expose. Add the attribute shown here along with other attributes. This attribute when found in the parm method will automatically prevent the UI builder from adding this to the dialog.

[DataMemberAttribute, SysOperationControlVisibilityAttribute(false)]
public LogisticsAddressing parmAddress(LogisticsAddressing _address = companyAddress)
{
companyAddress = _address;
return companyAddress;
}

This feature comes as a part of the BOF, see here http://j.mp/185ufd2

Update: Apologize for the wrong statement here. The only way to make a parameter visible when using the contract with reporting framework is to specify it in the design. This is because the contract class \Classes\SrsReportRdpDataContractInfo\buildMemberAndNestedObjectMap – 29 ignores this attribute and reads the design RDL (created using your VS) to decide if a parameter must be visible in the contract. So to hide your parameter open the parameters node in Visual studio and then set the visibility property to hidden.Also a point to understand is that the VS design overrides any specifications at the contract level for properties like  LableHelp, Visibility, grouping, HelpText, value type (multivalue) etc. (Ref: \Classes\SrsReportRdpDataContractInfo\fillReportDesignProperties). Thanks to a AXForum member who pointed this out.

2013-09-30_1910

For more tips and learning about SSRS – AX 2012 order the book Dynamics AX 2012 Reporting Cookbook authored by me.

7720EN_MockupCover_Cookbook

SSRS Tip: Using labels for dynamic texts in SSRS reports – Dynamics Ax 2012

September 16, 2013 9 comments

Dynamic text in the reports makes them more readable and meaningful. In this article we will see how we can use labels from  AX to construct your dynamic text. The string format option comes handy to help us do this.

Here is how you must specify a string text with labels in it.

Open the report control properties and on the property “Value”, select the expression option and place your text in the format seen here.

=System.String.Format(“This is a label id converted at run time {0}”, Lables!@SYS1560);

You can also use report or data base fields like Fields!CustTable.Value to construct your Dynamic text.

For more tips and learning about SSRS – AX 2012 order the book Dynamics AX 2012 Reporting Cookbook authored by me.

7720EN_MockupCover_Cookbook

SSRS Tip: Speed up RDP based SSRS reports testing in Dynamics Ax 2012

September 11, 2013 15 comments

When working on precision designs a lot of time is spent on waiting for the preview to run. If your precision design uses an RDP dataset here is a simple and fantastic tip to speed up.

1. Convert your temporary table to persistent by modifying the TableType property to Regular

2. Now run the report once. Either from Visual studio or inside Ax. This fills the data in the temporary table.

3. Comment the code inside processreport method or simply write a “return” statement on the first line of the method.

That’s it. you are now geared for a faster execution of the reports. Remember to revert back once you are done or wait for the testers to find it 🙂 but don’t let it go to the production.

For more tips and learning about SSRS – AX 2012 order the book Dynamics AX 2012 Reporting Cookbook authored by me.

7720EN_MockupCover_Cookbook

SSRS tip: No row message in Dynamics Ax SSRS 2012

September 9, 2013 13 comments

Some sections in your report may not have data but the header sections  might print. In these cases to make it informative for the user a “No data available” message might be helpful since the user is then assured that there is no data for that particular data section. This tip will guide you on how to setup “No data available”.

Select the Tablix/List/Matrix control where you want the message to be available and open the properties window, Find the property “NoRowsMessage”. This property can be filled in with text or for dynamic text using expressions. Type in something like “No data available”

2013-08-30_1553

When there is no data for that particular section SSRS automatically prints the text under “NoRowsMessage”

2013-08-30_1550
For more tips and learning about SSRS – AX 2012 order the book Dynamics AX 2012 Reporting Cookbook authored by me.

7720EN_MockupCover_Cookbook