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

Selecting ranges of item #'s from a database

Selecting ranges of item #'s from a database

Selecting ranges of item #'s from a database

I am developing a report from an inventory database.  I need to place several different ranges of item #'s from within the inventory list at the top of the report and than the remainder after these items.  Is there a way I can do this?  Thanks for any help you can give me.

RE: Selecting ranges of item #'s from a database

Hey Buckwheat,

There are many ways to skin a cat - and this is also true of Crystal.

Try splitting the Group Header into several parts, and insert subreports in them, corresponding to the Inventory numbers you need to appear first.  A subreport is a report within a report - and several subreports can be inserted into a main report.  Therefore, you could create a main report with the "rest of the data", and insert the ranged data in another report and bring it in as a subreport.



RE: Selecting ranges of item #'s from a database

There are so many ways to do this, it is probably overwhelming.  As I hate using subreports (for performance, not religious reasons), you could also create a specified group, where a range of items could go in one group category, another defined range in another group category, and the remainder in the default Others group category.
I don't think there is a clear "best" way to do this - whatever you feel most comfortable with is probably the most significant factor.

Malcolm Wynden
I'm for sale at http://wynden.net

RE: Selecting ranges of item #'s from a database

Thanks for the help.  So far I have tried specified groups.  They work great except for one thing.  I am working with a database of inventory items on sales invoices and so there are a lot of duplication of Item #'s. It lists every item and doesn't group identical item #'s together.  Is there any way to group within the specified group?


RE: Selecting ranges of item #'s from a database

buckwheat: Sure - cheat!! If you create a formula field (@cheat) which merely has the original item # as its formula you can then select that within your specified group

David C. Monks
Accredited Crystal Decisions Enterprise Partner

RE: Selecting ranges of item #'s from a database

That sounds great. The only thing is, I am kind of a novice at formula writing.  How would I write a formula that I could choose as my specified group?


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