The report output data begins populating in cell C39 instead of C7. (YARG -Cuba 7.2)

vojtech.bartek2 · November 13, 2024, 4:23pm

Hello,

I need your help with the following issue:

The report output data begins populating in cell C39 instead of C7.

Attached are the following:

The report structure (image 1)

Image11897×500 179 KB
The template related to the report structure and the formulas named Manager refers to the associated cells (image 2).

Image21907×1006 375 KB
The report output (image 3)

THANK YOU FOR YOUR HELP!

fedorov · November 27, 2024, 7:21am

Hello, Vojtech.

Unfortunately, based on the provided information, it’s hard to determine the cause of the issue with data populating incorrectly in the report. Additional details about the configured report bands are required.

Could you please create and export a minimal example of a report where the issue with incorrect data population can be reproduced?

Regards,
Sergey.

vojtech.bartek2 · December 20, 2024, 3:16pm

This issue has now been resolved. Thank you!

SOLUTION: To fully fix the spreadsheet layout issue, here’s what was done:

The named ranges in the template were updated, just like in the screenshots you sent.
The Report Bands settings were adjusted as follows:

MampDetail (parent band): Orientation set to Horizontal
MampDetailHeader : Orientation set to Vertical
MampDetailData : Orientation set to Vertical