Crystal Reports Crosstab Summary Header And Grid Line

[former_member1149471]

I am creating a crosstab report for a multi-language application.

1. I need to change all titles on the bases of selected language.

2. The grid lines are not showing between summary fields, if i am selecting 02 summary fields.

[abhilash_kumar · Accepted solution]

If you're using Crystal Reports designer that's built-into Visual Studio, some of these options may not be available.

Please try to download a trial version of CR 2016.

-Abhilash

[former_member1149471 · Accepted solution]

Yes, I guess that is true. I am using Crystal Reports Designer built-into Visual Studio. Thank you for your help.

[abhilash_kumar]

Hi Muhammad,

1. Summary labels aren't "dynamically" changeable. As a workaround, you could try creating a section above the section that holds the Crosstab.

The height of this section should equal that of the vertical space taken up by crosstab's "column" fields including the labels.

You can then create two formula fields - one for "# of Emp Actual" and one for "% Dist Actual" and place these on the new section above the Crosstab. The formulas should contain logic to switch text based on the selected language.

You'd then need to set this section to 'underlay following sections' so that the formula fields appear correctly in place of the summarized field labels.

2. Gridlines are not shown between Summary fields. As a workaround, you'd need to enable borders. You'd also have to remove gaps by right-clicking one of the summary cells > Select Grid Options > Uncheck 'Show Cell Margins'.

-Abhilash

[former_member1149471]

Dear Abhilash Kumar

Thank you for your response.

1. I will try the first option after I deploy initial release with one language.

2. I am unable to find "Grid Options" when I right click on summary fields. (crystal reports 13)

Regards,

Muhammad Amir