Cross Tab Help 1

[jcasas23]

I have a cross tab in CR 8.5 with two summarized fields, and I want to know how could I use the CurrentFieldValue function if I want to make a comparassion between this 2 fields.

Or What is the GridRowColumnValue function?

Thanks in advance

 

[Crystalguru]

Hello,

Check out the this knowledge base from Crystal Decisions:

http://support.crystaldecisions.com/library/kbase/articles/c2006837.asp

It seems that CurrentFieldValue and GridRowColumnValue do the same thing, which is conditional formatting the field.


crystalguru

 

[hencyt]

J,

Those two functions only allow you to conditionally format the field (i.e. add color) depending on the value. If you want to do this, in the cross-tab setup, you will need to define an alias that refers to these fields. You can't compare the result values or use them to calculate percentages etc.

You may have better luck creating a manual subreport. See

http://www.kenhamady.com/formula.html

for how to setup a manual cross tab.

You also may be able to group your subreport based on formulas that already include the comparisons you are looking for. Give more detail.

Sunny

 

[Crystalguru]

Since hencyt repeated what I just posted. Here's a great website for doing a manual crosstab:

http://www.hammerapps.com/techtips/techtipsasp/techtipsdynamic.asp?TTID=129

crystalguru

 

[hencyt]

Sorry Guru- there were no replies to the post when I selected it to reply!

Sunny

 

[Crystalguru]

No problem hencyt.

There seems to be a trend going in tek-tips. Some 'know it alls' like to show others up.

I understand you weren't trying to do this.

Have a good day!

crystalguru