thought id use help as heading rather than reports cos no one seems to like reports!!! k so a few questions about reports in vb...
1.is it possible to set the report to landscape while designing - not just when you print it...

2.can you group things on the report like my report will contain info on customers and transactions they made, and there will be several transactions per customer, and rather than having the customer's , number, name, phone number repeated on every line i was hoping you could group them in some form and have the amounts of their transactions beneath them....I have tried inserting a group header(as by the name i thought thats what its for) but when i opt to preview report it will not preview and gives an error saying does not match data source..any ideas whats with that

3.I want my report to show the sum of the amounts of transactions per customer, but when i add the sum function for the relevant field it will only allow me to place it on the report footer which results in the calculation of the sum of every customer's transaction not individual customers.....do you know if its possible to calculate the sum of amounts for individual customers???

Please answer if u know anything!!!