Solved

Crystal reports 2011 crosstab formating

Posted on 2014-03-12
8
1,064 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
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.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

809 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