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?