axStart: Call non AX reports on SSRS in AX 2012

[Blog bot]

Источник: http://www.axstart.com/call-non-ax-r...srs-in-ax-2012
==============

There are scenarios, that report generated in SQL Reporting Builder, or Visual Studio that are completely not working with AX SSRS reporting integrations. Examples like reports that use non AX data or, are simply to complex building it in AX. But it would be nice to have these reports integrated in the Menu Structure of AX. Even some authorization on top of it would be nice.

So how can we glue a menu item to an SSRS report that does not belong to AX. The trick is using a class. The main method of this class should look like this:

public static void main(Args args)
{
#define.reportName(‘report_name’)
SRSServers srsServers;
SRSReportServerConfiguration reportServerConfiguration;

select   firstOnly srsServers where srsServers.IsDefaultReportLibraryServer;
reportServerConfiguration =   SrsFrameworkServiceHelper::createSRSReportServerConfiguration(srsServers);
if(websession())
{
websession().redirectURL(reportServerConfiguration.reportManagerURL()+’/Pages/Report.aspx?ItemPath=/’+   reportServerConfiguration.reportFolder() +’/'+#reportName);
}
else
 {
infoLog.urlLookup(reportServerConfiguration.reportManagerURL()+’/Pages/Report.aspx?ItemPath=/’+   reportServerConfiguration.reportFolder() +’/'+#reportName);
}
}

You could add a menu item Action to it and use this menu item on the menu.

So will this work ; Yes. But you have to deal with security on SQL yourself. In case the class is running client site it is with the current user security, is it running server site, it is with the service account of the AOS.



Источник: http://www.axstart.com/call-non-ax-r...srs-in-ax-2012

[MikeR]

Не осознал в предновогодней суете а собственно чем просто вызов браузера с url то не устраивает? Там и безопасность на уровне пользователей можно настроить...

[EVGL]

Цитата:

Сообщение от MikeR

Не осознал в предновогодней суете а собственно чем просто вызов браузера с url то не устраивает? Там и безопасность на уровне пользователей можно настроить...

infoLog.urlLookup это и делает.