Make Master Detail Report (sub report) With Paramters

[me22ml]

I have Master Data source and child Data Source I need to pass Parameter from master data source to filter the child data source,The Child Data source is Stored Procedure taking a parameter from the master data source.

[HighAley]

Hello.

Sorry, maybe we don't understand your problem.
Why don't you use simple Master-Detailed report?
Could you describe your problem more detailed with samples?

Thank you.

[me22ml]

I have made a sample reports with 2 data-sources
the 1st (Master) data-source

Code: Select all

CREATE PROC TestSp_GetEmployees(@DepartmentID AS INT)
AS
SELECT e.EmpID,
       e.EmpName
FROM   Employees AS e
WHERE  e.DepartmentID = @DepartmentID
	 	 	 

and the 2nd

Code: Select all

	 CREATE   PROC TestSp_GetSalary(@Empid AS INT)
	 AS
	 SELECT s.Salary_MonthNO, s.Salary_YearNO, s.Salary_Adds, s.Salary_Net
	FROM Salaries AS s WHERE s.Fk_EmpID=@Empid

all I need to pass the Empid form the 1st data-source to the 2nd one in the sub report

[HighAley]

Hello.

The report engine gets data from database once before starting the report rendering.
It seems that you came to Stimulsoft from Crystal Reports. Then you should read The main differences of reporting features between Crystal Reports and Stimulsoft Reports article.
Did you read and watch how to create master-detail report in our User Manual?

Thank you.