A couple of beginner's questions about reporting services

I'm writing my first RS report.
1. Is there any way to program a field to clear, or even hide, under certain
conditions?
2. Is there any way to simulate a check box, to display boolean values? (I
don't see anything in the toolbox.)On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
wrote:
> I'm writing my first RS report.
> 1. Is there any way to program a field to clear, or even hide, under certain
> conditions?
> 2. Is there any way to simulate a check box, to display boolean values? (I
> don't see anything in the toolbox.)
1. Yes. Many of the controls on SSRS are expression based. In your
scenario, expressions can be used to manipulate the Hidden property of
a textbox based on other data, constants, etc.
2. Assuming you're talking about the body of the report. I have used
images in the past to simulate an X or a checkmark.|||I don't think I really understand what you mean by expressions yet. Are you
talking about writing what appears to be a vb command in the format field?
If so, I haven't been able to get that to work yet. What I'd like to do is
something like this:
iif(instr(Fields!SomeValue.Value, "A String") > 0,"",Fields!SomeValue.Value)
In other words, if the value of the incoming string does contain a
particular pattern, blank the box, otherwise display it. Or have I
completely misunderstood the concept?
"Potter" wrote:
> On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> wrote:
> > I'm writing my first RS report.
> >
> > 1. Is there any way to program a field to clear, or even hide, under certain
> > conditions?
> >
> > 2. Is there any way to simulate a check box, to display boolean values? (I
> > don't see anything in the toolbox.)
>
> 1. Yes. Many of the controls on SSRS are expression based. In your
> scenario, expressions can be used to manipulate the Hidden property of
> a textbox based on other data, constants, etc.
> 2. Assuming you're talking about the body of the report. I have used
> images in the past to simulate an X or a checkmark.
>|||On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> wrote:
> > I'm writing my first RS report.
> > 1. Is there any way to program a field to clear, or even hide, under certain
> > conditions?
> > 2. Is there any way to simulate a check box, to display boolean values? (I
> > don't see anything in the toolbox.)
> 1. Yes. Many of the controls on SSRS are expression based. In your
> scenario, expressions can be used to manipulate the Hidden property of
> a textbox based on other data, constants, etc.
> 2. Assuming you're talking about the body of the report. I have used
> images in the past to simulate an X or a checkmark.
hi there
In the properties box - there is a visibility property - you can use
this and toggle it depending on other fields.
hope that helps
jewel|||Actually no, I need a way to program the visibility based on content.
Clicking on a field won't do.
"jewelfire" wrote:
> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> > wrote:
> >
> > > I'm writing my first RS report.
> >
> > > 1. Is there any way to program a field to clear, or even hide, under certain
> > > conditions?
> >
> > > 2. Is there any way to simulate a check box, to display boolean values? (I
> > > don't see anything in the toolbox.)
> >
> > 1. Yes. Many of the controls on SSRS are expression based. In your
> > scenario, expressions can be used to manipulate the Hidden property of
> > a textbox based on other data, constants, etc.
> > 2. Assuming you're talking about the body of the report. I have used
> > images in the past to simulate an X or a checkmark.
> hi there
> In the properties box - there is a visibility property - you can use
> this and toggle it depending on other fields.
> hope that helps
> jewel
>|||In the visibility property, hidden can be set to true, false or expression.
Pick expression and put the appropriate expression there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
> Actually no, I need a way to program the visibility based on content.
> Clicking on a field won't do.
> "jewelfire" wrote:
>> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
>> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
>> > wrote:
>> >
>> > > I'm writing my first RS report.
>> >
>> > > 1. Is there any way to program a field to clear, or even hide, under
>> > > certain
>> > > conditions?
>> >
>> > > 2. Is there any way to simulate a check box, to display boolean
>> > > values? (I
>> > > don't see anything in the toolbox.)
>> >
>> > 1. Yes. Many of the controls on SSRS are expression based. In your
>> > scenario, expressions can be used to manipulate the Hidden property of
>> > a textbox based on other data, constants, etc.
>> > 2. Assuming you're talking about the body of the report. I have used
>> > images in the past to simulate an X or a checkmark.
>> hi there
>> In the properties box - there is a visibility property - you can use
>> this and toggle it depending on other fields.
>> hope that helps
>> jewel
>>|||Missed that! That's what I was looking for.
Just to play safe, here is my code.
=IIf (InStr(me.Value,"1/1/1753") > 0, True ,False)
I'm assuming that 'Me' in this context, refers to the current text field.
As I mentioned elsewhere, this is legacy code with '1/1/1753' indicating a
blank date. (No nulls, period. Company rules.)
"Bruce L-C [MVP]" wrote:
> In the visibility property, hidden can be set to true, false or expression.
> Pick expression and put the appropriate expression there.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
> > Actually no, I need a way to program the visibility based on content.
> > Clicking on a field won't do.
> >
> > "jewelfire" wrote:
> >
> >> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> >> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> >> > wrote:
> >> >
> >> > > I'm writing my first RS report.
> >> >
> >> > > 1. Is there any way to program a field to clear, or even hide, under
> >> > > certain
> >> > > conditions?
> >> >
> >> > > 2. Is there any way to simulate a check box, to display boolean
> >> > > values? (I
> >> > > don't see anything in the toolbox.)
> >> >
> >> > 1. Yes. Many of the controls on SSRS are expression based. In your
> >> > scenario, expressions can be used to manipulate the Hidden property of
> >> > a textbox based on other data, constants, etc.
> >> > 2. Assuming you're talking about the body of the report. I have used
> >> > images in the past to simulate an X or a checkmark.
> >>
> >> hi there
> >>
> >> In the properties box - there is a visibility property - you can use
> >> this and toggle it depending on other fields.
> >>
> >> hope that helps
> >> jewel
> >>
> >>
>
>|||I haven't used Me in RS (I've used it in VB). It is easy to test. Most
errors are picked up when you try to preview it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:52FB048B-27B0-436A-A269-8B1CC83E12AA@.microsoft.com...
> Missed that! That's what I was looking for.
> Just to play safe, here is my code.
> =IIf (InStr(me.Value,"1/1/1753") > 0, True ,False)
> I'm assuming that 'Me' in this context, refers to the current text field.
> As I mentioned elsewhere, this is legacy code with '1/1/1753' indicating a
> blank date. (No nulls, period. Company rules.)
> "Bruce L-C [MVP]" wrote:
>> In the visibility property, hidden can be set to true, false or
>> expression.
>> Pick expression and put the appropriate expression there.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
>> > Actually no, I need a way to program the visibility based on content.
>> > Clicking on a field won't do.
>> >
>> > "jewelfire" wrote:
>> >
>> >> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
>> >> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
>> >> > wrote:
>> >> >
>> >> > > I'm writing my first RS report.
>> >> >
>> >> > > 1. Is there any way to program a field to clear, or even hide,
>> >> > > under
>> >> > > certain
>> >> > > conditions?
>> >> >
>> >> > > 2. Is there any way to simulate a check box, to display boolean
>> >> > > values? (I
>> >> > > don't see anything in the toolbox.)
>> >> >
>> >> > 1. Yes. Many of the controls on SSRS are expression based. In
>> >> > your
>> >> > scenario, expressions can be used to manipulate the Hidden property
>> >> > of
>> >> > a textbox based on other data, constants, etc.
>> >> > 2. Assuming you're talking about the body of the report. I have
>> >> > used
>> >> > images in the past to simulate an X or a checkmark.
>> >>
>> >> hi there
>> >>
>> >> In the properties box - there is a visibility property - you can use
>> >> this and toggle it depending on other fields.
>> >>
>> >> hope that helps
>> >> jewel
>> >>
>> >>
>>|||You can also hide the field using an expression like this (instead of an iif statement):
Click your field, go to your properties box and scroll down to Visibility. Under that you have a hidden option--select Expression.
In the expression paste in a TRUE statement for what you want hidden
=Fields!Dates.Value= "1753"
That will hide the field just under certain conditions.
Hope that also gives you some flexibility
From http://www.developmentnow.com/g/115_2007_5_0_0_968676/A-couple-of-beginners-questions-about-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com