Printing a business card

This example shows how to create a PDF report to show multiple business cards on the same page.

Creating a PDF report

1. Create a new PDF report application using the following SQL statement:

SELECT
LastName||& quot; & quot;||FirstName AS Name,
Title,
HomePhone,
LOWER(LastName) ||& quot;.& quot;||LOWER(FirstName) AS Email,
Address,
CityID,
Country,
& quot; Postal Code: & quot;||PostalCode AS PostalCode
FROM
employees

2. On the PDF Report menu -> Settings, change the attributes:

AttributeValue
Amount of columns2
Columns Width90
Columns Height50

3. Still in the PDF Report Settings, open the Source and Background tab and in the Image attribute we will define the background image of the report.

    Note 1: To select an image, click the Send icon next to the field. If the desired image is not in the list, it is possible to load a new one.

    Note 2: The image used in this sample is the same as the one below. Save it to your computer and then upload it to ScriptCase (right click on the image and click on Save Image As).

4. Open the PDF Layout >> Interface item in the menu.

Now edit the cell position, font family, size, alignment and more. To see more options click on the icon.

5. Edit the cells according to the following information:

CellX PositionY PositionFont SizeFont Style
cell_Name42712Bold
cell_Title4308Italic
cell_HomePhone443
cell_Email440
cell_Address5340
cell_Country6343
cell_PostalCode5346
cell_CityID5343

Tutorials in the same category

Subquery XML export

1- Create an application of Grid 2- Go to the toolbar option on the side menu to enable ...

Send summary exported by email

In this tutorial we will be looking at how to export the summary and send it by email. Creat...

Send grid exported by email

1- Create an application of the type grid 2- Proceed to go in the side menu Export /...

Advanced Filter Tags (Chart)

In this tutorial we will see how an advanced filter can be applied within a Chart application ...

Comment this post