Setting Master-Detail relationship from designer

Dave FDave F
edited 7:57PM in FastReport VCL 5
How do I set a master/detail relationship from inside the designer?

Comments

  • gpigpi
    edited 7:57PM
    Set Master property for detail query, use param names in the detail query as field names in the master dataset
  • Dave FDave F
    edited 7:57PM
    Where? On the Data tab? A short example would be great.
    gpi wrote: »
    Set Master property for detail query, use param names in the detail query as field names in the master dataset
  • Dave FDave F
    edited 7:57PM
    Actually, I'm trying to do this from the Code tab, with something like this:
    begin
    GetDataSet('Product').MasterSource:=GetDataSet('Typ_prod').DataSet;                                                                                                                                                                                                                                                                                      
end.

    But that doesn't work.
    gpi wrote: »
    Set Master property for detail query, use param names in the detail query as field names in the master dataset
  • gpigpi
    edited 7:57PM
    See a sample for FRDemo in the attach
  • Dave FDave F
    edited 7:57PM
    But we're using dBase tables with TTable, not ADO.
    gpi wrote: »
    See a sample for FRDemo in the attach
  • gpigpi
    edited 7:57PM
    See a sample for FRDemo in the attach (TfrxBDETable have same behavior like TfrxADOTable)
  • Dave FDave F
    edited 7:57PM
    This is the same demo, with TfrxADOTable.
    gpi wrote: »
    See a sample for FRDemo in the attach (TfrxBDETable have same behavior like TfrxADOTable)
  • gpigpi
    edited 7:57PM
    There are no any differences between TfrxADOTable and TfrxBDETable usage
  • Dave FDave F
    edited 7:57PM
    I'd like to be able to use the designer to establish a master-detail relationship between a pair of TfrxBDETables. A TfrxADOTable can easily be dropped on the TfrxDesigner.CodePanel by using the palette. But TfrxBDETable is not available to be dropped. Can I get CodePanel to take a TfrxBDETable via code?
    gpi wrote: »
    There are no any differences between TfrxADOTable and TfrxBDETable usage
  • Dave FDave F
    edited 7:57PM
    Sorry, I meant I'm trying to add a TfrxBDETable to the DataTree. Something like "myBDETable.Parent:=TfrxDesignerForm(frxReport1.Designer).DataTree.DataPn;".
    Dave F wrote: »
    I'd like to be able to use the designer to establish a master-detail relationship between a pair of TfrxBDETables. A TfrxADOTable can easily be dropped on the TfrxDesigner.CodePanel by using the palette. But TfrxBDETable is not available to be dropped. Can I get CodePanel to take a TfrxBDETable via code?
    show previous quotes
  • Dave FDave F
    edited 7:57PM
    Ok, this is a bit weird. Don't know why I didn't notice this before. The reason I've been asking about this is because I don't see the frxBDE components on the palette for me to add. Please check the attached screenshot named "NoBDE.png".

    Dave F wrote: »
    Sorry, I meant I'm trying to add a TfrxBDETable to the DataTree. Something like "myBDETable.Parent:=TfrxDesignerForm(frxReport1.Designer).DataTree.DataPn;".
    show previous quotes
  • gpigpi
    edited 7:57PM
    Add TfrxBDEComponents to your project

Leave a Comment


Home • FastReport VCL 5Comment As ...

© Vanilla Keystone Theme 2025