Report with two data levels

MahubeMahube South Africa
edited 6:37AM in FastReport VCL 5
Good day Fast-Reporters,

I have been working on this report for a while, I had followed the example on this examples

https://www.fast-report.com/documentation/UserMan/index.html?report_with_two_data_levels_(master_detail).htm

with no success. Can someone help me.

I have 2 tables 1-Invoice Detail and Hospital Detail, their linked by debtor_no. See attached
results. I would like to see similar results as an example above

Thanks
Mahube

Comments

  • gpigpi
    edited 6:37AM
    You should set master-detail link between two datasets on the Delphi's level. This is standart Delphi (not FR) task
  • MahubeMahube South Africa
    edited 6:37AM
    gpi wrote: »
    You should set master-detail link between two datasets on the Delphi's level. This is standart Delphi (not FR) task

    Thank you, GPI.

    Can you also help me with Error MasterData1: Could not convert variant of type (String) into type (Integer).
    Am using expression to filter my report.

    How can I resolve this?
  • gpigpi
    edited 6:37AM
    Convert string to integer. Use StrToInt function for example

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.