Home RAP

Data for each record?

edited January 2009 in RAP
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'])
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,



  • edited January 2009

    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

    Best regards,

    Nard Moseley
    Digital Metaphors
  • edited January 2009
    Nard Moseley (Digital Metaphors) wrote:

    Hi Nard,

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


This discussion has been closed.