Newbie Q on Master/Detail reports

edited 9:22PM in FastReport 4.0
New user, Delphi XE6, FR 4.0. I need to create a Master - Detail report (Member Directory report, basically each Family, followed by all family members). I have a SQL statement which joins the two tables for me as my data source. The report shows the data, just not correctly. What I see is one master row, and then everything else shows as detail rows. I should be seeing a Master row, 3-4 details, then the next Master. Instead, I am seeing a Master, then 300 details.... My report (in design mode) is showing a Report Title section, a MasterData section, (pointing at my single data source), a DetailData section (again, pointing at the same single data source) and a Page Footer. I used the Report Wizard to build my report. In short, the report is not recognizing that then my FAMILY_ID changes, it should display the report as a new master row. How do I tell it this?



George S

Comments

  • edited 9:22PM
    you should set 'MasterSource' property of detail dataset,
    and set link fields ('MasterFields' property).

    This problem is not related with FastReport.

Leave a Comment