SubReport with columns issue

0

I have a payments detais like this:

Item 01: total price $1000 divided in 02 payments ($5000 each)

Item 02: total price $1000 divided in 05 paymens ($200 each)

So, in subreport payments i have 

payment 01: $5200

payment 02 $5200

payment 03: $200

payment 04: $200

payment 05: $200

I figure that the way i've to do this is add to group my query by (date of payment for example) so the original query {{1,$5000,01/01/19},{2,$5000,02/01/19},{1,$200,01/01/19},{2,$200,02/01/19},{3,$200,03/01/19},{4,$200,04/01/19},{5,$200,05/01/19}} will be displayed as i wanted, in the group footer. The isue is: I want to display the payments group results in 3 columns not in 1.

What I have

+------+-----------+-------------+ +------+-----------+-------------+ +------+-----------+-------------+

|  #         |   value    | date              |  |  #         |   value    | date             |  |  #         |   value    | date              |  

+------+-----------+-------------+ +------+-----------+-------------+ +------+-----------+-------------+     <== this is in Column header

|  01      |   $5200    | 01/01/19   |                                                                                                          <== this is in Group1 footer

|  02      |   $5200    | 02/01/19   |

|  03      |     $200    | 03/01/19   |

|  04      |     $200    | 04/01/19   |

|  05      |     $200    | 05/01/19   |

+------+-----------+-------------+

What i want: 

+------+-----------+-------------+ +------+-----------+-------------+ +------+-----------+-------------+

|  #         |   value    | date              |  |  #         |   value    | date             |  |  #         |   value    | date              |  

+------+-----------+-------------+ +------+-----------+-------------+ +------+-----------+-------------+

|  01       |   $5200  | 01/01/19       |  |  02       |  $5200    |  02/01/19    |  |  03      |    $200    | 03/01/19       |

|  04      |     $200  | 04/01/19       |  |  05       |     $200    | 05/01/19    |

+------+-----------+-------------+ +------+-----------+-------------+ +------+-----------+-------------+

 

rafaelbarrosneto's picture
Joined: Feb 11 2019 - 6:58am
Last seen: 1 month 3 weeks ago

I'd figured out how to get the columns (set property [Start new column = true]) but it's display the first row with the 3 items but the add a page break. Anyone know how to remove the page break?

rafaelbarrosneto - 2 months 4 days ago

0 Answers:

No answers yet
Feedback