Question Status

Suggested Answer
maram fraij asked a question on 29 Dec 2013 8:43 AM

I need to build a SSRS report  base on a customized SQL Query  using reporting tool available in SQL then export it under AX environment, is there a tool supports this ?

Reply
Dick Wenning responded on 29 Dec 2013 10:38 AM

use the visual studio integration tools, those are part of the ax installation software

Kind regards, 

Kaya Solutions

Dick Wenning

+31 6 147 989 53 

Landjuweel 5

3905 PE - Veenendaal

 

OTHER CONTACT INFORMATION

Reply
maram fraij responded on 30 Dec 2013 12:44 AM

Would you please provide me with more details about this tool and how this can be performed after building the report using SQL report  builder

Reply
Dick Wenning responded on 30 Dec 2013 3:34 AM

Please ignore my first awnser, incase you dit it with SQL report  builder ,

technet.microsoft.com/.../ms155872(v=sql.100).aspx

the SQL report builder is part of SQL, AX is not aware of it.

Kind regards, 

Kaya Solutions

Dick Wenning

+31 6 147 989 53 

Landjuweel 5

3905 PE - Veenendaal

 

OTHER CONTACT INFORMATION

Reply
maram fraij responded on 30 Dec 2013 4:19 AM

That means I cannot build a report using SQL report builder and then access it via AX similar to SSRS report built using visual studio.

Reply
Suggested Answer
Dick Wenning responded on 30 Dec 2013 5:43 AM

you can add an url from a menu item in AX

public static void main(Args args)

{

   #define.reportName('XXXXX')

   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);

   }

}

Kind regards, 

Kaya Solutions

Dick Wenning

+31 6 147 989 53 

Landjuweel 5

3905 PE - Veenendaal

 

OTHER CONTACT INFORMATION

Reply
Suggested Answer
Dick Wenning responded on 30 Dec 2013 5:43 AM

you can add an url from a menu item in AX

public static void main(Args args)

{

   #define.reportName('XXXXX')

   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);

   }

}

Kind regards, 

Kaya Solutions

Dick Wenning

+31 6 147 989 53 

Landjuweel 5

3905 PE - Veenendaal

 

OTHER CONTACT INFORMATION

Reply