Calculated Field change break the link to the DBText component

zoltan_andrusecz

Version: ReportBuilder 21.04

On the Report's Pipeline Data object if we have a Calculated field with a Field Alias like "Customer Name" and SQL Alias "Select_C_Custname_from_H"

The DBText component references this calc field by its Field Alias "Customer Name"

If we change the Function expression on the Calculated Field, it will change the Field's SQL Alias automatically to "Select_C_Address1_from_H"

This in turn breaks the DBText's link to the Field. The DBText component will be referencing field "SELECT_C_CustName_FROM_H" and not "Customer Name". This seems to be the old SQL field alias of the calc field.

This appears to be a bug. Can anyone else recreate this or is it just me?

Thank you,
Zoltan.

nardmoseley

Hi Zoltan,

The Designer displays the FieldAlias in places like the Edit toolbar drop down list and the Data tree. However, DBText.DataField property references FieldName. (For example, select a DBText and use Object Inspector to access DBText.DataField value.)

From the Data workspace side, when a Calc field changes, the DataPipeline Fields are re-created. The DBText.DataField references a FieldName that no longer exists.