Creating Master Detail Report in VB

[hiran3727]

Hi,
Please help me to create master detail report in vb. i am using access as database.

I want the report to be as shown below.

Transcode:
TransDate:
RoomCode:

Service_Code Service_Descr Amount Remarks
1 xyz 100
2 kjkj 200
and so on.

I have created a command in the dataenvironment and for that command i have added a child command. but in the report properties, we can assign only one command.. how to assign both command1 and command2 for the report.

Pl help

Regards
Hiran

[CHAMPGARY]

Hello,

For master-detail report

1. You have to create one command for master table
and add detail command as a child command of master table.

2. Add the master command name in datamember property.

3. Now you can drag & drop detail table fields into detail section & master table fields in report/page header.

[Hack]

Moved to reporting section