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!
  • Students Click Here

*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




I would be very grateful if some one could answer these two questions:
Firstly: I am trying to create a report with more than one file. How do I do this?
I have tried opening more than one file at the command prompt by using 2 different
work areas. Everything goes alright until I run the form when I find that for one of the
files the same record keeps being displayed.
Secondly: I have already created a query. How do I base a report on it?

RE: Reports

Have you related the two files ? Both the files must be open at the time of the report generation. Simultaneously you can try the "report form ..for" command.
 If not satisfied please let me know some more details.

RE: Reports

Ams is correct, FoxStudent..but you may find it easier and simpler to just do an SQL SELECT ... JOIN on the two tables to give you a single cursor from which to report.

Let us know the details if you need more help.

RE: Reports

I have worked with 2.6 for a long time now and this is the process I use for 99% of the reports I do.

Use query designer to retrieve the data that I need and direct the output to a cursor.

In the view window select the cursor as the current workarea.  I find it easier to close all other workareas.

Open the report designer and create and format the report the way I want it.  I save the environment when I save the report.

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