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

Only first item in detail shows in report

Only first item in detail shows in report

Only first item in detail shows in report

I have a report for ordering gov't property that might have 12 items listed on a single order form (computers, monitors, etc). I can get the header info to print, but only one item from the 12 shows. I've tried detail a & b, header & detail, but nothing seems to work. Hopefully this explains it well, any suggestions welcome.

RE: Only first item in detail shows in report

Not certain I understand your particular problem, but there are several areas you could check (if you haven't already <grin!>). If the datasource is an ODBC table, you can use the Database┬ŽSQL selection to examine the SQL Crystal generates. (I've encountered a number of problems related to how Crystal generates a particular SQL statemehnt as opposed to how the remote server expects to see the SQL, particularly in the case of joins.) If the database connection is .dll driven (Access, dBase, etc.), you should examine the record selection critera *_and_* all formulae. Also, take another look at how you have inserted groups: that could cause unexpected exclusions. Lastly, check the formatting of each section for suppressions, etc., and look at the formats in the detail fields for the same thing(s). If that doesn't help, and if you can respond more specifically, I'll try to help. I've been using Crystal since v1.0, and while I don't consider myself to be an expert, I _have_ resolved a large number of problems in the course of Crystal's evolution <grin!!>.

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