Data for each record?

rbuser

Hi Guys,

I have a Variable in a detail row called Customer_Name. The Detail row is
Mastered to the Invoice table. The Customer Table is releated to the Master by
Customer Number.

The Calc for the Variable is as follows....

if Trim(Customer['First Name'])='' then
Value := Trim(Customer['Cust Name'])
else
Value := Trim(Customer['First Name'])+' '+Trim(Customer['Cust Name']);

This works fine if I have a field from The Customer table in the detail band,
visible or not.

Question - How do I make it work without having to have a Customer field on
the Detail band?


Regards & TIA,

Ian

nardmoseley

Are you connecting at least one of the fields from the detail dataset to a
data-aware control or subreport? The report engine examines the data-aware
components to determine which datapipelines are being used in the report. If
the datapipeline is only used in a calculation, it is not kept in sync.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Nard Moseley (Digital Metaphors) wrote:


Hi Nard,

Had to add a non-visible field to the band as suggested and it all works OK
now.

Thanks.

Ian