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
