Missing data from displayed reports

[nwrprtr]

I am sort of new to WebFOCUS. When run and display a fex report, focus is not printing duplicate row information. How can I enable focus to print all data whether it is duplicate or not?

example:

last name first name service_date
doe john 4/15/01
. . 5/25/01
. . 7/18/01
. jane 4/12/01
. . 4/19/01


Any ideas???

 

[mrguru]

table file xxxx
print lastname as 'last name'
firstname as 'first name'
service_date
by lastname noprint
by firtsname noprint
end

The report will be sorted properly and all values will be displayed...

 

[w860098]

Can I suggest you look at the recent entry by 'sumathy' at the FOCUS forum. She has exactly the opposite problem to you !

 

[nwrprtr]

I solved my own problem. I should have posted more information. The missing information only occurs when I use a MATCH FILE. Instead of using MATCH FILE, I have effectively solved this problem using the JOIN statement or incorporating SQL into the report. Thanks for the help!!!

 

[esearing]

FYI...
We have a great tutorial on Match vs Join by IBI's Art Greenhaus at

http://www.webfocus.info/atl-ibug.

See the knowledgebase eSearing.com
version 2.something now available

 

[Guest_imported]

Try this!!

table file xxxx
print
-*lastname as 'last name'
-*firstname as 'first name'
service_date
by lastname
by firtsname
end