OK I am trying it with datasets. I have an invoice report I am trying to create. I have created 3 datasets (1 for Client data, 1 for Reservation AND Boarding data and 1 for Business data)
Page header has data from Client table (dsClient)
Name
Address etc
Page details has data from Reservation and Boarding table keyed by
ReservationID(dsBoardingDetails)
----- Reservation table -------
CheckIn date
CheckOut date
ClientID
ReservationID
--------- Boarding table -----------
Type (type of service they used)
TypeName (actual name of service)
Qty (how many of the Type did they buy)
Fee (price charged for qty = 1)
ReservationID (FK)
Page footer had data from Business table (dsBusinessInfo)
Business name, address etc (1 business per db)
For starters I get the following error
your current link configuration contains multiple starting points
I have no idea what I did to get that or how to fix.
Thanks a ton for any help
Mark