Copy values in cross tabs

[Former Member]

How to copy values from 1 st row to 2 nd row in cross tab report?

thanks

[Former Member · Accepted solution]

I want second record values to be same as first record in a crosstab.

Edited by: jaya d on May 26, 2009 4:59 PM

[former_member260594 · Accepted solution]

Jaya,

try the following;

If the row totals are on top right click on one of the totals > format field > In the conditional suppression formula enter;

numbervar x:= 0;

false

In the conditional suppression formula of the summary values enter;

numbervar x;

x:= x + 1;

if x = 1 then g:= currentfieldvalue;

false

In the Display string formula of the summary values enter;

currencyvar g;

totext (g)

Note, change the variable type to numbervar if your crosstab isn't summarizing currency.

Edited by: Graham Cunningham on May 26, 2009 2:19 PM

[Former Member]

What do you mean exactly hear?

Do you want to skip the first row or you want the same record to appera towies?

Thanks

-Azhar