Unwanted space between sections 1

[JCruz063]

Hello all,
I have a report that contains a subreport. The subreport contains a series of formulas with borders around all sides (to give it the appearance of boxes), and they are aligned horizontally one next to the other so that their side borders overlap. The boxes are in a group footer, and when printed, they are supposed to form a grid.

The bottom and top borders of the boxes in the different group footer sections are supposed to overlap (because that's how the grid would be formed), but Crystal Reports is adding a space between them. I made certain that the boxes are only as big as the section, but there still is a space in between. Also, in the section expert, I selected "keep together", and "underlay following sections", but no luck.

Does anybody know how I could kill that space? I need the borders to overlap.

Thanks.

JC

_________________________________
I think, therefore I am. [Rene Descartes]

 

[Durango122]

hi
check the format section to make sure you have supress blank section also fit to section

cheers



Durango122

 

[JCruz063]

Thanks Durango,
"Suppress Blank Section" does not do it.

I'm using Crystal Reports 10.0. Where is "Fit to Section" ?

Thanks.

JC

_________________________________
I think, therefore I am. [Rene Descartes]

 

[lbass]

I think you will need to use lines to form a grid, not field borders.

-LB

 

[JCruz063]

Thanks lb,
Just to let you know... There are 31 boxes in the report. Making 4 borders with lines for each of those means carefully arranging 124 lines... Not fun at all, but I'll have to do it. Thanks again.

JC

_________________________________
I think, therefore I am. [Rene Descartes]

 

[lbass]

You can also use inserted boxes (not text boxes) in conjunction with the lines.

-LB

 

[JCruz063]

Thanks LB,
I can't use boxes, because I have to display a different border color (for the side borders) depending on certain conditions, and boxes don't have that flexibility. I'll use two long lines (for the top and bottom borders) and I'll use formulas for the side borders. This way, I can change the color of the side borders as it needs be.

With that setup, though, there still is a little space between some of the rows. In other words, the grid appearance is still bit shaky. Am I missing something?

Thanks.

JC

_________________________________
I think, therefore I am. [Rene Descartes]

 

[lbass]

I don't think there is anything more you can do, if you need to have colored borders.

-LB

 

[JCruz063]

Thanks again...

Now, one last thing!

Even after using 'Bring to Front' and 'Sent to Back', the line object always seems to be in front of the formula field (which is used for the colored borders). This causes the colored borders (which are meant to look as long solid vertical lines) to appear broken. I now remember that this is the reason why I didn't use lines from the very beginning (yikes!!!). Is there any way to make the border of the formula fields display on top of the line objects?

Thanks.

JC

_________________________________
I think, therefore I am. [Rene Descartes]

 

[lbass]

I don't think so.I don't there is any advantage to using just the lines for the top and bottom anyway. It seems to me that the sides are the problem area. If you must use colored borders, then I think the best you can do is magnify the view to 400% and size the field to maximize it within the group section. You would get a better appearance if you didn't use the bottom line except at the bottom of the page. You could use a conditional formula like:

if remainder(groupnumber,29)= 0 then crSingleLine else crNoLine

...where 29 is the number of group footers per page.

-LB

 

[JCruz063]

Thanks again LB,
I have always worked at the 400% view, but formula fields, regardless of how close to the top/bottom of the section I made them be, always had too large a gap between them. It appears as if Crystal Reports would size them down as if to prevent them from touching the edges of the section.
Since I needed a grid-like report, the gaps between rows were too large and thus unacceptable. Thus, I cannot use formula fields to create the boxes.

Using lines solved this problem, but introduced another one. The side borders, which must be formula fields so their color can be adjusted depending on certain conditions, cannot be displayed on top of the line objects, causing the vertical lines to look broken.

Thanks again!

JC

_________________________________
I think, therefore I am. [Rene Descartes]