Friday, February 24, 2012

Hiding field by asking if another field is empty

Hello,
I need to hide a field (or retangle) by asking if another field in the
report, like text field (or some other entity i can create on the fly,
that is not a Data field)
for eg:
I create a text field in a retangle.
The text field include expression that determine what data to display,
if any.
I want to hide the retangle if the text field if empty.
So, can i use in an expression somthing other then a Data field or a
Parameter?
Thanks in advance,
Eitan perryYou can use ReportItems("itemname").Value
But I'm not sure if it would work to hide the parent (rectangle) if the
child (text box) is empty. You'll just have to try, but I'd rather just use
the expression used in your text box on the visibility property of the
rectangle. If the textbox value = fields!Field1.Value & fields!Field2.Value,
you should be able to do something like
=IIF(IsNothing(fields!Field1.Value & fields!Field2.Value), true, false)
in the visibility parameter.
Kaisa M. Lindahl Lervik
"Perry.Eitan" <perry.eitan@.gmail.com> wrote in message
news:1165295155.869671.109210@.j44g2000cwa.googlegroups.com...
> Hello,
> I need to hide a field (or retangle) by asking if another field in the
> report, like text field (or some other entity i can create on the fly,
> that is not a Data field)
>
> for eg:
> I create a text field in a retangle.
> The text field include expression that determine what data to display,
> if any.
> I want to hide the retangle if the text field if empty.
>
> So, can i use in an expression somthing other then a Data field or a
> Parameter?
>
> Thanks in advance,
> Eitan perry
>|||Hey,
I need that the text that follows the textbox with visibility=false to
shift up. How can one go about it?
Regards,
Ankur
Kaisa M. Lindahl Lervik wrote:
> You can use ReportItems("itemname").Value
> But I'm not sure if it would work to hide the parent (rectangle) if the
> child (text box) is empty. You'll just have to try, but I'd rather just use
> the expression used in your text box on the visibility property of the
> rectangle. If the textbox value = fields!Field1.Value & fields!Field2.Value,
> you should be able to do something like
> =IIF(IsNothing(fields!Field1.Value & fields!Field2.Value), true, false)
> in the visibility parameter.
> Kaisa M. Lindahl Lervik
>
> "Perry.Eitan" <perry.eitan@.gmail.com> wrote in message
> news:1165295155.869671.109210@.j44g2000cwa.googlegroups.com...
> > Hello,
> >
> > I need to hide a field (or retangle) by asking if another field in the
> > report, like text field (or some other entity i can create on the fly,
> > that is not a Data field)
> >
> >
> > for eg:
> > I create a text field in a retangle.
> > The text field include expression that determine what data to display,
> > if any.
> > I want to hide the retangle if the text field if empty.
> >
> >
> > So, can i use in an expression somthing other then a Data field or a
> > Parameter?
> >
> >
> > Thanks in advance,
> > Eitan perry
> >|||Sorry for replying a bit late, I've been offline for some days.
What do you mean by "shift up"?
Kaisa M. Lindahl Lervik
<hellbent4u@.gmail.com> wrote in message
news:1166009076.861211.266620@.l12g2000cwl.googlegroups.com...
> Hey,
> I need that the text that follows the textbox with visibility=false to
> shift up. How can one go about it?
> Regards,
> Ankur
>
> Kaisa M. Lindahl Lervik wrote:
>> You can use ReportItems("itemname").Value
>> But I'm not sure if it would work to hide the parent (rectangle) if the
>> child (text box) is empty. You'll just have to try, but I'd rather just
>> use
>> the expression used in your text box on the visibility property of the
>> rectangle. If the textbox value = fields!Field1.Value &
>> fields!Field2.Value,
>> you should be able to do something like
>> =IIF(IsNothing(fields!Field1.Value & fields!Field2.Value), true, false)
>> in the visibility parameter.
>> Kaisa M. Lindahl Lervik
>>
>> "Perry.Eitan" <perry.eitan@.gmail.com> wrote in message
>> news:1165295155.869671.109210@.j44g2000cwa.googlegroups.com...
>> > Hello,
>> >
>> > I need to hide a field (or retangle) by asking if another field in the
>> > report, like text field (or some other entity i can create on the fly,
>> > that is not a Data field)
>> >
>> >
>> > for eg:
>> > I create a text field in a retangle.
>> > The text field include expression that determine what data to display,
>> > if any.
>> > I want to hide the retangle if the text field if empty.
>> >
>> >
>> > So, can i use in an expression somthing other then a Data field or a
>> > Parameter?
>> >
>> >
>> > Thanks in advance,
>> > Eitan perry
>> >
>

No comments:

Post a Comment