You can modify the column only to show 'Yes' and ignore for 'No'.

 

Hope it help.

 

 

Try to follow this link: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21

 

hope it help.

 

Sorry for misleading.

You can try these options:

 

1. You could always customize the crosstab style to have the font for fields in the summary column (headers, data, etc.) have the same color as the background making them invisible. Also set fontsize as small as possible to have a smaller 'empty' column

 

Or...

 

2. You can use conditional formatting for this.
There's a function GridRowColumnValue that can be used.
Example of use:
- Rightclick on the field(s) to be hidden -> 'Format field'
- Enter a formula like below for a conditional suppress or conditional formatting:
            GridRowColumnValue ("FIELD") like "VALUE"
Tip: you can choose FIELD from 'Functions' -> 'Formatting functions' -> 'Row or column names' in the function tree in the formula editor

 

 

 

hope it help.

 

You are right. It'll gives you a blank column.

 

Last thing that I can do is (maybe not suitable with you):

To highlight column 'No' with black colour.

 

In my test I create a formula 'xYes' and make it as column.

It will gives me 2 columns 'Yes' and 'No'.

Then I make a 'highlight' for column 'No' with formula:

if value xYes='No' then

- font colour = black

- background colour = black

 

And I make it samething with the result.

 

So for column 'No' it will gives me black column.

 

 

 

hope it help.

Or maybe someone else can give better idea/solutions for you.

 

 

 

i just try this steps and it might be fit with your issue.

sorry for being too much late to answer.

 

i've created a formula @yesno => if {tbl.acctype}=1 then "Y" else "N"

i made a crosstab with AccDesc as row and Yes/No as column.

and it count all transactions where the TypeTrx is '1'.

so it will print as:

                                       No      Yes

Accrued interest Dep        2         0

Fax Machines                    1         0

Car allowences                 0         1

Cash with Cashier            1         0

Bank Charges                   0         1

 

And i've modified my crosstab on for the 'Summarized field' from 'count of @yesno'  to  NthLargest of @yesno where N is '1'.

 

and it printed as:

 

 

 

hope it help for all.