Skip to Content
Former Member
Sep 26, 2012 at 11:21 PM

How to replace tables by a stored procedure



I user Crystal Report 2008 (from an embeded Crystal Report in SAP B1 8.82) and want to replace all the the individual tables used as the datasource for a single SQL Stored Procedure.

My SP returns exactly the same fields as all those used by the report.

I cannot delete the tables because it delete the field

From SetDataSrouceLocation i click on each table on top

select the sp at the bottom click update

I do this for each table

The mapping window used to open because the SP was missing some fields but now they are all there so the mapping window does not open anymore.

When I click close the tables are still in the "Database Fields" section and an dont see the SP

Any idea ?