Fastreport VCL DB Fields Concat

int3g3r · November 2020

.Net Solution:

I need the same solution for Delphi/VCL.

How can i concat two DB fields ?

1) [<frxDBPool."NAME_VATER">]/[<frxDBPool."RASSE_VATER">]

2) [<frxDBPool."NAME_VATER">+'/'+<frxDBPool."RASSE_VATER">]

3) Is it necessary to set the Dataset ?

I'm getting in both cases exceptions or the field won't show up on the generated Report.

Using: Fastreport 6.7, RAD Studio 10.3

Regards,

Int3g3r

gpi · November 2020

[<frxDBPool."NAMEVATER">+'/'+<frxDBPool."RASSEVATER">] should works if you concat string fields

Try [VarToStr(<frxDBPool."NAMEVATER">)+'/'+VarToStr(<frxDBPool."RASSEVATER">)]

int3g3r · November 2020

Hello gpi,

I tested both solutions that you have suggested. Both don't work.

Everything is fine in the designer preview.

As soon i generate the PDF-report in my application then i see only "/" on my report.

The Datafields are not empty. Follow code shows how i generate the report.

dmMain.frxPDFExport.Background := True;

dmMain.frxPDFExport.ShowProgress := False;

dmMain.frxPDFExport.ShowDialog := False;

dmMain.frxReport.LoadFromFile(ApplicationPath+'\GlobaleReport\Waagschein_A4.fr3');

WSFileName := 'WS_'+dmMain.qryReportPool.RecNo.ToString+'_'+dmMain.qryReportPoolOM_4_WERT.AsString+'.pdf';

dmMain.frxPDFExport.FileName := ApplicationPath+'\PDF\'+WSFileName;

dmMain.frxReport.PrepareReport;

dmMain.frxReport.Export(dmMain.frxPDFExport);

Any other suggestions ?

Thank you,

Regards Int3g3r

gpi · November 2020

Everything is fine in the designer preview.

So, FR works OK

As soon i generate the PDF-report in my application then i see only "/" on my report.

Replace

dmMain.frxReport.PrepareReport;

with

dmMain.frxReport.DesignReport;

dmMain.frxReport.ShowReport;

and look what is wrong in the your application

Comments