View Article

Introduction

When you create a label report, it requires configuration to display data to the user the way you want it to.

This example configures an Employee Details report. It starts with an existing created report and applies the following updates:

• Add an image to the header.
• Add fields to the header.
• Add a heading to the header.

When configured, the report will display an image for each employee and, to the right of the image, the employee's identifying information.

Prerequisites

• The label report file must already exist.
• The path of the image to be used in label report must be configured in the database attribute.

Detailed Steps

Step 1. Open the report file.

Open the Label report file rptEmployeeDetails to do further configurations.

Step 2. Add a layout to the header.

This example uses layout controls to configure the report.

Step 3. Enter the layout details, then click OK.

This example's layout will contain one row and two columns.

Step 4. Add a layout to the column.

This example's layout will contain another layout in the right column to display the employee details.

Step 5. Enter the layout details, then click OK.

This example's layout will contain five rows and one column.

Step 6. Add an image to the column.

This example displays an employee image in the left column.

Step 7. Enter the Query Field, then click the Custom Attribute icon.

This example uses employee_photopath and maps the image control to the image you want it to display.

Step 8. Set the height and width.

Enter the desired attributes such as height and width, then click OK.

Step 9. Click the Style icon.

Step 10. Configure the style.

Enter the desired properties, then click the Apply button.

Step 11. Add printable labels to the column's rows.

This example displays employee details in the right column. Add a printable label to each row. For which, drag and drop the Printable Label control from the View section of the Toolbox in the first row of the second column of report layout.

Step 12. Configure the printable labels.

Select each label and enter the Query Field property. From top to bottom, this example's labels are employee_id, employee_name, employee_address, employee_phone, and employee_hire_date.

Step 13. Add a heading to the header.

This example uses the Heading5 HTML control.

Step 14. Configure the heading.

The heading gets added. Now, select the Report Header and open the Style Editor tab. Alternatively, from the Properties, you can click the Edit Control Style icon to open the Style Editor tab.

Select the desired Style properties from the drop-down list such as font-weight, text-align. Click the Apply Style button.

Step 15. Save the report.

Click the Save icon to save the report file.

Then, run the Preview. You can open the Reports screen and view your report right away. It should look something like this. Click the View Report button to view the report.

When you have previewed your report, it should look something like this. The configured header displays its heading, an image for each employee, and employee information. The footer is not configured and does not display. You can now either download the report or print it.

What are the improvements over S3 Version 6?

Previously, a report schema .xsd and layout .rdlc was required and it had to be configured before creating a Report. Now, with Xelence, the process to configure the label report is made simple with minimum configurations and various types of reports are available based on the business requirements.

Related Articles

Create a Label Report

This post is part of the Reports topic. Click here to open Reports Overview

This post is also part of Controls and Buttons topic. Click here to open Forms Toolbox Controls

#Xelence
#Reports

#ControlsandButtons