Home RAP
New Blog Posts: Merging Reports - Part 1 and Part 2

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'])
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

Comments

  • 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
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • 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
    now.

    Thanks.

    Ian
This discussion has been closed.