Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • 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.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Missing data from displayed reports

Missing data from displayed reports

Missing data from displayed reports

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?


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???  

RE: Missing data from displayed reports

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

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

RE: Missing data from displayed reports

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

RE: Missing data from displayed reports

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!!!

RE: Missing data from displayed reports

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

See the knowledgebase

version 2.something now available

RE: Missing data from displayed reports

Try this!!

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close