SAP and SQL Reporting Services.

Former Member — Fri, 29 Apr 2005 19:53:26 GMT

Hi,

I'm trying to implement a few reports using MS SQL Reporting Services. I don't think that SAP (we are currently on 4.6C, and BW is not an option for now) has anything nearly as cool. The problem is that SQL RS can only create queries against ODBC and OleDB providers. One of the solutions would be to create a view in SAP DB and query against it, but the logic behind is just too complicated for a view that you can create in SAP. Is there another way that I can interface SAP real time to SQL RS? Anyone had experience with that, or is there a solution from SAP with similar capabilities?

Thanks,

Leon

Re: SAP and SQL Reporting Services.

Former Member — Tue, 05 Jul 2005 13:57:08 GMT

Hi Leon,

maybe you can use the SAP.NET Connector and save the results in SQL-SERVER-Tables or use the OLEDB Provider for SAP from NSX software.

Greetings,

Andreas Rohr

topic Re: SAP and SQL Reporting Services. in Application Development and Automation Discussions

SAP and SQL Reporting Services.

Re: SAP and SQL Reporting Services.