Skip to Content
0
Former Member
Oct 30, 2009 at 11:22 AM

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

81 Views

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