Hai
I designed a report.In that report column are Items.The Item values I kew dynamically.The input to the report is item range. But my report prints a max of 12 Items info.Even if the user gives range more than 12 items ,it picks up the first 12 items and show the report. But what I need is if the user gives the input as 16 items.I want 12 items in one report. and remaining items are in the second report.Suppose if the user gives 120 items I need to call the same report 10 times with diff item ranges like 1-12 items in one report,13-24 items in second report and 25-36 items in the 3rdreport..
This I want to acheive through the code.First of all can I achieve this functionality.If so how.

Thanks in advance.
rgds,
Juvenile

Hi,

Well i think u can do it probably in the below mentioned way

1) select recrods from item master
2) keep a counter in select do
3) if counter < 12 then

make use of predefined variable
reportno

so depending upon the various conditions u change reportno. everytime and throw data on report using rprt_send()

alternatively u can explore functions related with spool also.

May be somebody can quote much better solution.


Regards

Learner

can anybody throw some light on this..

Elaborating learner's reply , u need to do following

1. increment counter by 1 for each rprt_send()
2. when counter is 12 , do rprt_close and rprt_open again and initialize the counter to 0.
3. Rprt_open in the beginning and rprt_close at the end.