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.

Borders on tables / cells

Does anyone know how to put a border on individual cells within a table?
Thanks,
DennyClick on cell, then use property grid to set borders for selected cell
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"SQL" <denny@.news.com> wrote in message
news:uj$1VSKNFHA.3328@.TK2MSFTNGP14.phx.gbl...
> Does anyone know how to put a border on individual cells within a table?
> Thanks,
> Denny
>

Borders on Cells Not Rendering Correctly

> I am creating a report where I need to create a border around a series
> of cells. It looks great when viewing it in Report Manager; however
> (there is always a however) when I print the report some borders are
> thin and of a lighter weight than they should be.
> My cells have a 0 padding, so I thought was an issue. I changed the
> padding to 2pt - no luck.
> Any ideas? Any work-arounds? Is this an 'undocumented feature'?
Some things to try:
If you have the borders defined on one side and not the other (in other
words, the cell on the left has a right border defined) then try
setting the left border for the cell on the right.
If you have both borders defined as described above, try turning off
one or the other.
Yes, I realize those two things are contradictory, but I've personally
had times when one worked and not the other for whatever magical
reason.
I've also had cases where setting the background color to "white"
instead of "transparent" helped - and vice versa. I've had cases where
alternating the background color of rows causes the problem.
Basically, just tinker with the settings and hope for the best.having the same problems - anyone find any solutions? Can someone from
Msoft confirm there are issues with this functionaility?
cphite@.hotmail.com wrote:
> > I am creating a report where I need to create a border around a series
> > of cells. It looks great when viewing it in Report Manager; however
> > (there is always a however) when I print the report some borders are
> > thin and of a lighter weight than they should be.
> > My cells have a 0 padding, so I thought was an issue. I changed the
> > padding to 2pt - no luck.
> > Any ideas? Any work-arounds? Is this an 'undocumented feature'?
> Some things to try:
> If you have the borders defined on one side and not the other (in other
> words, the cell on the left has a right border defined) then try
> setting the left border for the cell on the right.
> If you have both borders defined as described above, try turning off
> one or the other.
> Yes, I realize those two things are contradictory, but I've personally
> had times when one worked and not the other for whatever magical
> reason.
> I've also had cases where setting the background color to "white"
> instead of "transparent" helped - and vice versa. I've had cases where
> alternating the background color of rows causes the problem.
> Basically, just tinker with the settings and hope for the best.

Borders on Cells Not Rendering Correctly

I am creating a report where I need to create a border around a series
of cells. It looks great when viewing it in Report Manager; however
(there is always a however) when I print the report some borders are
thin and of a lighter weight than they should be.
My cells have a 0 padding, so I thought was an issue. I changed the
padding to 2pt - no luck.
Any ideas? Any work-arounds? Is this an 'undocumented feature'?Yeah, I get the same thing sometimes when I export to PDF. Normally it's
because of overlapping report items that don't appear to be overlapping in
the designer. If I select the two items and use menu (Formatting, Vertical
Spacing, Remove Vertical Spacing), it fixes my issues. Hope this helps.
Steve MunLeeuw
"JJodon" <jjodon@.gmail.com> wrote in message
news:1156511711.319480.225930@.p79g2000cwp.googlegroups.com...
>I am creating a report where I need to create a border around a series
> of cells. It looks great when viewing it in Report Manager; however
> (there is always a however) when I print the report some borders are
> thin and of a lighter weight than they should be.
> My cells have a 0 padding, so I thought was an issue. I changed the
> padding to 2pt - no luck.
> Any ideas? Any work-arounds? Is this an 'undocumented feature'?
>|||Thanks for the reply, Steve.
I see what you me in regards to two objects (a subreport and a table);
however Imy issues are with cells in the same table. I tried your trick
and the Horz. and Vert. Spacing options are not available.
Steve MunLeeuw wrote:
> Yeah, I get the same thing sometimes when I export to PDF. Normally it's
> because of overlapping report items that don't appear to be overlapping in
> the designer. If I select the two items and use menu (Formatting, Vertical
> Spacing, Remove Vertical Spacing), it fixes my issues. Hope this helps.
> Steve MunLeeuw
>|||Has anybody else found a solution to this problem? I am having the exact
same results with borders in a table. Some of the detail rows have different
border widths than others. That doesn't make any sense.
BJ
"JJodon" wrote:
> Thanks for the reply, Steve.
> I see what you me in regards to two objects (a subreport and a table);
> however Imy issues are with cells in the same table. I tried your trick
> and the Horz. and Vert. Spacing options are not available.
>
> Steve MunLeeuw wrote:
> > Yeah, I get the same thing sometimes when I export to PDF. Normally it's
> > because of overlapping report items that don't appear to be overlapping in
> > the designer. If I select the two items and use menu (Formatting, Vertical
> > Spacing, Remove Vertical Spacing), it fixes my issues. Hope this helps.
> >
> > Steve MunLeeuw
> >
>|||Same problem here! I can find very few reported incidents of this anywhere -
if anyone can shed some light on this problem, please do.
"bjkaledas" wrote:
> Has anybody else found a solution to this problem? I am having the exact
> same results with borders in a table. Some of the detail rows have different
> border widths than others. That doesn't make any sense.
> BJ
> "JJodon" wrote:
> > Thanks for the reply, Steve.
> >
> > I see what you me in regards to two objects (a subreport and a table);
> > however Imy issues are with cells in the same table. I tried your trick
> > and the Horz. and Vert. Spacing options are not available.
> >
> >
> > Steve MunLeeuw wrote:
> > > Yeah, I get the same thing sometimes when I export to PDF. Normally it's
> > > because of overlapping report items that don't appear to be overlapping in
> > > the designer. If I select the two items and use menu (Formatting, Vertical
> > > Spacing, Remove Vertical Spacing), it fixes my issues. Hope this helps.
> > >
> > > Steve MunLeeuw
> > >
> >
> >|||If you post a sample report I can see if I reproduce on my machine.
Steve MunLeeuw
"JJodon" <jjodon@.gmail.com> wrote in message
news:1156511711.319480.225930@.p79g2000cwp.googlegroups.com...
>I am creating a report where I need to create a border around a series
> of cells. It looks great when viewing it in Report Manager; however
> (there is always a however) when I print the report some borders are
> thin and of a lighter weight than they should be.
> My cells have a 0 padding, so I thought was an issue. I changed the
> padding to 2pt - no luck.
> Any ideas? Any work-arounds? Is this an 'undocumented feature'?
>

Border problem with subreports containing tables

I have written a main report that, for the sake of modularity,
consists of several subreports that can be switched in and out. The
main report and subreports do not include borders as part of their
internal properties. When adding each subreport item to the main
report I have applied left and right borders to that subreport item's
properties. The reason I have not applied the borders to the main
report is that I only want borders on the subreports.
The problem I am having occurs when a subreport consists only of a
table. In such cases, the borders are only rendering for the height
of the table, i.e. if a table is only half a page high then the
borders are only half the page height, whereas I want the borders to
take up the entire page height. I can get around this by defining the
height of the subreport to match the height of the main report, which
forces the borders to be excatly the defined height. However, this
has the unwanted side-effect (bug?) of adding a blank page (with
borders) to the main report inmmediately after the subreport.
If anyone has any ideas for how to achieve page height borders in this
scenario I would be very grateful to hear them.Increasing the height of the subreport will give you blank pages, the
height should be kept min ( abt .115 in), what happens is subreport
will expand to accomodate the data.
what border are you referring to? the border of the subreport table?
do u want like a sqare border for each subreports you include in the
main report?
Couldnt really understand your question.
let me know in detail..maybe i can help.
Regards,
Amit Bhandari.
jcbpalmerpcdev@.yahoo.co.uk (Julian) wrote in message news:<7a53e044.0410271336.4df0aa97@.posting.google.com>...
> I have written a main report that, for the sake of modularity,
> consists of several subreports that can be switched in and out. The
> main report and subreports do not include borders as part of their
> internal properties. When adding each subreport item to the main
> report I have applied left and right borders to that subreport item's
> properties. The reason I have not applied the borders to the main
> report is that I only want borders on the subreports.
> The problem I am having occurs when a subreport consists only of a
> table. In such cases, the borders are only rendering for the height
> of the table, i.e. if a table is only half a page high then the
> borders are only half the page height, whereas I want the borders to
> take up the entire page height. I can get around this by defining the
> height of the subreport to match the height of the main report, which
> forces the borders to be excatly the defined height. However, this
> has the unwanted side-effect (bug?) of adding a blank page (with
> borders) to the main report inmmediately after the subreport.
> If anyone has any ideas for how to achieve page height borders in this
> scenario I would be very grateful to hear them.

