Missing data from displayed reports

nwrprtr · May 3, 2002

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 · May 6, 2002

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 · May 7, 2002

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

nwrprtr · May 7, 2002

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 · May 9, 2002

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 · May 28, 2002

Try this!!

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Missing data from displayed reports

nwrprtr

Programmer

mrguru

MIS

w860098

Technical User

nwrprtr

Programmer

esearing

IS-IT--Management

Guest_imported

New member

Similar threads

Part and Inventory Search

Sponsor