Q: sub-report; show or not show

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

Q: restrict other users

Hello,
I need to restrict other users to modify database including network
administrator. I go to permission tab and remove all checks and set
everything for my user but it seem administrator still have ability to modify
it.
How can I get only one user do everything and the rest have only read access?
Thanks,
Jim."JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:ADF936CE-5020-4CE0-A5E9-8C0EE086069C@.microsoft.com...
> Hello,
> I need to restrict other users to modify database including network
> administrator. I go to permission tab and remove all checks and set
> everything for my user but it seem administrator still have ability to
modify
> it.
> How can I get only one user do everything and the rest have only read
access?
> Thanks,
> Jim.
By default the BUILTIN\Administrators group is mapped to the sysadmin fixed
server role. To prevent this, first ensure that your user is mapped to the
sysadmin role, then either delete the admistrators login (stop them logging
in), or remove it from the sysadmin role. If everyone needs read access
then grant the appropriate permissions to the public role.
http://snodland.blogspot.com
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004