• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1132
  • Last Modified:

Crystal reports 2011 crosstab formating

I have a requirement to format a cross tab report in where the null/ empty cells do not have a border.   see the current cross tab report and the desired crosstab output. The desired output would be more of a stair step

current
desired
0
fpkeegan
Asked:
fpkeegan
  • 4
  • 3
2 Solutions
 
mlmccCommented:
I don't see any way to conditionally display those lines.

mlmcc
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Turn off the grid lines using Customize Style, Format Grid Lines.
Then, select a cell and set a conditional format on left, top, and right border:
IF CurrentFieldValue > 0 then crSingleLine

Note: remember to turn off the show cell margins option.
0
 
fpkeeganAuthor Commented:
IdoMiller

The answer you gave should work, but as always crystal reports has bugs in the Crosstab formating. there is an alligment problem in the cells.

remove the cell margins
remove margins, leave lines
remove grid lines and add borders to cell
remove grid add borders
blow up
blow up of cells
any ideas of fixing this ?
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Interesting behavior!  What version of Crystal?  
Perhaps try to assign a border with a white line color to the empty cells...
0
 
fpkeeganAuthor Commented:
Will try the white boarders

CR Developer
Crystal reports 2011
Version 14.0.4.738 RTM
0
 
fpkeeganAuthor Commented:
Very strange, white boards not necessary, I just removed the grid lines and assigned a black single line boarder. No special formulas. And it worked. It appears that the cross table does not display at all with the undefined cells.

So the solution
. Remove grid lines
. Remove cell margins
. Define a boarder

crosstabe outputcross tab definitionboarder definitiongrid definition
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Excellent.  Thanks for closing the loop.
0
 
fpkeeganAuthor Commented:
good staring point on the answer.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now