Skip to Content
author's profile photo Former Member
Former Member

Problem with table output

Hello @all,

i have the following task,

i have 2 tables.

Table a contains materials with materialnumber as key. Table b contains processes for the materials.

For examble.

Table a :

matntr descr

1232 cellphone

3333 case

Table b:

processstep material

01 - ..... 1232

02 - ...... 1232

03- ....... 1232

01 - ..... 3333

02 - ...... 3333

03- ....... 3333

04- ....... 3333

05 - ...... 3333

06- ....... 3333

07- ....... 3333

In this example i have two materials with some processstep for each material.

In my output i want:

- a sitebreak when material change

- a header with materialinformation

- a main part where you can see processstep information

This might look like this:

site one:

header

site count 1 | material 1232 | descr cellphone

main part

processstep material processdesc.

01 - ..... 1232 ....

02 - ...... 1232 .....

site two:

header

site count 2 | material 1232 | descr cellphone

main part

processstep material processdesc.

03 - ..... 1232 ....

site three:

header

site count 1 | material 3333| descr case

main:

processstep material processdesc.

01 - ..... 3333 .......

02 - ...... 3333 ...........

03- ....... 3333 .............

04- ....... 3333 ..............

site four::

header

site count 2| material 3333| descr case

main:

processstep material processdesc.

05 - ..... 3333 .....

06 - ...... 3333 ......

07- ....... 3333 .....

This for example. Features are:

- site break when material change

- header change when material change

- sitecount start from 1 when when material change

How can i do this, i describe here.

Thanks for answers??? I dont know how i c an do this...:-(

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2010 at 11:23 AM

    Hi,

    My suggestion is ,

    First Sort the Table A Based on Material and Table B Based on Process Step ,Material in interface of the Form.

    Drag the Table A into Context.

    Drag the Table B into the Table A.

    Specify the Where condition based on Material.

    In the Layout drag Table A to Layout.

    You can see Table A and Table B inside TableA.

    Create Page Break on Table A on Material.

    Specify the Header as you Required .

    Thanks.

    UmaS.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.