• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 97
  • Last Modified:

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
0
Sailee Govekar
Asked:
Sailee Govekar
  • 4
  • 3
2 Solutions
 
Raghavendra HullurSoftware DeveloperCommented:
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.
0
 
Sailee GovekarStudentAuthor Commented:
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
0
 
Raghavendra HullurSoftware DeveloperCommented:
Are you referring to space between report header sections a to d? I mean those blank rows 2,4,6 and 8? If so, I think it's because of the single line borders being used. If you remove those and fit section and cover each of those sections fully, there won't be extra rows. But that depends on your requirement.
1
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Sailee GovekarStudentAuthor Commented:
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
0
 
Raghavendra HullurSoftware DeveloperCommented:
It won't change if you just remove top or bottom borders. You can try with single header though.
1
 
Sailee GovekarStudentAuthor Commented:
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
0
 
Raghavendra HullurSoftware DeveloperCommented:
Well, all I can think of to get borders when text is blank is to include another textbox or database field and make the text as white and include a border for that field and set same size and positions as in attached report. I have included a screenshot as well with the details of field use.
You can navigate to report explorer and check for the section in which fields used to find out the field and set the details.
InteractionSheetReport--2-.rpt
Capture.JPG
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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