How to set row header in CrossTab?

[Former Member]

Hi,

How to set row header and it background color in CrossTab report?

I want to set below color on row and column header background.

Thanks.

[Former Member · Accepted solution]

Mr. Kumar,

If Show Cell Margins is unchecked then padding issue comes now, how to set padding for particular cell?

Mr. DJ,

You are correct for row header we put text object. This solution will work only first page but what about the second page? How to repeat text object on every page. I have put cross tab in Group Header section.

Thanks,

Bhavin

[abhilash_kumar · Accepted solution]

Hi Bhavin,

If you don't uncheck 'Show cell margins', the background color won't 'paint' on the entire cell. It would look something like this:

As you can see, it doesn't color the entire cell.

To overcome the padding issue after removing cell margins, you would need to

1) Manually increase the text box size

2) Use a 'Display String' formula (right-click the field > format field > common tab) with a code similar to this:

"  " & CurrentFieldValue

This is how it should look then:

For the second question about repeating text object, please post as new discussion per SCN's rules.

-Abhilash

[Former Member · Accepted solution]

Mr. Kumar,

Thanks for your quick reply.

As you said we manually increase the text box size if we do this way then bottom margin of cell is more then upper margin. You can see your example.

How to set top margin? I want to set middle align text so it is centered between the top and bottom of the cell.

Thanks,

Bhavin

[abhilash_kumar · Accepted solution]

You can do that by further increasing the height of the cell - you'll need to play around with it until it looks centered. Unfortunately, CR does not have an option to vertically center fields to a text object and this is the only workaround.

You can use the same display string logic to center align the summary fields as well. The only issue is that your numbers would need to be converted to text:

"  " & Totext(CurrentFieldValue)

-Abhilash

[Former Member · Accepted solution]

Ok

Thanks,

Bhavin

[abhilash_kumar]

Hi Bhavin,

For the header, simply create a text objects and place them above the Rows.

To color the background for the cell headers, you would first need to disable the 'Cell Margins'. To do this, right-click the blank white space to the top of the crosstab > Select Grid Options > uncheck 'Show Cell Margins'.

Now, right-click one of the column headers > Format field > Border tab > Check 'Background' > Choose a color from the drop-down.

-Abhilash

[Former Member]

Hi Bhavin,

You can just overlay a text object as the heading and draw the line objects based on cross tab display.

For ex:

Follow Abhilash suggestion you can avail the required outcome..

One more additional point  right click on crosstab -> crosstab expert -> customize style -> select any rows or columns -> then set a background color for entire column..see how this option works..

Thanks,

DJ