Accessing Fields in a Cross Tab

[seanmahan]

Hi all,
Is it possible to access fields in a crosstab after it's been generated?
I've posted this question in the DataAccess forum as well because I wasn't sure which one to post to, sorry.
Thanks in advance

 

[TheBlondOne]

Can you be a little more specific as to what you need to access the fields for.

 

[seanmahan]

Hi, I can try.
Basically, I have a crosstab that looks like this

2003 2004
jan feb march... total jan feb... total
4 5 6 16 4 5 7

What I would like to do is get the values from those two total fields and create an average based on a number / the sum of the totals. I would like to display that below the cross tab like this.
200 / (16 + 9) = 8

Does that make more sense? All I really want to know is can I get at those total fields to work with them after the crosstab is built?

Obviously the numbers are not real but that's the gist of what I am trying to get at.
Thank you

 

[TheBlondOne]

As far as i'm aware you can't actually do anything with the values in the cross-tab other than highlight, change colour/font etc.. by using the currentfieldvalue. I think if you need to do something like that then you may have to create manual running totals to achieve the desired results.

 

[seanmahan]

Thanks SteveHill, that's what I thought.

 

[lbass]

Where does the 200 come from? There might be a way of doing this if you provide a little more information.

-LB