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