Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: information not showing Post Reply Post New Topic
<< Prev  Page  of 2
Author Message
swilleyk
Newbie
Newbie
Avatar

Joined: 25 Oct 2011
Location: United States
Online Status: Offline
Posts: 18
Quote swilleyk Replybullet Posted: 03 Nov 2011 at 7:17am
The first part for parent 1 works great, its the second for parent 2. This is what I have

if isnull({datatel_undergraduateapplicationforadmissionExtensionBase.datatel_parent2collegeid})
then 'No School Listed' else {AccountBase_1.Name}

but get an error that table name unknown.

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Nov 2011 at 7:19am
did you add the AccountBase table to the report a second time and link it to the datatel_parent2collegeid feild (outer join)?
IP IP Logged
swilleyk
Newbie
Newbie
Avatar

Joined: 25 Oct 2011
Location: United States
Online Status: Offline
Posts: 18
Quote swilleyk Replybullet Posted: 03 Nov 2011 at 7:32am
Nope,

And you sir are a certifiable genius

Thank you very much


IP IP Logged
<< Prev  Page  of 2
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