Missing data from displayed reports

Question

Missing data from displayed reports

nwrprtr (Programmer)

(OP)

3 May 02 20:29

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 (MIS) · Answer 1 · 2002-05-06 07:22:52

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 (TechnicalUser) · Answer 2 · 2002-05-07 10:31:50

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

nwrprtr (Programmer) · Answer 3 · 2002-05-07 19:48:12

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 (IS/IT--Management) · Answer 4 · 2002-05-09 11:34:40

FYI...
We have a great tutorial on Match vs Join by IBI's Art Greenhaus at www.webfocus.info/atl-ibug.

See the knowledgebase

eSearing.com
version 2.something now available

**Guest** (visitor) · Answer 5 · 2002-05-28 09:30:27

Try this!!

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

Come Join Us!

Posting Guidelines

Missing data from displayed reports