Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Testing for no data Post Reply Post New Topic
Author Message
Adam
Newbie
Newbie


Joined: 12 Jun 2007
Online Status: Offline
Posts: 4
Quote Adam Replybullet Topic: Testing for no data
    Posted: 12 Jun 2007 at 11:35pm
Hi!
My problem is how can I define no entry data (doesn' exit in data in the database).
 
For exemple  
    "If {relation.A} = 5 OR {DATA DOESN'T EXIT} then TRUE


Edited by BrianBischof - 13 Jun 2007 at 12:31am
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 13 Jun 2007 at 12:31am
If IsNull(relation.A} OR {Relation.A}=5 Then True
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Adam
Newbie
Newbie


Joined: 12 Jun 2007
Online Status: Offline
Posts: 4
Quote Adam Replybullet Posted: 13 Jun 2007 at 12:47am
Thanks for you answer,  I tried but it doesn't work with "isnull", the relation A don't have nulls records, I  just want to print the relation A when there is 5 or when there isn't nothing in the database
 
Adam
IP IP Logged
Adam
Newbie
Newbie


Joined: 12 Jun 2007
Online Status: Offline
Posts: 4
Quote Adam Replybullet Posted: 13 Jun 2007 at 6:14am
I can explain better the problem above:
 
I have two Tables (A and alias_A) in other words two identically tables.Link by ID
 
 
Table.A                                      Table.alias_A
FieldID / ID / Item_ID                 Field- ID /  ID   / Item_ID
15       1110      929                      93      1111      1980
8         980        32                        8         600        45
15       1112      929                       93      1110      1980
15       1111      929                       56      2089      675
13       823        67                         93      1112      1980
                                                     15      1111       929
                                                    
.                                                    .
.                                                    .
I did a filter over{Table.A.Item_ID} =929 and{Table.alias_A.Fiel-ID}=93.
the result will be:
 
FieldID / ID / Item_ID / Field- ID /  ID   / Item_ID
15       1110      929           93      1110      1980         
15       1112      929           93      1112      1980         
15       1111      929           93      1111      1980
 
Now I want print {Table.A.ID} even when  Item_ID or ID doesn't exist, in other words I want that the output will be always "TRUE"
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 13 Jun 2007 at 7:45am
In the Links tab, change the link between the tables to use all the left table records (I forget the terminology right now). If that doesn't work then use a SQL command to create a Left Outer Join. That will show all records in the left table even when there isn't a matching record in the right side table.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.018 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.