Solved

Crystal reports 2011 crosstab formating

Posted on 2014-03-12
8
1,056 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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 …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

910 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now