INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...The enviroment is simple, natural and efficient. The members are competent, educated and professionals..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Web Development > Information Builders, Inc.: WebFOCUS Forum

Missing data from displayed reports

Read More Threads Like This One

nwrprtr (Programmer)

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)

6 May 02 7:22

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)

7 May 02 10:31

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)

7 May 02 19:48

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)

9 May 02 11:34

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)

28 May 02 9:30

Try this!!

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Information Builders, Inc.: WebFOCUS