Query Manager

[Former Member]

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.

[Former Member · Accepted solution]

Hi,

Welcome you post on the forum.

You need at least QPLD to make such report. Better by Crystal Report.

Thanks,

Gordon

[Former Member · Accepted solution]

Thank you for your reply.

[Former Member]

Hi..........

Try this.....

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]' And T2.SlpName='[%0]'

In Above Report just select the desired Sales Rep and get the print out which will give you the print only for one sales Rep....

Regards,

Rahul

[Former Member]

Yes, that will work but I don't want to have to run this for each sales rep. I would like to run it for all sales reps at once with a separate page for each. Is this possible?

Edited by: Jerry Hunt on Feb 11, 2011 5:24 PM