Create new page in report based off of a value
Posted: Thu Jan 07, 2016 10:42 pm
Below is my simple sql
basically I want a new page to be created every time the transactionNumber changes. How can I do that?
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, daybasically I want a new page to be created every time the transactionNumber changes. How can I do that?