I am having trouble displaying data from MySQL in Crystal Reports.
I have 3 tables:
tblpropert_room: fk_property_ref, fk_lookup_rootyp_id & description
tbllookup_user: id & decription
tblproperty_room;description = description about each room ie lovely view from the window
tbllookup_user; description = description text for the room name ie bathroom
I can call them using an MySql statement:
SELECT a.no_name, a.address_line1, a.address_line2, a.address_line3,a.address_line4, a.town, a.county, a.postcode, a.display_price, a.general_desc, a.ref, a.viewing_text, a.directions, a.services, b.dimensions_ft, b.dimensions_m, b.description, b.fk_property_ref, b.fk_lookup_rootyp_id, c.description FROM tblproperty a, tblproperty_room_details b, tbllookup_user c WHERE a.ref = b.fk_property_ref AND c.id = b.fk_lookup_rootyp_id AND a.ref= "pra50191"
THE PROBLEM IS HERE......
This data gets passed to a dataset which is then used to design the crystal report. But in a dataset you cannot name a field twice (description; in tblproperty_room_details and tbllookup_user
I have created two datasets, displayed the records, but the problem is that the datasets will not link.
I have tried merging AND linking via the wizard (GUI) - but results in the report adds a room description to each type of room ie bathroom several times. It does not link. This is the problem.
If we could add 2 fields with the same name within a dataset it would work fine as I would state id=fk_lookup_id & ref=fk_property_ref
But I am stuck and unsure of what to do, so any help would be great???
thanks in advance