topic Re: SmartForms displaying information in windows. in Application Development and Automation Discussions

SmartForms displaying information in windows.

Former Member — Fri, 18 Dec 2015 21:14:52 GMT

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.

Re: SmartForms displaying information in windows.

Former Member — Sat, 19 Dec 2015 12:26:19 GMT

Dear Patrick,

Use loop concept of smartforms

Re: SmartForms displaying information in windows.

rosenberg_eitan — Sat, 19 Dec 2015 15:53:41 GMT

Hi,

You want a new page for each employee ?

Regards.

Re: SmartForms displaying information in windows.

Former Member — Sun, 20 Dec 2015 21:27:25 GMT

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

Re: SmartForms displaying information in windows.

rosenberg_eitan — Mon, 21 Dec 2015 05:40:00 GMT

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.

Re: SmartForms displaying information in windows.

Former Member — Fri, 08 Jan 2016 21:32:57 GMT

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?

Re: SmartForms displaying information in windows.

Former Member — Fri, 08 Jan 2016 22:03:46 GMT

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 .

Re: SmartForms displaying information in windows.

rosenberg_eitan — Sat, 09 Jan 2016 15:57:09 GMT

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.

Re: SmartForms displaying information in windows.

Jelena_Perfiljeva — Tue, 12 Jan 2016 00:15:53 GMT

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.

Re: SmartForms displaying information in windows.

rosenberg_eitan — Tue, 12 Jan 2016 06:11:35 GMT

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.

Re: SmartForms displaying information in windows.

Jelena_Perfiljeva — Tue, 12 Jan 2016 19:36:05 GMT

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.

Re: SmartForms displaying information in windows.

Former Member — Tue, 12 Jan 2016 19:47:54 GMT

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.

Re: SmartForms displaying information in windows.

rosenberg_eitan — Wed, 13 Jan 2016 04:21:47 GMT

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.