Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do i reference a calculated field in the report header?

Status
Not open for further replies.
novasian

novasian

IS-IT--Management
Jan 17, 2008
5
US
i have a calculated field which calculates the total of all balances in a column. but this field is at the bottom of the report. how do i reference to this calculation in the header of the report? i think it's possible. thanks!
 
Sort by date Sort by votes
One way:

Define a second query that returns just the totalization (one value) and use that for the header..

Ties Blom

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
175
tushargaurav
tushargaurav
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
145
deborahyr63
deborahyr63
NicolaTesla1
  • Locked
  • Question
Hi, Anyone has ever had issues w
Replies
0
Views
145
NicolaTesla1
NicolaTesla1
beegeeblueboy
  • Locked
  • Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
186
beegeeblueboy
beegeeblueboy
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
153
wwconslt
wwconslt

Part and Inventory Search

Sponsor

Back
Top