Jump to content
We've recently updated our Privacy Statement, available here ×

SubReport with columns issue


rafaelbarrosneto

Recommended Posts

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    |

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

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...