SAP and SQL Reporting Services.

[Former Member]

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

[Former Member]

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