Datereport and Grouping

[timoteo]

I am having a great deal of difficulty displaying my data properly using a datareport. I want a simple report the displays the items assigned to an employee, and then prints their name below a line, on which the employee can sign their name. So it would look like this:

Item Description Inventory #
Widget1 1000
Widget2 1001
Widget3 1002
Etc. etc….

I acknowledge receiving the items list above.

_____________________
John Smith 1/1/2003 – date that equipment was assigned

I have tried several different configurations with my DataEnvironment Commands and with different SQL statements. But, nothing seems to work. I have also tried putting the name and date textbox controls in the report footer, but unlike access reports, datareports do not allow data controls in the headers/footers.

I always end up with either a data shape command text syntax error or results that look something like this:

Item Description Inventory #
Widget1 1000
John Smith

Widget2
John Smith….

I am pulling data from three different tables; employee, item, and assignment. The first two are self-explanatory and the assignment table is basically a transaction table the tracks which items have been assigned/unassigned to which employees.

Is it possible to create this type of report using VB’s datareport. If so, what am I doing wrong?

Any assistance would be greatly appreciated.

Thanks.

Timoteo

 

[timoteo]

Well, I solved my own problem. After lunch I thought some more about the problem and I decided I was working backwards. What I needed to do was make the field I wanted to group by (in this case EmployeeName) as the parent command.

It seems to be working now.

Timoteo

 

[timoteo]

Well, I spoke to soon. The report was generating correctly until I added the date field to the parent command. Under this set up the datareport is grouped by date, then by employee. As a result, the report prints out once for every item that is assigned to the employee.

I am starting to think it is not possible to do this type of report with VB's datareport. Does anyone have any suggestions?

Thank you in advance.

Timoteo