Link to home
Start Free TrialLog in
Avatar of bdpcpa
bdpcpa

asked on

Business Objects, Crystal Reports, 2008, Opening a Stored Procedure from SQL

I created a strored procedure that creates multiple tables in MS SQL. When I open the procedure in Crystal, It only shows on table. The data it shows is from the first table out of the 8 tables in total.
USE [OPENENROLL]
GO
/****** Object:  StoredProcedure [dbo].[OpenEData]    Script Date: 10/13/2008 12:03:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		BP
-- Create date: 
-- Description:	Open Data
-- =============================================
ALTER PROCEDURE [dbo].[OpenEData] 
	-- Add the parameters for the stored procedure here
	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
 
    -- Insert statements for procedure here
	select * from [OpenEnroll] where [NET-ENROLL] LIKE '%*0';
select * from [OpenEnroll] where [NET-ENROLL] LIKE '%*1';
select * from [OpenEnroll] where [NET-ENROLL] LIKE '%*2';
select * from [OpenEnroll] where [NET-ENROLL] LIKE '%*3';
select * from [OpenEnroll] where [NET-ENROLL] LIKE '%*4';
select * from [OpenEnroll] where [NET-ENROLL] LIKE '%*5';
select * from [OpenEnroll] where [NET-ENROLL] LIKE '%*6';
select * from [OpenEnroll] where [NET-ENROLL] LIKE '%*7';
select * from [OpenEnroll] where [NET-ENROLL] LIKE '%*8';
END

Open in new window

Avatar of Mike McCracken
Mike McCracken

That is the way Crystal works.  It will only work on a single SELECT statement in  a stored procedure.

See this article from Crystal
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40a8a5f2-a81e-2b10-da9f-9282db9fedae

mlmcc
Avatar of bdpcpa

ASKER

So is there another way around this besides creating all of those tables in sql creating a view and then linking crystal to the view?
You may be able to create a recordset through an applicationi and pass that to the report.

mlmcc
Avatar of bdpcpa

ASKER

You have been very helpful, I will make this my last question. Can you elaborate on what application I could use to create the recordset, I am not an advanced user.
Thanks,
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial