BorderStyle not shown as Solid for Top ,Bottom & Right side of Reports.

HI ,

Although I am setting the Border Style for each & every cell and /or Merge cells ,But it is not reflected in the Reports Pre-view for Bottom ,Top & Right Sides in the Reports?Any clue why this is happening & for removing this & getting the right results would be helpful .

Thanks

I had an issue where the BorderStyle did not seem to change. I was attempting to set the border to None on the Bottom of a cell but did not change the BorderStyle of the cell below it. Once I changed the Top BorderStyle to None of the cell below then I saw the desired affect.

Hope this helps.

BorderStyle bug??

In RS 2005, I cannot hide a particular border by setting it to 'None' if the
Default border setting is 'Solid'.
I can get the desired result by setting the Default border to 'None' and
then setting only the borders I want to display to 'Solid', however, this is
not convenient to me as I have a large amount of reports where the Default is
solid and the borders I want hidden are set to 'None', which used to work
fine in RS 2000. Is this a bug? The control I am dealing with is a textbox,
but I have also tested a rectangle and the body of the report itself, and the
borderstyle is acting the same with all 3 objects. Also, let me add that in
layout mode while I am designing the report the borders appear to be
displaying/hiding as I would expect, but when the report is actually ran or
previewed is when the borders do not behave appropriately.
To be absolutely clear, here is an example:
The following does NOT hide the bottom border in RS 2005 like it did in RS
2000...
<BorderStyle>
<Bottom>None</Bottom>
<Default>Solid</Default>
</BorderStyle>
This does, however, work to hide the bottom border.. but very time-consuming
to try and change... (the default setting for the borderstyle in RS 2005 is
'None')
<BorderStyle>
<Top>Solid</Top>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
I appreciate your help in advance!On Mar 21, 4:13 pm, DBS5150 <DBS5...@.discussions.microsoft.com> wrote:
> In RS 2005, I cannot hide a particular border by setting it to 'None' if the
> Default border setting is 'Solid'.
> I can get the desired result by setting the Default border to 'None' and
> then setting only the borders I want to display to 'Solid', however, this is
> not convenient to me as I have a large amount of reports where the Default is
> solid and the borders I want hidden are set to 'None', which used to work
> fine in RS 2000. Is this a bug? The control I am dealing with is a textbox,
> but I have also tested a rectangle and the body of the report itself, and the
> borderstyle is acting the same with all 3 objects. Also, let me add that in
> layout mode while I am designing the report the borders appear to be
> displaying/hiding as I would expect, but when the report is actually ran or
> previewed is when the borders do not behave appropriately.
> To be absolutely clear, here is an example:
> The following does NOT hide the bottom border in RS 2005 like it did in RS
> 2000...
> <BorderStyle>
> <Bottom>None</Bottom>
> <Default>Solid</Default>
> </BorderStyle>
> This does, however, work to hide the bottom border.. but very time-consuming
> to try and change... (the default setting for the borderstyle in RS 2005 is
> 'None')
> <BorderStyle>
> <Top>Solid</Top>
> <Left>Solid</Left>
> <Right>Solid</Right>
> </BorderStyle>
> I appreciate your help in advance!
As far as I know, this is the only way to get the results you are
looking for; however, I can't say if it is a flaw or not: I guess we
would have to know MS's desired outcome to know. Sorry to not be of
more assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Borderstyle and Padding

I need a table similar to Fig-1 on my report. The subtotal and total lines need top padding and solid border at top and bottom. I’m currently using bottom padding of 20pt on the sub total row and setting the border style property of the sub total and total rows to solid at top and bottom. But the problem is that the sub total rows are being padded first and then the border at the bottom is being set to solid. As a result, my table looks something similar to figure 2, which is not acceptable to my customer. I also tried by setting the top padding of the lines below subtotals, but it doesn't give me what I need. Any way I can set the border before padding? Appreciate your help.

Figure-1

A

10

B

20

C

30

Sub Total

60

D

20

E

10

F

50

Sub Total

80

TOTAL

140

Figure-2

A

10

B

20

C

30

Sub Total

60

D

20

E

10

F

50

Sub Total

80

TOTAL

140

You can accomplish this by adding another row to the grouping footer where the subtotal row is located. To add a row in the Report Designer, right-click on the gray box to the left of the row and choose "insert row below." Be sure to remove the extra padding from the subtotal row.

Ian|||

Ian,

Clicking on the gray box on the subtotal row selects the entire row and when I right click it just gives me options to add row groups and not rows. Is there any other way? Thanks

|||What authoring application are you using? The VS 2005 Report Designer? There should be a "Insert Row" menu option on the context menu. Are you using a matirx or a table? You seem to be describing the behavior for a matrix subtotal.

From your description, I thought you were using a table with a detail group, a grouping that has only the "Include group footer" checked, for the subtotal, and the table footer enabled, for the total. My solution only works in this scenario. This solution won't work for a Matrix, since the subtotal is derived from the group being subtotaled, and cannot have another row added to it. There are ways to accomplish this in a Matrix, but it is not as straightforward as adding an empty row.

Ian|||I should have been more specific. I'm using a matrix and not a table.