Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group report by 2
Message
From
25/06/2004 12:04:50
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00917115
Message ID:
00917278
Views:
10
>This is not true ... my suggestion keeps lines 1 and 2 together.

Let me see; perhaps I was confusing it with recno(). Would the variable be increased AFTER the record is printed?

I was reasoning like this:

For the first record (I was assuming the variable, rnLineCounter, would be equal to 1), int(1/2) = 0.

For the second record, int(2/2) = 1, so that would be a different group. Am I making the wrong assumptions about the way the variable is evaluated?

>
>
>
>>I suggest a slight correction: adjust the expression to
>>
>>
>>int((rnLineCounter+1)/2)
>>
>>
>>Otherwise, the first record will appear by itself.
>>
>>
>>>Create a report variable called rnLineCounter, set it to COUNT() and reset at end of report.
>>>
>>>Add a data group with the expression of INT(rnLineCounter/2).
>>>
>>>Now you can expand the size of the data group footer to give you the white space between every set of two records.
>>>
>>>Cathy
>>>
>>>
>>>>i want my report to appear like this,
>>>>
>>>>record 1
>>>>record 2
>>>>
>>>>record 3
>>>>record 4
>>>>
>>>>record 5
>>>>record 6
>>>>.
>>>>.
>>>>.
>>>>.
>>>>etc
>>>>
>>>>how do i do that? pls help. TIA.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform