if {A_PRICES.PRICE_TYPE}="Bid" then {A_PRICES.PRICE} else 0

 

As there will be only one "Bid" price per day, this field is then summed in the Group Footer and then suppressed so as to show one price per day.

 

Below this in the Report Footer I have a Running Total which shows the highest price in the period and this works perfectly -BUT.....

 

.... in this Report Footer for the life of me I cannot return the actual date of this highest price (i.e. {A_PRICES.PRICEDATE}

 

 

In essence all I want is a new running total, based on a running total returning the date of the highest return.

 

Or

 

A running total returning a different return to what the running total is summing i.e. it calculate the highest price and then returns a date field instead.

 

 

 

 

 

To me, this all seems like it should be easy, but it's causing me pain and frustration!! Any help really would be most appreciated!

 

Thanks!!