Create a group within a table that repeats as needed?

Create a group within a table that repeats as needed?

Posted by: mcclard on 10 May 2018, 12:42 pm EST

• 

  mcclard

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 May 2018, 12:42 pm EST - Updated 30 September 2022, 6:18 pm EST

  Does anyone know how to create a table that contains a single group which can be repeated as needed, depending on if there is data to fill those groups or not?

  I have attached a mockup of what I’m talking about. There is a single table, and within the table is a group that has a textbox for a label, then a table with header, details and footer. Once that group is filled, another group is started, formatted the same way but from a different dataset. And then another group, then another.

  Is there a way for me to make a single group in AR, and have that group be duplicated as needed?

  Thanks for your help!
  
  

  

  1440×1595 515 KB

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 11 May 2018, 1:58 am EST

  I’m a little unclear about your requirement. Do you wish to duplicate the group DC throughout the page, instead of having different groups - FloatSub, Motors, etc? Is that your requirement?
  
  Can you attach another screen shot which shows your requirement?

• 

  mcclard

  • Post Options:
  • Link
    Copy

  Posted 14 May 2018, 11:07 am EST

  I would like to duplicate the format of the group, but have different labels. The requirement that I’m going for is depicted in the screenshot. The screenshot shows a group that has “DC” along with a table and footer, then another group that is labeled as “Float Sub” with its own table, then one for motors, and then one for MWD.

• 

  mcclard

  • Post Options:
  • Link
    Copy

  Posted 14 May 2018, 12:44 pm EST - Updated 30 September 2022, 6:18 pm EST

  Another example. In this screenshot, there is only data for Motors and MWDs, so the other groups are not generated, and the relevant data is displayed.

  

  1440×1595 336 KB

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 15 May 2018, 4:41 am EST

  To achieve your requirement, you can use an RDL report with SubReport. In the main report, you can drop a Table with grouping applied on it and in the Table’s Detail row, place a SubReport control. Now in the sub-report, you can place a Table with a parameter in the DataSet and the parameter’s value comes from the main report. I have attached the reports for your reference. Kindly change the datasource path in both the reports to point to the NWind.mdb file.

  Orders_GroupedRDL.zip

  For information on how to create subreport with parameters, kindly take a look at the following documentation link - http://help.grapecity.com/activereports/webhelp/AR12/webframe.html#SubreportinRDLReport.html