Krash_io
asked on
Help with VB6 report in Report Designer
I would like to construct a report that shows an employee's gas usage per vehicle. Basically, I want to output a group for every employee, and ouput a row for every unique vehicle per employee. The report would look something like this:
-------------------------- ---------- ----------
[Unique Employee]
[Unique Vehicle] (record has same employee ID)
[Gas Usage]
[Gas Usage]
[Another Unique Vehicle] (record has same employee ID)
[Gas Usage]
[Gas Usage]
[Gas Usage]
[Another Unique Employee]
[Unique Vehicle] (record has same employee ID)
[Gas Usage]
[Gas Usage]
[Another Unique Vehicle] (record has same employee ID)
[Gas Usage]
[Gas Usage]
[Gas Usage]
-------------------------- ---------- ----------
I'm having problems doing this "double group" (grouping on employee and then grouping on vehicle within employee) with the data environment and report designer. I think I might need to use a child command in the data environment but I'm not sure. Can anyone help me out on this? I need to do this report tonight!
Thanks!
--------------------------
[Unique Employee]
[Unique Vehicle] (record has same employee ID)
[Gas Usage]
[Gas Usage]
[Another Unique Vehicle] (record has same employee ID)
[Gas Usage]
[Gas Usage]
[Gas Usage]
[Another Unique Employee]
[Unique Vehicle] (record has same employee ID)
[Gas Usage]
[Gas Usage]
[Another Unique Vehicle] (record has same employee ID)
[Gas Usage]
[Gas Usage]
[Gas Usage]
--------------------------
I'm having problems doing this "double group" (grouping on employee and then grouping on vehicle within employee) with the data environment and report designer. I think I might need to use a child command in the data environment but I'm not sure. Can anyone help me out on this? I need to do this report tonight!
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I will leave a recommendation in the Cleanup topic area that this question is:
Answered TimW1
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
leonstryker
EE Cleanup Volunteer