I have a user who is trying to reference a stored procedure from InfoMaker.
Here are the steps she's taking.
Create a New Tabluar Object.
In Tabular Report Generator, click Stored Procedure, and then click Next.
Choose the stored procedure that the user created, and then click Next.
Here's the code behind that stored procedure.
USE [TmsEPrd]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SHU_SP_CHS_REPOPULATE_TEL_WEB_GRP_CDE]
AS
UPDATE sm
SET sm.TEL_WEB_GRP_CDE = 'CH'
FROM NameMaster nm
INNER JOIN STUDENT_MASTER sm ON nm.ID_NUM = sm.ID_NUM
INNER JOIN DEGREE_HISTORY dh ON nm.ID_NUM = dh.ID_NUM AND dh.CUR_DEGREE = 'Y' AND dh.MAJOR_1 = 'CHS'
WHERE sm.TEL_WEB_GRP_CDE IS NULL AND
ISNUMERIC(sm.UDEF_10A_1) = 1 AND
-- You can modify the > to >= if you want the years greater than the current year AND the current year
sm.UDEF_10A_1 > (SELECT CONVERT(varchar,YEAR(getdate())))
Click Next on Select Color and Border Settings.
Click Finish on Ready to Create Tabluar Report.
This error message appears and doesn't allow for the continuation of creating the stored procedure object.
DataWindow Wizard
Cannot create DataWindow.
'Requested result set number 1 not found.
1 execute dbo.shu_sp_chs_repopulate_tel_web_grp_cde; 1'
When I run the stored procedure in SSMS it returns 0 rows. Is that the problem? It doesn't give an error - it just returns nothing.
Thanks as always!
Paul Weir
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.