Concatenate fields and text objects in crystal reports

Question

Hello community, good.

What I want to do is the following:

A document type employment contract, where it has static information (not variable), in addition to information that must correspond to the one provided by the database, such as fields: employee name, salary, type of contract, etc. .

All this information about the fields, I get them from a Stored Procedure as a data source of the Report without singun, problem, now, what I want is how to concatenate those static data with the data that the database fields have. Contract example:

THROUGH THIS EMPLOYMENT CONTRACT, WHICH IS MADE UNDER A PRIVATE SIGNATURE, IN THE NAME OF: 'DatosCampoNombre', FIGURING AS THE PERSON HIRED. THIS HAS BEEN HIRED AS: 'DatosCampoCargo', WITH A GROSS SALARY OF: 'DatosCampoSalario' ....

As we can see, the uppercase text is the static information, and the ones in single quotes are those that correspond to the values ​​that the fields bring in the stored procedure.

I use Visual Studio 2010, Windows Forms in C #, with SQL Server 18 Database.

I appreciate any guidance in advance.

Greetings.

Answer 1

I could do it in the following way: I created an unlinked string field (which is placed in formula fields), and in the formula of this field I put: "& {sp_EmpleadoId; 1.Empleado} &", of legal age , bearer of the identity card "& {sp_Empleado_Cedula} &", was working as "& {sp_EmpleadoBuscarById; 1.Oficio} &", from November 1, 2019, to April 13, 2021. "

Now I ask, is there a way to make the fields coming from the database bold?

Greetings