I have created a project which takes customer name from a table in sql and generates a report. I have created the necessary data environment for it. But I need the Customer name to be printed only once in the report header. The report header however doesn't accept any fields from my query (in SQL). That is, when i drag the required fields from data environment to report header section, the dragged field is not accepted. However, when I drag a field on the "Detail" section of the report, it gets added there. I, as said earlier, Want the customer name to be displayed only once, so I need to put the Customer name in the report header section.
How can I do this in VB 6 without using crystal reports?

PS: I am using Visual Basic 6.0 (no crystal reports) on Win 98 OS.