Create new page in report based off of a value

Page 1 of 1
2 posts
Create new page in report based off of a value

withnoe
New MMEX User

Posts: 2
Joined: Mon Jul 13, 2015 12:16 pm
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?
Re: Create new page in report based off of a value

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
The solution is too complex...
I think somthing like this:
http://www.hongkiat.com/blog/css3-page-break/
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 15 guests