Hi All,


I have a small requirement,
for example.

Table 1

Emp#    Name    Role
101     ABC     MGR
102     DEF     DEV
103     GHI     TEST
104     XYZ     DEV

Table 2


Emp#    Phone
102     99853
103     59982

Due to some join conditions, i'm using sub report for retrieving 'Phone' data and using Emp# for subreport linking.

My requirement

Emp#     Name    Role    Phone
102      DEF     DEV     99853
103      GHI     TEST    59982


But i'm getting

Emp#    Name    Role     Phone
101     ABC     MGR
102     DEF     DEV      99853
103     GHI     TEST     59982
104     XYZ     DEV


i want to eliminate the rows which are getting as NULL for Phone in main report.
How can i?

Above data is just an example,

Due to some filter conditions in base query, i'm getting Phone as null for all Emp#, thus i used it as sub report.

run your subreport above the detail line that displays the results...there are some tricks to this, but then you can suppress.

also, since the subreport is already linked to the Emp# in the main report, I would check on if the Phone# is null...the suppression formula is simply:
isnull(Phone#)

if the phone# is null, then the statement is true and CR will suppress, if there is a value, the statement is false and CR will display...it saves some typing.

HTH