Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 713
  • Last Modified:

crystal 9 crosstab - remove row label COMPLETELY


   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 ?    
1 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?

TJPRIMEAuthor Commented:

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

Tackle projects and never again get stuck behind a technical roadblock.
Join Now