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
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
mlmcc
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,
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See this article from Crystal
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40a8a5f2-a81e-2b10-da9f-9282db9fedae
mlmcc