Joined: 12 Oct 2014
Online Status: Offline
Posts: 2
Topic: Table with information about placement Posted: 14 Oct 2014 at 8:39pm
Help with a report. Table with information about placement. The position is four levels. The table is three columns 1: parrent ID 2: connection ID and 3rd display value.
Table structure:
parrent ID, connection ID, display value
1, 13, Stockholm
13, 67, Hotel
67, 36, Best bed
36, 11, floor 3
13, 72, café
72, 68, house
68, 16, Floor 1
I want to get all locations in the report, for example: Stockholm
Stockholm: Hotel: Best bed: floor 3
Stockholm: café: house: Floor 1
Help!
Do you know how many levels you will have? It would be best to do this through a SQL view. though in crystal the basics isadd the table 4 times, Link Table1.ParentID to Table2.ConnectionID
Table2.ParentID to Table3.ConnectionID
Table3.ParentID to Table4.ConnectionID
you want these as right outer joins.
Just remember of you start apply filters to fields in a higher level then what data exists for then you will loose records.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
