cancel
Showing results for 
Search instead for 
Did you mean: 

Copy values in cross tabs

Former Member
0 Kudos
38

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

thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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