Saturday, October 1, 2016

Error in Visual Studio 2010 (There is no editor available for ../Form1.vb. Make sure the application for the file type (.vb) is installed)

Visual Studio 2010: There is no editor available for ../Form1.vb. Make sure the application for the file type (.vb) is installed

Problem:




While opening a form the above message is showing in VS 2010.

Solution:


1. Click on show all files button located on the top left corner of Solution Explorer as marked below.


2. Expand Reference tab on the tree view.


3. Right click on the item with Yellow Triangle  with "!" mark and remove that reference.


Thant's it.
Thanking you and hope enjoy life with right information.
Have a nice day...

Regards,
Mr. 221



Wednesday, November 4, 2015

How to repeat Row Header on SSRS Report (AX 2012)

How to repeat Row Header on SSRS Report (AX 2012)


During SSRS report for Dynamics Ax 2012, I found that when report goes on multiple pages, column header did not appear all page except the first one.
I fix this problem by setting some properties to true.

Select the Tablix1 and below right side of columns group header and click there on small arrow head and select the advance Mode.


Now right click on top static in row groups, or Press F4 to open the properties window.

From property window, set propertyRepeatOnNewPage to True. Also set KeepWithGroup property to After

Deploy the report and the header will repeat on each page.
Thanking you and have a nice day!

Regards,
Mr221

Wednesday, October 21, 2015

Access Denied in DMF in ax 2012 R3 While sharing folder

Problem:

When installing DIXF on multiple computers or when changing the user account of the DIXF service sometimes there is a inconsistency the configured user rights.


In your startmenu go to "local users and groups"(lusrmgr.msc)

Check for the existence of a group called "Microsoft Dynamics AX Data Import Export Framework Service Users"

It if does not exist just create it with this exact name.

Make sure your DIXF account and AOS account are members (usually this is the same)

A reboot is required (really it is!) for the changes to take effect.

Have a Nice Day!!!
Regards,
Mr. 221

Access Denied in DMF in ax 2012 R3 While sharing folder

Problem:

When installing DIXF on multiple computers or when changing the user account of the DIXF service sometimes there is a inconsistency the configured user rights.


In your startmenu go to "local users and groups"(lusrmgr.msc)

Check for the existence of a group called "Microsoft Dynamics AX Data Import Export Framework Service Users"

It if does not exist just create it with this exact name.

Make sure your DIXF account and AOS account are members (usually this is the same)

A reboot is required (really it is!) for the changes to take effect.

Have a Nice Day!!!
Regards,
Mr. 221

Tuesday, October 6, 2015

Hi,
If you need to show all the triggers attached with a SQL Database, this is the one way as use the query as follows,

SELECT
     sysobjects.name AS trigger_name
    ,USER_NAME(sysobjects.uid) AS trigger_owner
    ,s.name AS table_schema
    ,OBJECT_NAME(parent_obj) AS table_name
    ,OBJECTPROPERTY( id, 'ExecIsUpdateTrigger')    AS isUpdate
    ,OBJECTPROPERTY( id, 'ExecIsDeleteTrigger')    AS isDelete
    ,OBJECTPROPERTY( id, 'ExecIsInsertTrigger')    AS isInsert
    ,OBJECTPROPERTY( id, 'ExecIsAfterTrigger')     AS isAfter
    ,OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger') AS isInsteadof
    ,OBJECTPROPERTY(id, 'ExecIsTriggerDisabled')   AS [Disabled]
FROM sysobjects
INNER JOIN sysusers
    ON sysobjects.uid = sysusers.uid
INNER JOIN sys.tables t
    ON sysobjects.parent_obj = t.object_id
INNER JOIN sys.schemas s
    ON t.schema_id = s.schema_id
WHERE sysobjects.type = 'TR'

Thanking you &
Have a nice day!!!

Mr. 221

Tuesday, August 11, 2015

Create and implement sequence number

Scenario:
New Reservation code, ST

Step 1:
Create new sequence number into number sequence setting


Step 2:
Insert code into table layer method.

Step 3:
Implement methods into form base datasource methods.




Thanking you and have a nice day!!



How to print the SSRS report in dynamics ax 2012 from code.

SrsReportRun srsReportRun; // initiate the report. 
srsReportRun = new SrsReportRun ("InventTruckTransactionReport.PrecisionDesign1"); 
srsReportRun.init(); 
srsReportRun.reportCaption("InventTruckTransactionReport.PrecisionDesign1"); // set parameters name, value. 
srsReportRun.reportParameter("TruckTransDS_JournalId").value("000161_070"); // suppress the dialog 
srsReportRun.showDialog(false); 
if( srsReportRun ) 
{ // run the report 
       srsReportRun.executeReport(); 
}