Hello,
I have a sub-report and I need to show it if the data available otherwise
non of the data should be show including headers and title, how can I do this?
Thanks,Use iif statements on the visibility in properties of each object you want
hidden.
e.g.
=iif(fields!data1.value = 0 or fields!data1.value = "" or fields!data1.value
is system.dbNull,true, false)
says if the data is zero, an empty string or null then don't show it, else
show it.
hope that helps.
Greg
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:35430469-CDF7-4E4F-8E49-3A8576FF429D@.microsoft.com...
> Hello,
> I have a sub-report and I need to show it if the data available otherwise
> non of the data should be show including headers and title, how can I do
> this?
> Thanks,
>|||Hi Greg,
Thanks for your help. Can I do this on the sub-report to show it or hide it
instead of going each item in sub-report and using iif?
Letâ's say I have a parameter, if it is true, show sub-report, if not hide
it. Is this possible?
"Greg" wrote:
> Use iif statements on the visibility in properties of each object you want
> hidden.
> e.g.
> =iif(fields!data1.value = 0 or fields!data1.value = "" or fields!data1.value
> is system.dbNull,true, false)
> says if the data is zero, an empty string or null then don't show it, else
> show it.
> hope that helps.
> Greg
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:35430469-CDF7-4E4F-8E49-3A8576FF429D@.microsoft.com...
> > Hello,
> > I have a sub-report and I need to show it if the data available otherwise
> > non of the data should be show including headers and title, how can I do
> > this?
> > Thanks,
> >
>
>|||Yes that should work fine, right click on the greyed out subreport on your
master report, go to properties and visibility and stick the expression in
the box.
=iif(parameters!name.value = "true",false, true)
if parameter is true then show else don't show.
Greg
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:01060CCD-9332-447D-BC53-E1FB101FE0B8@.microsoft.com...
> Hi Greg,
> Thanks for your help. Can I do this on the sub-report to show it or hide
> it
> instead of going each item in sub-report and using iif?
> Let's say I have a parameter, if it is true, show sub-report, if not hide
> it. Is this possible?
>
> "Greg" wrote:
>> Use iif statements on the visibility in properties of each object you
>> want
>> hidden.
>> e.g.
>> =iif(fields!data1.value = 0 or fields!data1.value = "" or
>> fields!data1.value
>> is system.dbNull,true, false)
>> says if the data is zero, an empty string or null then don't show it,
>> else
>> show it.
>> hope that helps.
>> Greg
>>
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:35430469-CDF7-4E4F-8E49-3A8576FF429D@.microsoft.com...
>> > Hello,
>> > I have a sub-report and I need to show it if the data available
>> > otherwise
>> > non of the data should be show including headers and title, how can I
>> > do
>> > this?
>> > Thanks,
>> >
>>
No comments:
Post a Comment