Create new page in report based off of a value

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

Post Reply
withnoe
New MMEX User
Posts: 1
Joined: Mon Jul 13, 2015 6:16 pm
Are you a spam bot?: No

Create new page in report based off of a value

Post by withnoe »

Below is my simple sql

Code: Select all

select cast (month as int)||'/'||cast (day as int) ||'/'|| cast (year as int) Date,  transactionNumber, 
'$'||printf("%.2f", amount) as Amount
from alldata
where substr (date,1,4) = '2015'
and (transactionNumber like '1%'
or transactionNumber like '2%')
order by transactionNumber, year, month, day

basically I want a new page to be created every time the transactionNumber changes.  How can I do that?
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Create new page in report based off of a value

Post by Nikolay »

The solution is too complex...
I think somthing like this:
http://www.hongkiat.com/blog/css3-page-break/
Post Reply