PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Can I print part of the table control (inside table break) in the report?
Can I print part of the table control (inside table break) in the report?
Iniciado por guest, 17,ago. 2015 05:08 - 5 respuestas
Publicado el 17,agosto 2015 - 05:08
I have a table control, and it has two table with breaks.
The breaker 1 is employee number. The breaker 2 is week.
From windev website, I know I can print whole table control to report. But I only need one employee's record.
Can I print only one employee's record in the report through print table control option?
Publicado el 17,agosto 2015 - 09:05
Hey Bruce

You can print only selected rows maybe that is a solution?
Publicado el 17,agosto 2015 - 15:54
Well, I want to make a better user interface.
While I click "print" button, it will pop up a window, let user to choose "date" and employeeNo. After user submit his choice, will windev go to the table and look for part of the record? employeeNo is a break.
Publicado el 17,agosto 2015 - 16:45
Hi,

This is an other way to achief this
define a report based on a querie. Make the report with an internal querie and define paramaters:

Param1 = date
Parma2 = employee

The querie wil render the results an the report will display the results that is printeble.


regards
Allard
Publicado el 17,agosto 2015 - 17:47
Hi Allard,

Thank you for your reply.
Are you saying that make a report "from a data file or from an existing query"?

I programmed (reformat and did calculation) the whole table control. And finally get the result. If I did a query, then I have to do the calculation and reformat everything in the report again.
The second break is week, not date. Each row in my database is date, not week.
Publicado el 18,agosto 2015 - 19:38
Hi,
DateToDayInAlpha () returns the week so that is easy.

I would make a querie in the report. It is good praktise to use queries in a table, in a report etc and use queries with hexecute querie only when you need a querie in coding.
( because then you can be sure you donnot use one querie several times , witch is not good practice :)

This way you can sent paramters to the report and run the querie.

You can make a report with breaks . That is even easier then in a table. Just walk throughthe report wizzard and a report with breaks is easily done.( takes a view minutes)

regards
Allard