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!

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

Accessing Fields in a Cross Tab

Status
Not open for further replies.

seanmahan

Programmer
Jan 26, 2005
4
US
Hi all,
Is it possible to access specific fields in a crosstab after it's been generated? For example, getting the value of a running total field to perform a separate calculation?
TIA
 
Crosstabs are pretty limited, so I doubt that it will do what you want.

If you need an aggregate field for some calculation you can always roll your own, such as:

sum({tablke.field},{table.groupfield})

and use it in a calculation within a formula.

If you post spoecifics there may be a way, but once a crosstab becomes complex, one generally has to create a manual crosstab.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top