Crosstab problem - add Text column with numeric columns 1

[sds786]

Hi,
I am using Crystal 11.5 with Oracle 10/universe.
I have a crosstab report with rows values Employee ID and Name, and column values with their monthly earnings like Jan, Feb, Mar, etc. I am having problem in inserting a text field (from table or formula) in summary area, I mean I need to add a Text column with each numeric column i.e.


Empl ID Name Jan Paid - Feb Paid - Mar Paid
123 David 400 Yes - 500 Yes - 300 No
456 Mike 300 No - 600 Yes - 300 Yes

Thanks for the help.

 

[lbass]

What kind of field do you have the indicates whether it is paid or not? What possible values does it contain? If it contains Yes/No, then just add the field as your second summary field, and insert a maximum on it. In the customize style tab, choose summarized fields->horizontal->show label, and check "suppress row totals" and "suppress column totals".

-LB

 

[sds786]

Thanks LB for the response – actually my paid field is computed field based on the DB field ‘Balance’ i.e. if ‘Balance’ is 0 then Full paid else if ‘Balance’ = monthly-earning then ‘Full Due’ else if Balance < monthly-earning then ‘Partial Paid’ else ‘N/A’, also I need to put column header on this field. Thanks again for the help.

 

[lbass]

Are you all set then? If not, you need to show the ACTUAL formula, not your text version.

-LB

 

[sds786]

Sorry lbass I am not clear about your response and my problem is still not resolved, actually I created my formula in Summary Fields as
Max of BalStatus,
if ({Amt.Balance}) = 0 then 'Full paid'
if ({Amt.Balance}) = ({Amt.Earn}) then 'Full Due'
if ({Amt.Balance}) < ({Amt.Earn}) then 'Partial paid'
else 'N/A'

Also, how about header, I need to display 'Bal-Status' besides the column header 'Balancs' in the report but it is not showing there.

Thanks in advance.

 

[lbass]

Your formula should be displaying fine when you use it as a summary field and insert a maximum on it. Go to the customize style tab->summarized fields->horizontal->show label. Then manually edit the label in preview as necessary.

-LB

 

[sds786]

Thanks lbass, great wishes for your career, profession and life.