mekofun
asked on
Crystal report - 2 tables link together. miss some data
Hi,
I have a enrolment table which show what segment and year candidates enrolled.
I need to create a report show a candidate enrol for segment A and/or enrol segment B.
I have insert the same table 2 times and link to each other, left outer join. So it suppose whover sit for segment A will show up no matter they sit segment B or not.
The problems is enrolment table is including all different segments. I need to filter out just show segment B. Once I applied this filter, it would only show candidates sit for A and B. Candidate sit for segment A, not sit segment B is not showing.
Thanks
Meko
I have a enrolment table which show what segment and year candidates enrolled.
I need to create a report show a candidate enrol for segment A and/or enrol segment B.
I have insert the same table 2 times and link to each other, left outer join. So it suppose whover sit for segment A will show up no matter they sit segment B or not.
The problems is enrolment table is including all different segments. I need to filter out just show segment B. Once I applied this filter, it would only show candidates sit for A and B. Candidate sit for segment A, not sit segment B is not showing.
Thanks
Meko
ASKER
I haven't written any SQL, just jusing the selection expert.
Ok. Crystal wrote it and as I stated it turns the join into INNER since it won't compare NULL to a value.
You will have to do this through conditional suppression.
Remove the selection filter.
Suppress the record based on
Not IsNull({TableB.FIeld})
mlmcc
You will have to do this through conditional suppression.
Remove the selection filter.
Suppress the record based on
Not IsNull({TableB.FIeld})
mlmcc
ASKER
Sorry to ask, how can I do this :
Suppress the record based on
Not IsNull({TableB.FIeld})
Thanks
meko
Suppress the record based on
Not IsNull({TableB.FIeld})
Thanks
meko
ASKER
Hi
I got the report like this. What I need to generate is Cand sit segment A and pass segment A and cand without sit Segment at all (so CandID 123) also come up in my record.
CandID and Segment/Result is in 2 different table.
If I select segment ="A" or null, will not have any result come up because Segment not equal to null in its table.
CandID Segment Result
123
234 A Pass
234 B Fail
234 C Fail
I got the report like this. What I need to generate is Cand sit segment A and pass segment A and cand without sit Segment at all (so CandID 123) also come up in my record.
CandID and Segment/Result is in 2 different table.
If I select segment ="A" or null, will not have any result come up because Segment not equal to null in its table.
CandID Segment Result
123
234 A Pass
234 B Fail
234 C Fail
Can you show the raw data you are using?
mlmcc
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Where are you wrinting the SQL?
mlmcc