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
Solved

Crystal reports 2011 crosstab formating

Posted on 2014-03-12
8
1,070 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
  • 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
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

840 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