Selecting a specific record value to input in header

[bradlee27514]

I am attempting something that I think should be rather simple. I think I can do it inside the report but perhaps I need to do something in my SQL command. Any help is appreciated.

My command is pretty simple:
select
gl00100.actindx,
gl00100.actnumbr_1,
gl00100.actdescr,
gl10110.actindx,
gl10110.year1,
gl10110.periodid,
gl10110.perdblnc,
gl10110.crdtamnt,
gl10110.debitamt
from
gl00100
left join
gl10110
on
gl00100.actindx=gl10110.actindx


I initially thought I just needed to display all this data in the details section. However, I actually need to pull some values and enter them in the Report Header (Page Header would be acceptable as well). I can't seem to figure out how to do this.

Basically in the header I want to say show me 'gl10110.perdblnc where gl10110.actindx=35'

I can get this in the footer by using a running total (with a formula saying actinx has to =35), but I need it in the header.

Any Ideas?

cheers,
brad

 

[lbass]

Create a conditional formula {@act35} like this:

if {gl10110.actindx} = 35 then
{gl10110.perdblnc}

Then create a second formula:

maximum({@act35})

Place that in the report or page header. This assumes that you are expecting to return only one value for this in the report.

-LB