Print the sheet by Action

You can print your target sheet by using Action.
As the example, there is the application which was created in Dynamically Add Buttons.The button in the application will be changed from 'Details' button to 'Print' button.
../../../../_images/img_01.en47.png

This part will show the procedure to print the sample sheet with input data.

Create the sheet to print

  1. Create the sample sheet to be printed by Print Action.
../../../../_images/img_02.en45.png

Set 'Print' button depending on the data count.

Check Dynamically Add Buttons > Set 'Details' button along with data count for getting the data and creating the button dynamically.

Set the action for 'Print' button

Create the action for 'Print' button which was created in Set 'Print' button depending on the data count.
In this part, it will show to get 1 record data with the ID as the search condition, then to print the contents on the print sheet.
  1. Get 1 record with B column (ID) as the condition on the selected row, then set the data into the cell.
../../../../_images/img_03.en35.png

See also

Regarding the way to get the selected row,Check Get Current Row Column.

  1. This shows to connect to the acquired value, then to set the value on the print sheet.
../../../../_images/img_04.en34.png

See also

See Pass Data to Other Sheet for the action "Set values in sheet cells" action.

  1. This shows how to set 'Print Sheet' from 'Sheet Operation' tab.
../../../../_images/img_05.en30.png
  1. Click 'Select Sheet' button.
../../../../_images/img_06.en23.png

Hint

You can also select the print sheet dynamically by designate the print sheet as the formula (in the cell).

../../../../_images/img_10.en13.png

Note the own sheet will be printed in case there is no designate sheet.

  1. Select the print sheet on 'Sheet Selection' dialog, then click 'OK' button.
../../../../_images/img_07.en22.png

Tip

The sheet to select is regulated in the current application or sub application.

  1. To print without displaying 'Print Preview' dialog, uncheck 'Show print Preview'.
../../../../_images/img_08.en19.png

Tip

  • The initial value of the 'Show print preview' check button is valid, and the 'Print Preview' dialog is displayed at the time of printing, you can Specify Orientation Size Of Printing at that time.
  • If you uncheck the 'Show print preview' checkbox, make Specify Orientation Size Of Printing on the sheet to be printed beforehand. At this time, the output destination printer will be the last printer printed.
  1. Click 'OK' button.

Tip

At the execution, the print sheet is previewed, and then the sheet is printed.

../../../../_images/img_09.en15.png

Attention

  • When printing a sheet with many cells, the printing process takes time regardless of the number of pages to be printed. In addition, printing may not be possible due to insufficient memory.
  • When specifying a virtual printer such as Microsoft Print to PDF and saving to a file, if the number of pages to be printed is large, saving takes time.

Related keywords

form, report, printer, print