Suppress a row field in the crosstab

[crystalreport85]

In a cross tab I have this as a result

pic frame mirror stand
cust1 5 5 1 2
cust2 5 5 3 1

but I want to print pic and mirror together as 5(count of the record),since they are one item.
How do I do that?

i want something like this

pic/frame mirror stand
cust1 5 1 2
cust2 5 3 1

 

[lbass]

Replace your column field with a formula like:

if {table.field} in ["pic","frame"] then
"pic/frame" else
{table.field}

-LB

 

[crystalreport85]

thank you so much
Now

if {table.field} in ["pic","frame"] then
"pic/frame" else
{table.field}

Thank you so much lBass.
now I get

pic/Frame
10
10

instead of
pic/Frame

5
5

 

[lbass]

What is your summary field and what kind of summary are you using? Please also identify your row and column fields by using the convention {table.field}. If using a formula, show the content.

-LB

 

[crystalreport85]

I am using cross tab in the footer of report section
column field --table.cust name
row field ---table.item
summary-- sum of total quantity

I hope it helps
Thank you

 

[lbass]

Is this the only duplication across all items? If so, you can omit either pic or frame in your selection formula:

{table.item} <> "pic"

Then the quantities would be correct.

-LB

 

[crystalreport85]

Hi lbass ,
Sorry Still i have problem.
I told wrong it should be like this
Row field --table.cust name
column field ---table.item
summary-- sum of total quantity

I created this formula
if {table.field} = "pic" then
" "
else
{table.field}

i used this formula as my column field

and add this formula as my summary field(count of @F) I get this
(blank) mirror stand Frame
cust1 5 1 2 5
cust2 5 3 1 5

col field is blank but the summary field is not suppressed .
I check the 'suppressed the empty row and empty col' .
How to get rid of the blank column?

Thank you

 

[lbass]

Why can't you simply eliminate "pic" as I suggested in my last post?

-LB

 

[crystalreport85]

hi lbass,
I get blank col in case of 'pic' but the summary field is loaded.
with condition --table.field <> pic
like

-------(blank)
------
5
5
5
5

From customize style i check 'suppressed the empty row and col'
Thank you

 

[lbass]

I meant for you to use the clause in your record selection formula. Go to report->selection formula->record and enter it there.

-LB

 

[crystalreport85]

Thank you. So it can't be done in the cross tab itself? I was thinking becoz of the version (using 8.5)I got this problem.

 

[lbass]

You can suppress the values in the column, but it is difficult to get the entire empty column to disappear.

-LB

 

[crystalreport85]

Thank you very much for clear that . I took your suggest to work it out