rafaelbarrosneto Posted February 11, 2019 Share Posted February 11, 2019 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: $5200payment 02 $5200payment 03: $200payment 04: $200payment 05: $200I 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 More sharing options...
rafaelbarrosneto Posted February 13, 2019 Author Share Posted February 13, 2019 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? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now