How to Use VB Data Report ???

[lengwai]

hie ...

I have one data environment form and a data report form.
In the data environment form i have more than 1 commands.

In the report i need to load data from 2 tables. Is that possible? Because I am having some problem making the data report to read from 2 different command.

I have to set the data member property of the entire data report form to a specific command. Can I change it during run time??
or what should be the event should the codes falls under??

thanks man ..

leng wai

[transio]

Try making one command that JOINs two tables.

[lengwai]

I had thought of that but it does work for what i want to do.

Say for example, have 2 tables. The customer and SAles.
each sale entry should belong to a customer.

So What i need to do is , i need to generate a data report for customer 'A'. Ofcourse i can use a query in the command to filter unrelated infomation. What about the header of the report. I need only a customer info that exist only once.


If i Use a join, probably the entry will see more than 1 customer A exist.

thankz.

leng wai

[transio]

If you're using Crystal, you can either group by CustomerId and put the customer information into Group A, with the Order information into the Detials A...

OR

You can have two commands... and use subreports to put the orders into a Details B section.

[lengwai]

Okay ... thanx ...I'll try if i know how to do a sub report.

regards,
leng wai