Bring specific field from record number

[thebigbadwolf]

Hello everyone,
i'm sure that the title doesn't make any sense so this is what i want to do:

if i place a field in the details section it will show the data oof the table..

record number field
1 field_A
2 field_B
3 field_C
4 field_D
... etc

Is there a function that i can select the 3rd, or the 4th record number of the table? something like (field,3) and as a result will show "field_C" for example.

Thanks

 

[thebigbadwolf]

...i'm using crystal 2008

 

[Charliy]

You could set up a suppress formula for recordnumber <> 4

 

[thebigbadwolf]

well, that would help if i wanted to print only one or two records.
The thing is that i want to print all the records, but with a different sorting. The sorting will be configured from a formula that it's already in the details section.
That's why i can't sort from this formula, it's a "whileprintingrecords" formula that you can't sort or group..

 

[Charliy]

in your report header create a formula: shared stringvar foundit := ' '

in your detail section put a formula (which you will suppress):
shared stringvar foundit;
if recordnumber = 4
then foundit := {your_field}
else foundit := foundit

then where you want to use it create a formula: shared stringvar foundit

ijf the filed your using is a number change all the stringvar's to numbervar's, if it's a date then use datevar (you'll also need to change the initial value)