Border missing when exported to PDF

When exporting to PDF some of the columns have the border line missing
although the border line is visible when exported as HTML or web
archiveI have the same issue. Cell borders on tables (0.5 pt gray) randomly
disappear in the PDF rendering, but look perfect in HTML4.0. Some are there,
some are not. I tried increasing the resolution of the PDF to no avail.
Is this a bug with the PDF rendering? Is there a workaround? This is a big
issue for us.
-David
"Sush" wrote:
> When exporting to PDF some of the columns have the border line missing
> although the border line is visible when exported as HTML or web
> archive
>|||I did a search on the forums on the Adobe site and found a related issue.
Apparently several people have reported Acrobat 6.x has issues with borders
on text boxes and other thin horizontal lines. It was unclear if the issue
was the in the PDF format itself (distiller problem) or if the rendering was
messed up in the Reader.
Has anyone tried looking at this with Reader 5.x?
Microsoft, can you confirm that this is an issue with Acrobat Reader 6.x
rather than the PDF rendering extension for Reporting services?
Much thanks, David
"David Swanson" wrote:
> I have the same issue. Cell borders on tables (0.5 pt gray) randomly
> disappear in the PDF rendering, but look perfect in HTML4.0. Some are there,
> some are not. I tried increasing the resolution of the PDF to no avail.
> Is this a bug with the PDF rendering? Is there a workaround? This is a big
> issue for us.
> -David
> "Sush" wrote:
> > When exporting to PDF some of the columns have the border line missing
> > although the border line is visible when exported as HTML or web
> > archive
> >

border line not displaying properly

hi,

when i preview a report in report manager, i am not able to view borderline (right side), but when i take a print out, it is printing properly all the border lines.

i am uisng a subreport and placing it in a table.when subreport width is smaller than the cell it is placed in, the border line on right side is not displaying but in print it is displaying

with regards

suresh babu

I wasn't able to duplicate this behavior. I created a 2" wide subreport with a simple textbox on it. I then created a parent report with a simple 1 row table and placed the subreport in the middle, 3" wide cell. The right-side borders showed up in Report Manager regardless of whether I placed the borders on the table cell or on the subreport body.

Would you mind opening an issue via the below url and attaching your reports so I can take a look?

http://lab.msdn.microsoft.com/ProductFeedback/Default.aspx

Thank you.

|||

I have a similar problem, although it doesn't involve a SubReport.

I have a table with about 8 columns. For 1 row in the table, I want several of the rows to be underlined - which was handled by setting the border property of the TextBoxes. The data was underlined until I entered formulas/expressions to 3 of the Text Boxes. Now, the boxes with expressions do not show the underlines when the report is displayed, but the underlines do show up on the printed report. Text boxes without expressions are fine.

|||

If you would send a sample report (preferably one that goes against one of our sample databases) to the above URL, we'll take a look.

Thanks, Donovan.

|||

Sorry, can't provide a sample.

I will provide a little more info. I tried removing the expressions from the boxes that did not have a border - the border did not come back.

In one row, I have 8 columns. I set the bottom border to 1Pt. Solid for 7 of the text boxes. The border displayed for 4 of the 7 text boxes.

I resolved my problem by setting the top border of the row below to 1 Pt. Solid. I did this for all 7 columns. The report now displays and prints fine.

