crystal 9 crosstab - remove row label COMPLETELY

Posted on 2007-10-10
Last Modified: 2012-08-13

   Using Crystal 9. I have 2 Crosstabs with only 1 row but several columns (Cross Tab A has 4 Columns, Crosstab B has 5 Columns). I wish to concatenate these on the report to make a Cross tab report of 1 row and 9 columns. When I place them side by side that's fine except ..... I cannot completely remove the Row Label for the second Crosstab (even if blank, suppressed and minimised as far as possible) it still shows a small empty row label which looks messy on trhe report as it overlaps the data from Cross Tab A. How can I completely remove this Row Label field ?    
Question by:TJPRIME
    LVL 42

    Accepted Solution

    You can't completely remove it however you can remove the lines around it.  Suppress the row label fields and shrink them as far as you can.  Rt. click on the crosstab and select Crosstab Expert -> Customize Style -> Format Grid Lines.  Then uncheck the 'Draw' box for the lines you don't want to appear.

    You will still end up with a narrow blank space between the two crosstabs but you shouldn't have the label overlay problem.

    If you're laying these side by side I would normally have them on the same crosstab to begin with but I assume they're operating on different data sets or there's some reason they need to be separate?


    Author Comment


    Now I know I can't remove Space I've modified SQL to use only one Crosstab for both sets of data and its OK.

    I've set the colour to Red for the fields that were originally in CrossTab B based on trhe valuers in the Heading. However this is notr working as its not recognising the correct value in the Column Header Field  at Run Time (even though it gave the correct values in Dropdown when I was coding the use of the colour background). I've not had much time so I'll have another look. Most values in the Column Header Field are 4 digit Years and maybe its expecting a Date format. I'll have a look. Thankyou.      

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    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 …
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 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

    22 Experts available now in Live!

    Get 1:1 Help Now