This topic is locked

master-detail fields in Reports

9/28/2007 3:10:10 PM
PHPRunner General questions
G
Gary.Beam author

Is it possible to display a Detail list for a master Field within a Report? The master-detail settings that are available for `Tables` seem to be disabled for `Reports`.

J
Jane 10/2/2007

Gary,
unfortunately it isn't possible to use master-detail relationships for the reports and charts in the PHPRunner.
As workaround you can edit report page on the Visual Editor tab:

  • switch to HTML mode,
  • find this code:
    <TD class=data>{$row.1FieldName_value}</TD>

where FieldName is your actual field name where foreign key is stored,

  • and replace it with this one:
    <TD class=data><A href="DetailsTable_list.php?a=search&amp;value=1&amp;SearchFor={$row.1FieldName_value}&amp;SearchOption=Equals&amp;SearchField=FieldName">{$row.1FieldName_value}</A></TD>