"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,
>

"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,
>> >
>>
>>
>>