VB6/CR10 Report Question
Posted on 2004-10-20
SQL Server 2K
I've currently got a VB application that calls a report based off entries from 2 drop down boxes. I have a different report for each combination of drop down box selections. Well I have to create another set of reports based off of 2 other drop down boxes. There has to be an easier way to do this right?
Here's my situation...
I have a DB table with the following columns:
Name, Supervisor, Manager, EmpType, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dece
Jan - Dece are populated with " " (a blank space) or "X" (a letter X)
I have a form in VB with a drop down for month (January - December)
and a drop down for Manager (list of manager names pulled from separate DB table)
When the user selects 'Joe Blow' from the manager drop down and 'January' from the month drop-down here's what needs to occur:
A report is pulled that gives the following
Name, Supervisor, and EmpType where Manager = 'Joe Blow' and Jan <> 'X'
This would need to change based on the Manager and Month selected from the form.
Is there an easier way to do this that creating a report for each scenario? If so...would I do it in Crystal or VB? How?