HI,

how would you suggest doing it in sql query?

Thanks

The client has a sytem that needs the report in that format.

How can i create a second group with details?

Thanks

Hi,

I have attached a design of the report

The ID field i hard-coded in the group by row (OrderGroup). The item number i create =RowNumber("OrderGroup")*10

H is the header (only sold-to,shipto and...

Let me make myself more clear 🙂

The primary keys are different in the 2 dbs. So checksum won't do the trick here.

We don’t have control over the old application and...

Hi,

The client wants all type of charts.