Crystal Report Database Field Problem

[takume]

Hi, i have a question related to Database field. The scenario is like that:
1. I created a store procedure that return me 4 fields.
2. After i give parameter to this store procedure it suppose return me 2 records
Field 1 Field 2 Field 3 Field 4
e.g Record 1: A B C D
Record 2: xxx yyy hhh mmm

3. Then i drag this database field onto report (page header section)
4. However when i preview the report it can only show one record

Record 1: A B C D

5. I am wondering why this ?? Of course is work fine if i put those fields on Details section of the report. If i must put it on Page header section how can print out the record one by one ?? i need to write formula to loop thru. it or what ? Can anyone give me some hints ??? thanks !!

 

[Naith]

If you place a field in any section preceding the details section, you will only display the first record returned. Similarly, in any section after the details section, you'll display the last record.

You have to place this in the details section in order to display all records. Why is this not an option for you? What's the end result you're trying to achieve?

Naith