SmartForms displaying information in windows.

[Former Member]

Hello all,

I am creating a smartform for a certified payroll. My question is how can I display multiple  employees on the same page? For example I am importing 5 tables: table 1 is a list of all the employees and their employee number, 2 table is all the hours for each employee, 3 table is all the taxes for each employee,  table withholdings for each employee and so on... I have different windows that I want each table to go in and repeat that for each employee.

How can this be done? Any help would be great.

[Former Member]

Dear Patrick,

            Use loop concept of smartforms

[rosenberg_eitan]

Hi,

You want a new page for each employee ?

Regards.

[Former Member]

Hi Eitan,

No I want to have at least 3 on the first page and 4 on the following pages. Then on the final page want the total hours of all employees. another note each time the report is executed there may be a different number of employees depending on the week and job number. An hint on how to accomplish this or what direction i need to go would help.

thanks,

Patrick

[rosenberg_eitan]

Hi,

Do not use windows.

Just put the tables under the main window one after the other. This way the tables will expand based on the number of lines in each table.

Regards.

[Former Member]

Maybe I am not fulling explain well enough what I would like to see on the page. Below is and example of what I  want the out put to look like. Notice the window layouts are the same, as long as there is an employee it will keep duplicating. In the picture there are 3 employees with information. If there are only 4 employees display,  and if 3 than display 3 and so on. This cannot be just one window in a loop can it? There has to be at least 5 windows to display information of 1 employee. Can someone help?

[Former Member]

1. One loop is enough(That should be header table like employee table), basing on the table1, u can pull the data from remaining table and push it to Table to print.

2. create a table node and design it in smart form in such way that as required in output(on first page)

3. For each table create global work area and define same variable in the table layout in cells.

4. For each record from header table(table1), pull the data from tab2,tab3...5 and put in their respective global work areas .

[rosenberg_eitan]

Hi,

The pictures are somewhat blurred ,

But it seems to me a table within a table (deep) .

The top level is one row per employee and under it the rest of the data.

In this post I demonstrate the idea.

Note that there is no code in the form.

Regards.

[Jelena]

I believe what you are asking is actually a template. Unlike table that just "keeps on giving" (as long as it's in MAIN window), template has the fixed layout. That's what I see in your screenshot.

Also - before you ask - we can't rotate text in Smartforms, as on your screenshot.

[rosenberg_eitan]

Hi Jelena,

Do you mean something like that ?

If we use in the loop a table that have a deep structure we can use tables and template .

Regards.

[Jelena]

Eitan, based on limited information OP provided I don't even see a need for a table, just template in a loop (or are you saying we must have template in a table?). The main point - what he was calling "windows" are called "templates" in Smartforms.

[Former Member]

Hi all thanks so much for all your help. To get the output I wanted I had needed to use a template in a loop. I don't know why this was hard for me to understand in the beginning but I me receiving the correct output now.  I initially wanted a table inside of a template but this is not possible.

thanks again for all the help.

[rosenberg_eitan]

Hi Jelena ,

You are right of course.

You have a better eyesight than me (womens are superior race ).

I was just showing that we have the option to use both (tables and/or template) in a loop .

Regards.