Using two dastasources in Flex Report

Posted by: haim on 5 April 2021, 7:25 pm EST

  • Posted 5 April 2021, 7:25 pm EST

    I have a main flexreport in a winform. The main report has two data sources from two different tables that have a one to one relationship. I would like to display fields from the two datasets in the group header. The data from the main dataset is displayed but the data from the second dataset is not displayed. I tried to add a filter to the dataset linking the two tables but it didn't help.
    Is there a way I can do this with the two datasets or do I need to combine them into one table?
  • Replied 6 April 2021, 11:10 pm EST

    Hi,

    The data of a C1FlexReport is shown using the Main data source. Other data sources are used as Data Source for Parameters or Chart Field. To show related data from different sources, Subreport Field is used. You can create another report using the related table and then use that report as a subreport in the main report using the SubReport Field and then link the subreport using the SubReportFilter property of the SubReport Field.

    Subreport Field: https://www.grapecity.com/componentone/docs/win/online-flexreport/SubreportField.html

    Please refer to the sample report attached.

    Regards.
    Avnish
    subReport.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels