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: sub-report visible/invisible

Hello,
I have a parameter and may sub-reports. I want to make one sub-report be
visible or invisible based one of the parameter true or false. Can I do this?answered in your other post, but answer is yes.
from other thread -
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)
basically says "if parameter is true then show else don't show."
Greg
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:DB8F757A-0E83-4665-8205-04A51AF539BB@.microsoft.com...
> Hello,
> I have a parameter and may sub-reports. I want to make one sub-report be
> visible or invisible based one of the parameter true or false. Can I do
> this?
>

Q: reporting from two different database

I have two different databases DB1 and BD2. which one table in each.
TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
Now my sub-report in Reporting Services should report ID and sum of
DB1.TableDB1.Amount1 and
DB2.TableDB2.Amount2. How should I
write my query?
select t1.ID, t1.Amount+t2.Amount
from Db1.Table1 t1 join Db2.Table2 t2 on t1.ID=t2.ID should work
Sam
"JIM.H." wrote:

> I have two different databases DB1 and BD2. which one table in each.
> TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
> Now my sub-report in Reporting Services should report ID and sum of
> DB1.TableDB1.Amount1 and
> DB2.TableDB2.Amount2. How should I
> write my query?
>

Q: reporting from two different database

I have two different databases DB1 and BD2. which one table in each.
TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
Now my sub-report in Reporting Services should report ID and sum of
DB1.TableDB1.Amount1 and
DB2.TableDB2.Amount2. How should I
write my query?select t1.ID, t1.Amount+t2.Amount
from Db1.Table1 t1 join Db2.Table2 t2 on t1.ID=t2.ID should work
Sam
"JIM.H." wrote:

> I have two different databases DB1 and BD2. which one table in each.
> TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
> Now my sub-report in Reporting Services should report ID and sum of
> DB1.TableDB1.Amount1 and
> DB2.TableDB2.Amount2. How should I
> write my query?
>

Q: reporting from two different database

I have two different databases DB1 and BD2. which one table in each.
TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
Now my sub-report in Reporting Services should report ID and sum of
DB1.TableDB1.Amount1 and
DB2.TableDB2.Amount2. How should I
write my query?select t1.ID, t1.Amount+t2.Amount
from Db1.Table1 t1 join Db2.Table2 t2 on t1.ID=t2.ID should work
Sam
"JIM.H." wrote:
> I have two different databases DB1 and BD2. which one table in each.
> TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
> Now my sub-report in Reporting Services should report ID and sum of
> DB1.TableDB1.Amount1 and
> DB2.TableDB2.Amount2. How should I
> write my query?
>