Skip to Content
0
Former Member
Jan 22, 2011 at 02:39 AM

link between main report and sub report

25 Views

Hello;

I have a report and within that a sub-report.

Both are based on stored procedures which accept parameters. However two reports have different parameters.

The main report has a parameter called parmFolderRSN . The stored procedure in main report retrieves ProcessRSN and so on based on FolderRSN user entered.

stored procedure for parent

CREATE PROCEDURE [dbo].[sp_parent_Jean]

@parmFolderRSN int = NULL

AS

SELECT Folder.FolderRSN, FolderProcess.ProcessRSN, Folder.FolderName

FROM Folder,FolderProcess

WHERE Folder.FolderRSN = FolderProcess.FolderRSN

AND Folder.FolderRSN =@parmFolderRSN

The child report should use ProcessRSN retrieved from main report

stored procedure for child:

alter PROCEDURE [dbo].[sp_child_Jean]

@parmProcessRSN int = NULL

AS

SELECT FolderProcess.FolderRSN, FolderProcess.ProcessRSN, FolderProcess.AssignedUser

FROM FolderProcess

WHERE FolderProcess.ProcessRSN = @parmProcessRSN

I did not set up parameter for the sub report. But I did link.

In the link I set ProcessRSN as link field between main and sub report.

While preview the main report by enter 1 as parmFolderRSN , I am expecting to get 6 rows from sub report. However I only got 6 empty rows for sub report,. Please help? What was wrong?