Skip to Content
Former Member
Feb 11, 2011 at 03:42 PM

Query Manager


Is it possible to create page breaks for reports using Query Manager? I would like to create a sales report that prints a separate page for each sales rep. Here is my SQL statement:

SELECT T2.SlpName as 'Sales Rep' , t1.DocDate as 'Order Date', T1.DocNum as 'Order No', t1.NumAtCard as 'Customer PO#', t1.CardName as 'Customer', t1.DocTotal as 'Order Total', t1.DocDueDate as 'Due Date' from ORDR T1

INNER JOIN OSLP T2 ON T1.SlpCode = T2.SlpCode

WHERE T1.[DocDate] >=[%1] AND T1.[DocDate] <=[%2]

Thank you.