How to show first column on cross tab virtual page

[Nyaguire]

I'm using a crosstab and wish to repeat the first column on the virtual page...I've been trying to follow some of the suggested solutions but have failed to group the columns.

I have tried to create a new group using a formula like:

if {EquityExposureList_2_ttx.Counter} in ["ABCH" ,"Kingdom"] then 1 else 2

But has given me an error message which reads "The formular must be string". How do you create a grouping function?? Can somebody Help Please?

 

[lbass]

What version of CR are you using? Do you mean you want to repeat the row labels on the virtual page? There is a setting for that "Repeat row labels" on the customize style tab.

-LB

 

[Nyaguire]

I'm using crystal 8..I have tried the "Repeat row labels" option but it didn't work. Now I'm trying to group the function and then drag the cross tab in the group header/ footer. My problem is I can't get the grouping formular right.

 

[lbass]

Grouping has nothing to do with a row label on the virtual page. Are you trying to eliminate the virtual page?

-LB

 

[Nyaguire]

Thanx for the help Lbass, I've managed to repeat the row labels on the virtual page, now I wish to create a cross tab showing percentages of the grant total. I'm using crystal 8, is that possible??

 

[lbass]

You need to create a SQL expression like {%grtot}:

(select sum(table.`amt`) from table)

Then create a formula {@percentgrtot}:

{table.amt} % {%grtot}

Add this formula as a summary in your crosstab and then in preview, select the summary and click on the % icon in the toolbar.

-LB