topic Re: 2 loop in smartform in Application Development and Automation Discussions

2 loop in smartform

maria_merino — Wed, 08 Jun 2016 09:02:35 GMT

Hi experts,

I have the following issue: I have to print 2 tables in a smartform (see image attached please, table "devengos" and "descuentos").

In the main program I have 2 internal table with the required information. If the entries of both records aren't less than X (I think it's 19 for the first table and 12 for the other) it works fine. The problem is when there are more entries in any of the tables. In that case I need to print those entries in another page.

At first, I didn't use the MAIN window but I think it's necessary. So, I create 2 different loops in the MAIN window controlling the number of entries. But when it goes to the second page it doesn't print the data correctly. Entries from table2 are printed in "Devengos" and entries from table1 are not printed.

Any suggestion please ? How can I do that ? Should I use only an internal table with all the data mixed?

Thanks in advance,

María

Re: 2 loop in smartform

Former Member — Wed, 08 Jun 2016 09:43:26 GMT

Hi Maria,

Are you using a table or template to print table entries?

Thanks,

Sowbhagya

Re: 2 loop in smartform

maria_merino — Wed, 08 Jun 2016 09:54:40 GMT

When I was doing it without MAIN, I did it with templates. But now within the MAIN window I'm doing it with tables.

Re: 2 loop in smartform

Former Member — Wed, 08 Jun 2016 09:59:58 GMT

Hi Maria,

By seeing your requirement, i think the two tables are independent. They are not Header and Item tables and hence dont create any separate loops.

Insert two tables in the main window of your smartform. Since the tables are in main window the page extension will happen automatically.

Thanks and Regards,

Vinay Mutt

Re: 2 loop in smartform

maria_merino — Wed, 08 Jun 2016 10:04:23 GMT

Yes, both tables are independent. That's what I did: 2 tables in the main window controlling that I have to print only the first 18 rows for the first one and 12 for the second one. But it doesn't work.

Thanks,

María

Re: 2 loop in smartform

Former Member — Wed, 08 Jun 2016 10:06:28 GMT

Hi Maria ,

First page - Use main-window and create 2 tables - one is for devengos" and another one is for "descuentos" Based on the records it will display means if your first table having 20 entries it will display first and after completing second table will display try it if you have any issues revert.

Thanks,

Osman.

Re: 2 loop in smartform

Former Member — Wed, 08 Jun 2016 10:07:32 GMT

Hi Maria,

Can you please tell us what is the code present in the smartform now. Are you using loops. or is it only tables inside main window. Please paste the screen shot.

Thanks and Regards,

Vinay Mutt

Re: 2 loop in smartform

former_member196331 — Wed, 08 Jun 2016 10:13:14 GMT

May i know What is But it doesn't work.

Is it displaying more than 18 and 12. I hope you have to control it. In driver program you have to Get only 18 and 12 If they are having more than, desired records count.

Re: 2 loop in smartform

maria_merino — Wed, 08 Jun 2016 10:15:21 GMT

This is how my smartform looks like.

Re: 2 loop in smartform

maria_merino — Wed, 08 Jun 2016 10:17:38 GMT

What I mean is this:

Table1 has 20 records.

Table2 has 15 records.

How should print the smartform:

Page 1: table 1 with 18 records. Table 2 with 12 records.

Page 2: table 1 with 2 records. Table 2 with 3 records.

What it does at this moment:

Page 1: table 1 with 18 records. Table 2 with 12 records.

Page 2: table 2 with 3 records in the place that should appear table 1.

Re: 2 loop in smartform

Former Member — Wed, 08 Jun 2016 10:26:03 GMT

Hi Maria,

Now this is clear. But this is not in sink with the screen shot of the required receipt which you have attached. Could you please double confirm that you are trying to achieve to split tables across pages.

Regards,

Vinay Mutt

Re: 2 loop in smartform

maria_merino — Wed, 08 Jun 2016 10:33:56 GMT

Yes, I need to split the tables (in case it is necessary) and print them in several pages, but in the space given to each tables, devengos and descuentos.

Re: 2 loop in smartform

Former Member — Wed, 08 Jun 2016 10:38:00 GMT

Maria,

I think you can achieve this by using templates in the main windows of page 1 and page2.

In Page 1 create a template with 18 records and map these to first 18 rows of table 1.

In page 1 create another template with 12 records and map these to first 12 rows of table 2.

In Page 2 create a template with 2 records and map these to last 2 rows of table 1.

In page 2 create another template with 3 records and map these to last 3 rows of table 2.

Thanks,

Sowbhagya

Re: 2 loop in smartform

maria_merino — Wed, 08 Jun 2016 10:42:57 GMT

In Page 2 (or 3, or 4, number of pages depends of entries in both tables) there can be also 18 records for the first table and 12 for the second one.

Re: 2 loop in smartform

Former Member — Wed, 08 Jun 2016 11:06:18 GMT

Hi Maria,

Please check the saptechnical link below

http://saptechnical.com/Tutorials/Smartforms/Command/Index.htm

This has the solution for your issue.

Thanks,

Sowbhagya

Re: 2 loop in smartform

maria_merino — Wed, 08 Jun 2016 11:58:53 GMT

Thanks, I've already check this tutorial, with only one table it works fine, but the problem is when i'm working with 2 tables.

Re: 2 loop in smartform

former_member210963 — Sat, 11 Jun 2016 07:29:16 GMT

Hi Maria,

I am not sure....

But you can use my idea if it is help full,

We know the two table entries as fix per page(18 and 12).

So we can use the describe table lines in initialization and the empty lines to the respected tables which are less for the page fix entries(18 and 12).

Ex1:

1st table has 20 entries(2 pages) and 2nd table has 10 entries.

To continue the 2nd table we have to add 3 empty entries to 2nd table.

then the entries will be 13 entries(2pages)

Ex2:

1st table has 10 entries and 2nd table has 30 entries(3 pages).

To continue the next pages we have to 27 entries add 1st table.

then the entries will be 37 entries(3pages)

Finally you can use your own logic depends upon the above idea.

Thanks,

Sivanadh.

Re: 2 loop in smartform

maria_merino — Mon, 13 Jun 2016 09:12:46 GMT

i Sivanadh,

That's exactly what I did, i'm controling the change of page using the maximum lines per table and per page. It seems it woks.

But now I have another problem... After printing both tables I need to print an extra page with some fix data. When I have only one page the last page is printed correctly. When I have more than one page I'm not able to print it.

what I did is:

Page 1:

I have 2 windows, positions (1st table) and discounts (2nd table) where I do the loop to the tables.

Whenever I print the entries required for each table, I delete these rows.

At the end of this page 1 have a MAIN window with an alternative:

- IF positions[] is not initial or discounts[] is not initial -> goto page NEXT (similar to page 1)

- ELSE -> goto page LAST.

In page LAST I have a NON-MAIN window where I print the data I need.

Any idea of what I'm doing wrong ?

Thanks !!!

María

Re: 2 loop in smartform

Former Member — Mon, 13 Jun 2016 10:56:56 GMT

Hi Maria,

Tried reversing the condition?

IF positions[] is initial or discounts[] is initial -> goto page LAST

- ELSE -> goto page NEXT (similar to page 1).

Thanks,

Sowbhagya

Re: 2 loop in smartform

maria_merino — Mon, 13 Jun 2016 11:08:20 GMT

Thanks Sowbhagya but it doesn't work..