I believe, but can't prove, that the top border is displaying for 3 columns and the bottom border is displaying for the other 4 columns.

I am pretty sure that the bottom border originally displayed for all 7 columns when I began the report design. I think the border disappeared when I added the expressions - but I can't say that this is absolutely correct.

border line not displaying properly

hi,

when i preview a report in report manager, i am not able to view borderline (right side), but when i take a print out, it is printing properly all the border lines.

i am uisng a subreport and placing it in a table.when subreport width is smaller than the cell it is placed in, the border line on right side is not displaying but in print it is displaying

with regards

suresh babu

I wasn't able to duplicate this behavior. I created a 2" wide subreport with a simple textbox on it. I then created a parent report with a simple 1 row table and placed the subreport in the middle, 3" wide cell. The right-side borders showed up in Report Manager regardless of whether I placed the borders on the table cell or on the subreport body.

Would you mind opening an issue via the below url and attaching your reports so I can take a look?

http://lab.msdn.microsoft.com/ProductFeedback/Default.aspx

Thank you.

|||

I have a similar problem, although it doesn't involve a SubReport.

I have a table with about 8 columns. For 1 row in the table, I want several of the rows to be underlined - which was handled by setting the border property of the TextBoxes. The data was underlined until I entered formulas/expressions to 3 of the Text Boxes. Now, the boxes with expressions do not show the underlines when the report is displayed, but the underlines do show up on the printed report. Text boxes without expressions are fine.

|||

If you would send a sample report (preferably one that goes against one of our sample databases) to the above URL, we'll take a look.

Thanks, Donovan.

|||

Sorry, can't provide a sample.

I will provide a little more info. I tried removing the expressions from the boxes that did not have a border - the border did not come back.

In one row, I have 8 columns. I set the bottom border to 1Pt. Solid for 7 of the text boxes. The border displayed for 4 of the 7 text boxes.

I resolved my problem by setting the top border of the row below to 1 Pt. Solid. I did this for all 7 columns. The report now displays and prints fine.

I believe, but can't prove, that the top border is displaying for 3 columns and the bottom border is displaying for the other 4 columns.

I am pretty sure that the bottom border originally displayed for all 7 columns when I began the report design. I think the border disappeared when I added the expressions - but I can't say that this is absolutely correct.

Border Disappears

When I write an expression for the visability of a cell, I am finding that
the border disappears when Hide = True. I don't really want the cell to
disappear, just the text contained within it. And I want the border to always
show up.
Any ideas how I can make this happen?
Thanks,
LisaI can think of two solutions;
It is probably easier to put the test on the contents, so in the value
property use a test something like this;
=IIf(Parameters!HideValues.Value, "", Fields!MyField.Value)
If you want to hide background colours too, use this method in the
backgroundcolor property. In fact use this method almost anywhere, I
use it heavily.
This next one is a bit of hack I'm afraid. Create a rectangle object
outside the table, inside the rectangle place a textbox. Rename it to
something more recognisable. Now cut and paste the rectangle into the
cell in the table you want. Now you can hide just the textbox inside
the rectangle without affecting the cell itself.
Chris
Lisa wrote:
> When I write an expression for the visability of a cell, I am finding
> that the border disappears when Hide = True. I don't really want the
> cell to disappear, just the text contained within it. And I want the
> border to always show up.
> Any ideas how I can make this happen?
> Thanks,
> Lisa|||You could try writing an expression to change the font colour to the same as
the cell background colour...
"Lisa" wrote:
> When I write an expression for the visability of a cell, I am finding that
> the border disappears when Hide = True. I don't really want the cell to
> disappear, just the text contained within it. And I want the border to always
> show up.
> Any ideas how I can make this happen?
> Thanks,
> Lisa|||This would work but if you were to highlight the cell by dragging the
cursor across you would see what's in it.
Chris
Mary Bray [SQL Server MVP] wrote:
> You could try writing an expression to change the font colour to the
> same as the cell background colour...
> "Lisa" wrote:
> > When I write an expression for the visability of a cell, I am
> > finding that the border disappears when Hide = True. I don't
> > really want the cell to disappear, just the text contained within
> > it. And I want the border to always show up.
> >
> > Any ideas how I can make this happen?
> >
> > Thanks,
> >
> > Lisa|||Hi Lisa
if you want the text to disappear you should erase the text from the cell.
Markus
"Lisa" wrote:
> When I write an expression for the visability of a cell, I am finding that
> the border disappears when Hide = True. I don't really want the cell to
> disappear, just the text contained within it. And I want the border to always
> show up.
> Any ideas how I can make this happen?
> Thanks,
> Lisa|||This is not a good idea Mary, I have already seen that the color of the text
in textboxes does have influence on PDF generation.
I put lots of textboxes in the head area of a table and when setting the
textcolor=backcolor the generated PDF looked another way as it looked with
visible text in the boxes.
Markus
"Mary Bray [SQL Server MVP]" wrote:
> You could try writing an expression to change the font colour to the same as
> the cell background colour...
> "Lisa" wrote:
> > When I write an expression for the visability of a cell, I am finding that
> > the border disappears when Hide = True. I don't really want the cell to
> > disappear, just the text contained within it. And I want the border to always
> > show up.
> >
> > Any ideas how I can make this happen?
> >
> > Thanks,
> >
> > Lisa

