Section Report using Subreports with Columns

Section Report using Subreports with Columns

Posted by: icammann on 7 April 2022, 11:13 am EST

• 

  icammann

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 April 2022, 11:13 am EST

  I’m trying to make a single page section report that has some text boxes in the header, followed by 3 Sub Reports that have columns.

  I’m having trouble controlling the length of the columns in the Sub Reports. I can only get expected results when I put the Sub Report at the bottom of the page. The others seem to extend the details below the desired area, so they are cut off. The data eventually starts on the second column, with a large gap.

  I am aware I could do this by not using the Columns feature in the Sub Reports and instead producing additional columns in the data source, but then I’d have to update the query every time a layout change such as font or Sub Report height was made.

  Is it possible to control the maximum height of detail columns in a Sub Report?

  I’m using Active Reports 15 with Visual Studio. Example attached. The bottom Sub Report is working as desired, the other one is not. Thanks for the help!

  SubReportWithColumns.zip

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 8 April 2022, 5:15 am EST

  Hello,

  Thanks for the sample application. I am was to replicate this behavior on my end. The columns are rendered with respect to the available space on the page. When a report is used as a sub report all the page properties are ignored in the SubReport field(Report is not rendered as a paged document). When used in a sub report the multi column field is divides column with respect to the page height of the mainreport, the columns are cut off. The ColumnCount property is recommended to be used only for the main reports and not for reports used as a sub report.

  However, If you want to use the column count property in the sub report what you can do is to export the report with specified PaperHeight and use it in one of the available controls such as Image field, RichTextBox field. I have shared a sample application where I am exporting a sample report with column count equals to 3 to html and then viewing this exported html in the main report.

  Regards,

  AkshayColumnSectionReport.zip

• 

  icammann

  • Post Options:
  • Link
    Copy

  Posted 8 April 2022, 9:35 am EST

  Okay. Not what I hoped for, but thanks for your attention to this matter.