INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

2 - Equal Grouping Levels

2 - Equal Grouping Levels

(OP)
Hello,

I have a report that I am trying to recreate from a form created many years ago by an ERP company. The ERP company used a temporary subset of the original data that resides locally. I would like to share a similar report outside of the ERP system via our intranet and so I am connecting through odbc to our database to accomplish this. Mimicing the original format is not getting it done, I am stuck on a grouping issue.

I have 1 project that connects to an assy table with 3 records. each assy record has both mtl items and opr items. The problem is the material and operation tables are equal. If I group on Material first then I am presented with the 1st piece of material and directly beneath are all operations in the assy, followed by the 2nd piece of material and, again all the operations in the assy. and of course if I group on both I get 1 pc of material followed by 1 operation and so on. I would rather not use a subreport because these reports must be efficient for shop floor employees.

I have found some questions with similar requests on various sites but no solutions that seem to jump out at me.

Thanks for any advice!

Jill

RE: 2 - Equal Grouping Levels

You haven't explained what you want the result to look like. Maybe show a sample of how the desired report would look. What is its purpose?

-LB

RE: 2 - Equal Grouping Levels

(OP)
In previous post I attached a screen shot of the desired result.

RE: 2 - Equal Grouping Levels

If you have the ability to create a command, you could use a union statement to put both material and operation in the same field, as in:

select table1.assy, 'Material', table2.mtl, table2.qty
from table1 equal join table2 on table1.assy=table2.assy
where....

union

select table1.assy, 'Operation', table3.opr, table3.qty
from table1 equal join table3 on table1.assy=table3.assy
where...

Insert a group on {Command.Assy}, and then on {Command.Material} (the label, not the field).

The punctuation within the command depends on your database. Might take double quotes around the Material and Operaqtion lables, for example.

-LB


RE: 2 - Equal Grouping Levels

(OP)
Thanks LB I will give this a try

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!

Resources

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