Solved

Crystal reports 2011 crosstab formating

Posted on 2014-03-12
8
1,076 Views
Last Modified: 2014-03-24
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
Comment
Question by:fpkeegan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39924167
I don't see any way to conditionally display those lines.

mlmcc
0
 
LVL 22

Assisted Solution

by:Ido Millet
Ido Millet earned 500 total points
ID: 39924610
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
 

Author Comment

by:fpkeegan
ID: 39935427
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 22

Expert Comment

by:Ido Millet
ID: 39935470
Interesting behavior!  What version of Crystal?  
Perhaps try to assign a border with a white line color to the empty cells...
0
 

Author Comment

by:fpkeegan
ID: 39936634
Will try the white boarders

CR Developer
Crystal reports 2011
Version 14.0.4.738 RTM
0
 

Accepted Solution

by:
fpkeegan earned 0 total points
ID: 39939394
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
 
LVL 22

Expert Comment

by:Ido Millet
ID: 39939427
Excellent.  Thanks for closing the loop.
0
 

Author Closing Comment

by:fpkeegan
ID: 39949794
good staring point on the answer.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question