Displaying the data in page header

[kutoose]

I have a report in which I need to display the values from a field in the page header.

When the report is run this field can have 3-5 values. These need NOT be placed in detail section or any where else, but ONLY on the page header, HORIZONTALLY.
Example

Advt List : Advt1, Advt2,Advt3

Crystal Version XI
Datasource : Universe ( On Oracle DB )

 

[synapsevampire]

Your users have no idea what section a value is in, nor do they care, so you'd be better served to state what is required, rather than making arbitrary architectural decisions.

Also, are you going to have multiple pages?

For instance, one approach would be to Group by the Advt List, suppress everything above the Group Footer, then use the following formula in the group header:

Numbervar Counter:=0
stringvar array MyAdvt;
reset MyAdvt;

Details formula:
Numbervar Counter;
stringvar array MyAdvt;
Counter:=Counter+1;
redim preserve MyAdvt[Counter];
MyAdvt[counter] := {table.advt}

Group footer formulas (these will show at the top of the page):
// 1st value
stringvar array MyAdvt;
MyAdvt[1]

// 2nd value
stringvar array MyAdvt;
MyAdvt[2]

and build out the 5 by incrementing the MyAdvt[X], where x is the subscript of the array.

Or you might subreport the values in the page header, with poor performance and more work.

-k