>>>>Hi Ed - I hope you do not mind me sending you this
>>>>question.. I made a report in the REPORT DESIGNER and
>>>>it takes up about 1/2 a page for one record. I am only getting one record per page and I would like to print two records per page. can you help?...thanks..rob
>>>
>>>Generally speaking, you have to group your report (cursor) by every two records and select "Start new group from new page" (I'm not sure about exact name) grouping option.
>>>If your report cursor is not too big (and I assume it's the case, because otherwise you would spent alot of paper printing 1(2) rec/page) you can easily modify report cursor adding new 'grouping' field with values like: 1,1,2,2,3,3 etc.
>>
>>thanks Ed.. In the Data Grouping window, under Group Properties, I have found the "Start each group on a page". You must enter something in the group expressions box. I do not know what to put there. It looks like it is looking
>>for somekind of a variable.
>>any ideas?...thanks rob
>
>I have told you the idea: you add one more field (e.g. GroupNum ) and fill it with values providing grouping by every two records (Rec#1 GroupNum =1, Rec#2 GroupNum=1, Rec#3 GroupNum =2, Rec#4 GroupNum =2, etc.)
>You could use
>Replace All GroupNum with CEILING(RECNO()/2)
thanks Edward...