Crystal report: set range parameter and show a doc per page

[Former Member]

Greeting to all,

This might be a simple question to you, but I just cannot get my head around.

I have created a tabular report by SQL-scripts, on which I need to let end-users set doc range (from .. to) for ouput, and show a document (in range) per page. -- it's like a customer statement style report.

So an simple example ...

SELECT T0.[DocNum], T0.[ItemCode], T1.[ItemCode], T1.[PlannedQty]

FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.[DocNum] >[%0] AND T0.[DocNum] <[%1]

Say, I want to get a report for Doc 1-50, so I should get 50 pages ...

How can i do this in Crystal reports? I am guessing that is something to do with parameters linking with page number?

Thank you very much in advance.

Yang

[Former Member · Accepted solution]

You can create a group in Crystal for each document number & in the Group set it to start a new page after each one

[Former Member · Accepted solution]

Brilliant, simple and easy. That's all I want.

Thank you