have you got any ıdea how can I add axapta report on Enterprise portal ???
Thanks Your help
Hi Hulya,
Did you got the solution to display the standard ax report in EP.I am able to display those reports which open directly in AOt but not those such as Sales invoice ,sales confirmation etc.
Please let me know in case you got the solution .
Thanks,
Vikas Mehta.
Hello,
When you are creating EP site, there instead of choosing asp.net web control , there is option of Dynamics AX reporting(somewhat like it) …soo choose that one and it will open your report directly in EP sites…no need of visual studio…
If we have scenario like, client not ready to adapt the SSRS, and he wants the report in EP pages of Dynamics Ax 2009. Eventually we need to use standard Ax reports for generating the reports.
Can we show the standard Ax reports in EP pages?
Yes, we can utilize the same standard Ax reports and can be displayed in the EP pages.
The following example will illustrate the same.
Displaying the Standard Ax Customers report in EP pages.
Create the following Class and add to the Proxies node.
class PSReportRunFromEP
{
Args reportArgs;
ReportName reportName;
ReportRun reportRun;
Report report;
PrintJobSettings printJobSettings;
Query query;
CustAccount custAccount;
}
void initValue()
{
;
reportName = “Cust”;
reportArgs = new Args(reportName);
reportArgs.name(reportName);
}
void reportRun()
{
;
reportRun = new ReportRun(reportArgs);
// Set printersettings
printJobSettings = reportRun.printJobSettings();
printJobSettings.setTarget(PrintMedium::File);
printJobSettings.format(PrintFormat::PDF);
printJobSettings.fileName(“D:\Customers.pdf”);
printJobSettings.suppressScalingMessage(true);
reportRun.report().interactive(false);
If we want add any filters to the query like passing customer account number, then we will use the following statement.
//reportRun.query(query);
reportRun.query().interactive(false);
reportRun.init();
reportRun.run();
}
public static void reportToPDFFile()
{
PSReportRunFromEP reportRunFromEP = new PSReportRunFromEP();
;
reportRunFromEP.initValue();
reportRunFromEP.reportRun();
}
static void main(Args args)
{
;
PSReportRunFromEP::reportToPDFFile();
}
We can test the same, by executing the above class. PDF file will be generated with the customer details.
Development for EP:
Add the above class to the Proxies under AOT àWebàWeb FilesàStatic Files****àProxies
/class:PSReportRunFromEP
/method:PSReportRunFromEP.reportToPDFFile
Create the new web part and add the following code to the web part:
using Microsoft.Dynamics.Framework.BusinessConnector.Session;
using System.IO;
using ApplicationProxy = Microsoft.Dynamics.Portal.Application.Proxy;
using Proxy = Microsoft.Dynamics.Framework.BusinessConnector.Proxy;
protected void Page_Load(object sender, EventArgs e)
{
FileInfo fi = null;
//calling the proxy method for generating the report into PDF file and the same report we are displaying in EP
Microsoft.Dynamics.Portal.Application.Proxy.PSReportRunFromEP.reportToPDFFile(this.AxSession.AxaptaAdapter);
fi = new FileInfo(“D:\Customers.pdf”);
if (fi.Exists)
{
Response.Clear();
Response.ContentType = “application/pdf”;
Response.Flush();
Response.WriteFile(fi.FullName);
Response.End();
}
}
Add this web part to the new page, import the URL definition in to the Ax AOT, and add this URL to web menus of Sales module.
This way, we can show the standard Ax reports in EP pages. 