Compatibility Result for Microsoft SharePoint 2010 - August 2010

http://blogs.technet.com/b/dynamicsaxse/archive/2010/08/12/new-compatibility-testing-result-august-2010.aspx

ClrObject static method invocation error

Queries:

I am getting a "ClrObject static method invocation error" when deleting the file after sending the email.

Answer:

You have to close the stream after sending email.

Sample code that might help,

fileStream = attachment.get_ContentStream();

fileStream.Close();

Other issue can be with the permissions, assert the permissions before deleting.

Time in Dynamics AX

In AX time is represented in seconds. The formula for time is following,

time = hours * 3600 + minutes * 60 + seconds.

Insert into temporary tables

1- http://www.axaptapedia.com/Temporary_tables

Passing Parameter to SSRS Report

http://www.mssqltips.com/tip.asp?tip=1336

That assembly does not allow partially trusted callers

Query:

I am getting the following error when running reports,

"That assembly does not allow partially trusted callers"

Answer:

This is because you are using a direct reference to BusinessConnector and more security is required for that. You should never use any classes which require direct access to Business Connector.

Dynamics AX SSRS, passing parameter to datamethod

When you assign a datamethod to a query under dataset it automatically creates a parameter for you.\

Links: http://msdn.microsoft.com/en-us/library/cc587341.aspx

Error passing Int64 parameter to the SSRS report

Update the type of parameter to System.Decimal and recompile

How can we send emails from AX using SMTP

file: download xpo

Please find attached xpo of info class. It contains modifications, required to send email without outlook. Previously sysINetMail class was used to send report through email. Now I used 'System.Net.Mail' assembly, which do not require any outlook integration.

How to send Report through Email

Setup:

• Email address defined on 'user options' form, will be used as sender email.
• Smtp server defined on 'Email parameters' form will be used (company > Administration > Administration area > Setup > Email paramters)
• Remaining parameters like To, Cc, Subject e.t.c will be picked from the specific report you want to send ( from the report dialog goto Options and select 'email recipients' and provide the information and attachement format)

Process:

• Open the report you want to send through email.
• From the report dialog, select Options button.
• Select the option of 'Email recipients' and provide the necessary detail.
• Press OK to close the options form.
• Press OK to close the dialog, now the report will become an attachement in the format you selected and sent.

Microsoft Domain-Specific Language Tools can not be found

Install Visual Studio 2008

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=aca38719-f449-4937-9bac-45a9f8a73822&displaylang=en

Managing Client Versions

How do you know if you have updated all of your client machines to the correct and current AX version?

https://community.dynamics.com/product/ax/axtechnical/b/axinthefield/archive/2010/09/16/managing-client-versions.aspx

ClrBridge issue when deploying reports

Query:

I am getting a ClrBridge issue when deploying reports.

Answer:

Restart your server and it should work.

AL.exe is not installed

Query :

I am deploying the reports on the reporting server but getting the following error, "AL.exe is not installed"

Answer:

This is because you have not installed the .Net SDK, install it from here, http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e6e1c3df-a74f-4207-8586-711ebe331cdc&displaylang=en, and you should be good.

You must install SQL server 2005 Reporting Services Service Pack 2 before installing the report extensions

Query:

I am trying to install this extension. When I run the Setup, I get the following message : "You must install SQL server 2005 Reporting Services Service Pack 2 before installing the report extensions".

Answer

It is because you need a hot fix. You can get the hot fix from here, https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYXUPYZQPOUXNXSPSYRYYMQTUNYUROMKPUTXTUVNQONXVWPPQN&wa=wsignin1.0#appliesto