Newbie Q on Master/Detail reports

GeorgeGeorge
edited 5:52PM 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

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

    This problem is not related with FastReport.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024