Border around group of textboxes

Hi- I'm trying to enclose a group of textboxes by a border, essentially a VB
groupbox or panel. I've tried using both a rectangle and text box object with
a border to accomplish this. When you preview it looks right; however, when
the report is rendered, the html generates a separate table with a border
then all the textboxes below it. How can I get the html to render properly?
ThanksHTML does not support overlapping reportitems, they will get pushed around.
It sounds like you don't want overlapping reportitems, but you want the
textboxes being contained inside the rectangle.
You can achieve this by using drag-and-drop in report designer to drop the
textboxes into the rectangle - rather than having them overlapping. If a
textbox is contained inside a rectangle and you try to move the textbox with
the mouse, you will notice that the rectangle determines the boundaries for
moving the textbox (unless you move the textbox completely out of the
rectangle).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony Ballman" <TonyBallman@.discussions.microsoft.com> wrote in message
news:59DF8C12-2087-4BF1-9579-C44F6DAE738D@.microsoft.com...
> Hi- I'm trying to enclose a group of textboxes by a border, essentially a
VB
> groupbox or panel. I've tried using both a rectangle and text box object
with
> a border to accomplish this. When you preview it looks right; however,
when
> the report is rendered, the html generates a separate table with a border
> then all the textboxes below it. How can I get the html to render
properly?
> Thanks
>|||Thanks that worked. Now I see I made the mistake of placing a new rectangle
over-top the txtboxes I wanted enclosed, so the textboxes arenâ't referencing
the new parent rectangle.
"Robert Bruckner [MSFT]" wrote:
> HTML does not support overlapping reportitems, they will get pushed around.
> It sounds like you don't want overlapping reportitems, but you want the
> textboxes being contained inside the rectangle.
> You can achieve this by using drag-and-drop in report designer to drop the
> textboxes into the rectangle - rather than having them overlapping. If a
> textbox is contained inside a rectangle and you try to move the textbox with
> the mouse, you will notice that the rectangle determines the boundaries for
> moving the textbox (unless you move the textbox completely out of the
> rectangle).
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tony Ballman" <TonyBallman@.discussions.microsoft.com> wrote in message
> news:59DF8C12-2087-4BF1-9579-C44F6DAE738D@.microsoft.com...
> > Hi- I'm trying to enclose a group of textboxes by a border, essentially a
> VB
> > groupbox or panel. I've tried using both a rectangle and text box object
> with
> > a border to accomplish this. When you preview it looks right; however,
> when
> > the report is rendered, the html generates a separate table with a border
> > then all the textboxes below it. How can I get the html to render
> properly?
> > Thanks
> >
>
>