Page 1 of 1
Make Master Detail Report (sub report) With Paramters
Posted: Tue Aug 19, 2014 8:58 am
by 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.
Re: Make Master Detail Report (sub report) With Paramters
Posted: Tue Aug 19, 2014 12:23 pm
by 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.
Re: Make Master Detail Report (sub report) With Paramters
Posted: Wed Aug 20, 2014 7:47 am
by 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
Re: Make Master Detail Report (sub report) With Paramters
Posted: Wed Aug 20, 2014 8:22 am
by 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.