main report and subreport parameter passing problem.

[ub1234567]

Hi Everyone,
Hope all are doing fine.

my report looks like below.
parameter 1 - department 1 to 10.
user can select 'ALL' or any one department.
parameter 2. - employee level B to F.
user can selec anyone between B to F.
parameter 3. - employee level B to F.
user can select anyone level between B to F.

report looks.

employee_ssn DOB Phone employee_talent_code
1.
2.
3. ------details----

total no. of emp : 101
total of each talent_code:
code 1:10 code2:25 code3: 35
code 4: 45

--this is the display total no of emp in report that satisfy creteria and shows total talent code.

total no. of emp in departmetn 1: 33
total of each talent_code for department 33:
code 1: 5 code 2: 13 code 3:11
code 4: 12


total no. of emp in departmetn 2: 67
total of each talent_code for department 67:
code 1: 15 code 2: 18 code 3:19
code 4: 89

same way this display for all department from 1 to 10
this is diaplay total no. of employee in each department and total talent code in that.

i am using one sub report to count total no. of emp and total of each talent_code for all department.

second subreport to display total no. of emp in each deartment.
third sub report for counting talent_code for each department.

i am using sql command for each report.
i am using exacly same sql command of main report in
all sub report.
and then in sub report according to creteria i am doing
grouping of department and code.

main report filter reocrds according to parameter.
then i am passing only whatever the employee ssn in main report which satisfy condition, to all sub report.

so no need to filter records in each sub report.

so i am mapping ssn of main report to each sub report.

but when i am doing this, then it gives me results for only one employee.

but i need for all emp which satisfy condition.

thanks.
any kind of help appriciated.

 

[lbass]

I don't see why all of these subreports are necessary. You could just be inserting a crosstab in the report footer or report header that uses department as the row field, talent code as the column field, and distinctcount of employees as the summary.

Anyway, if you feel the need to use subreports for some reason, you need to identify the groups in the main report, the report sections in which each sub is located, and the way each sub is linked to the main report.

-LB