asked on

Increase width of label single border in Crystal Report

Hi,

I want to increase the width of label border to 1 pt as for now it is only hairline.
The options available in the format section are single border, double, dashed and dotted.

I will be exporting this report to excel, so how to avoid the unwanted spacing of sections?

Attached is the report:
https://drive.google.com/open?id=1YTkq8UP5MtVJqMF_MvIlXkLVZm2DnDUe

Raghavendra Hullur

Hi,
If you use a box, you can increase the thickness of lines, but it has the drawback of not growing dynamically if your label content is dynamic, otherwise, this should be fine.
Can you show or provide more details on excel output issue? As we discussed in other questions, it depends on excel output and what we need to change.

Sailee Govekar

ASKER

The same report if I export to Excel then the sections leaves extra space. Even if in report I have not added any extra space between the sections.

attached is the excel export
InteractionSheetReport.xls

SOLUTION

Raghavendra Hullur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sailee Govekar

ASKER

Yes exactly by removing those extra 2, 4, 6 and 8 rows.

I tried removing bottom label border, but it didn't changed.

I am thinking of implementing it in single header

Raghavendra Hullur

It won't change if you just remove top or bottom borders. You can try with single header though.

Sailee Govekar

ASKER

Not working.

I added stored procedure to the report. I am facing the problem where data is NULL in some places which does not reflect the borders.

Attached report:

https://drive.google.com/open?id=1ZNsL6TPeu9nTgtHmOOcxGW9fyvRid7Pk

ASKER CERTIFIED SOLUTION

Raghavendra Hullur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial