Report help needed

Support Developer
1

I am currently creating a report. The following is a screenshot of a part of that report

Screenshot%20from%202019-08-28%2015-41-01
Screenshot from 2019-08-28 15-41-01.png1159×353 24.8 KB

When I run the server and print the report, it gives the data like this

final%20printed%20report
final printed report.png1233×450 33.9 KB

I do not want extra blanks rows to appear but I want to keep the table format as it is(I do not want to place deductions below pay and allowances). I tried defining two lists as the follows:

@property
def pay_and_allowances(self):
    allowances_lines = []
    if self.lines:
        for line in self.lines:
            if line.category.code in ['BASIC', 'ALW']:
                allowances_lines.append(line)
    return allowances_lines

and

@property
def deductions(self):
    deductions_lines = []
    if self.lines:
        for line in self.lines:
            if line.category.code in ['DED']:
                deductions_lines.append(line)
    return deductions_lines

and applying them side by side in two separate for loops. But on trying to print the report, it gives me error about matching tags.

Please tell me whether there is a way to make this possible.

2

That’s probably because you did not close correctly som for loop or other tags.

I can not see any other error in the code you posted. Reports support the usage of python properties.

3

I was trying to use something like this

i_was_trying_to_use_something_like_this
i_was_trying_to_use_something_like_this.png1129×296 20.1 KB

4

You can not have two loops mixed inside the same table.
You must use two tables or make a unique loop on both list using zip.

5

But using zip would truncate some values required in the table. Will try using zip_longest if possible.