SSRS Tip: Creating Multiple Data Regions In SSRS Reports

Hi Friends,

Today i'll demonstrate how to create multiple data regions/ groups in SSRS reports. A data region in simple definition is a subreport report that shares the parameters and datasets, and is present inside the report design itself. 

• This and the following procedure will help you understand how multiple data regions can be created in SSRS. The first of the two data regions will display the detailed customer transactions.

Note: 1. 1st we have to create a query using CustTrans and CustTable tables and with following fields as shown below.

           2. We are using "AutoDesign" report while creating reports.  

• Create a PktCustTransList query, which includes the CustTable and CustTrans tables. Remove the unwanted fields and retain only the fields that are shown in the following screenshot:

• Open Visual Studio and create a new Report Model Project named PktCustTransReport and create a dataset that refers to the PktCustTransList query.

• When selecting the fields in the query window, select all the fields and the name data method from CustTable.

How To: Create Related Field Fixed Relation In Ax 2012

Hi Friends,
Creating Relations in Ax 2012 is not that much difficult, today ll see how to do it in "3 Simple and Easy Steps" . Lets Start
Note: An Xpo for this example is provided at the end.

Step 1:

Create a BaseEnum  as AccTypeId , with elements as below 

            > Customer  - 0
            > Vendor      - 1

• Create a EDT as AccTypeEDT and in the propertie's you will find a property as EnumType:   Set it to : AccTypeID(Our BaseEnum)

Let say you have 3 tables as following:

1. AccTypeTable.

2. CustomerDetails.

3. VendorDetails.

Step 2:

• Now create  table  AccTypeTable with fields AccountNum(String), AccType(Enum), DepartmentBelongs(String).
Note: When Creating AccType Field create a enumType field and in the properties find ExtendedDataType and fill that with our AccTypeEDT witch we created in step 1.

How To: Use Date Effectiveness Feature in Ax 2012

• Date effectiveness is a new feature in Dynamics AX 2012 allowing developers to easily create date range fields.
•  Date ranges are used for defining record validity between the specified dates, for example, defining employee contract dates.
• This feature significantly reduces the amount of time that developers spend writing code and also provides a consistent approach to implement data range fields.

Note: > We will implement date range validation on the standard E-mail templates form.

          > This Example(Data, Tables, Forms etc etc) is given on the base of Contoso Domain

          > You ll also find an Xpo File To Download at the end of the example.

          > While importing into your AOT it ll ask for replacing the existing one, you can replace it with the new table and form. 

Procedure:

1. In the AOT, find the SysEmailTable table and change its property as shown below 

:

 

Property --> 

ValidTimeStateFieldType : Date

2. Notice the two new fields that are automatically added to the table :

3. Add the newly created ValidFrom and ValidTo fields to the existing emailIdIdx index

and change the properties shown in the following table:

4. The index should look similar to the following screenshot:

Microsoft Dynamics Ax Major Features of Next Release (RAINIER)

Feature's:

The next major release of Microsoft Dynamics AX is code named ’Rainier’. It is a new cloud optimized platform for deployments in private and public cloud as well as on-premises.

1. Cloud Based Solutions.
2. Platform independence - Browser enabled client's.
3. AD (Active Directory) Federation and more integration with Azure.
4. More investments on Visual Studio (Development Environment will be VS).
5. Application Development targeting any OS through Rainier.
6. No longer need to invest on Sharepoint hosting as Enterprise portal will be eliminated.
7. 3 key pillars - New client, Cloud Readiness, New Development Stack.

How To: Import & Export a Model In Dynamics AX 2012 Using Windows PowerShell Commands in Ax 2012

Exporting an .axmodel File (Windows PowerShell)

Procedure: 

1. Click On the Start menu -->point to All Programs
2. Point to Administrative Tools, & then click Microsoft Dynamics AX Management Shell.
3.  A Command Prompt will Appear After clicking Management Shell 
4. At the Windows PowerShell command prompt PS C:\>,
5. Type the following command, and then press ENTER.
   

Ax 2012 R2 Installation Setup Step By Step

Step By Step Procedure: 

Hello Friends,

Here we are have  24 Easy and Simple  Installation Wizard Overview on AX 2012 R2.

Note:  Make Sure The your P.C/ Laptop Is Connected to Internet.

1) Open the Setup Program/Setup Wizard.

 2) Click "Microsoft Dynamics AX Components" under Install.

 3) Click Next.

SSRS Tips: How To Get GrandTotal Using Autodesign in SSRS Report

Procedure:  3 Simple & Easy Step's

1. Open Property Window Of AutoDesign Node In Your Report.

2. Set The "GrandTotal" Property To "Yes".

3.That's it , It will Take care of the printing the total .

Proud To Be a DAX Developer  :-)