N
neeraj
I have a sales report which is based off a parameter query. Parameters are
being passed to it via a form. This report has sales info about sales reps
which requires to be rolled up a supervisor level and then to manager level.
There are several sales reps under a supervisor and several supervisor under
a manager. The report is working fine, it is designed such that it can take
either manager name or supervisor name or both as criteria(parameter). The
problem is that when I pass the supervisor criteria only, it toatals up the
supervisor correctly but for manager, it gives the same info as supervisor. I
dont need to display manager info when I am passing supervisor info only. How
can I do that? I would prefer this to be done without VB but if thats not
possible, please explain to me your directions as I am new to VB
being passed to it via a form. This report has sales info about sales reps
which requires to be rolled up a supervisor level and then to manager level.
There are several sales reps under a supervisor and several supervisor under
a manager. The report is working fine, it is designed such that it can take
either manager name or supervisor name or both as criteria(parameter). The
problem is that when I pass the supervisor criteria only, it toatals up the
supervisor correctly but for manager, it gives the same info as supervisor. I
dont need to display manager info when I am passing supervisor info only. How
can I do that? I would prefer this to be done without VB but if thats not
possible, please explain to me your directions as I am new to VB