Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Table with information about placement Post Reply Post New Topic
Author Message
mmegaman
Newbie
Newbie
Avatar

Joined: 12 Oct 2014
Online Status: Offline
Posts: 2
Quote mmegaman Replybullet 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!
Beginner :-)
IP IP Logged
z9962
Senior Member
Senior Member
Avatar

Joined: 04 Jul 2012
Online Status: Offline
Posts: 161
Quote z9962 Replybullet Posted: 14 Oct 2014 at 11:38pm
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 is
add 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.
 
 
IP IP Logged
mmegaman
Newbie
Newbie
Avatar

Joined: 12 Oct 2014
Online Status: Offline
Posts: 2
Quote mmegaman Replybullet Posted: 15 Oct 2014 at 2:05am
Absolutely wonderful. Thank you, you have saved my day!
Beginner :-)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.