hiding Table Rows

Is it possible to determine whether or not another row in a table is visible? The example is in a multiple detail row table, where I want to display a 'header' row (really just another detail row), if any of the other detail rows in the 'section' are visible.  Is there some syntax like ReportItems!TableRow7.property("Hidden")=?? that I could use to determine the visibility state of a row?Thanks
Anil

Hi,
in Layout Tab, select the row and in the Property Panel select Visibility -> Hidden -> Expression.
Best Regards
|||

Thanks for your response but it does not solve my problem.

My Problem is I have master detail records.

If detail records are not existing then I have to make the master row invisible

Could anybody help me out fom this problem.

Ofcourse I solved it by modifying the database query but still want the solution of this problem

Thanks

Anil

|||

Hi...Yes u can hide the Rows using If Expressions...do onething...what ever the textbox u want hide...go.
1)..selct Property Window(F4) ...
2) then click Visibility -> hidden -> Select <Expressin..>
then write like this....I am writting One Example Only.....use this...

=iif(ReportItems!textbox2.Value="Y",False,True)
False-- Visible
True- Hide of textbox
U cAN WRITE FOR ANY THING....
Ok..Good Luck...

Hiding rows in a matrix and still showing subtotals for that row

Hi
I'm trying to tidy up a report that has a detail row that's not needed but
the subtotal row for that row is... hope that makes sense. The subtotal is
in fact is an average of the detail row. If I hide the detail row, the AVG
row also disappears! This is more or less what it looks like:
Machine Name | Cloth | Utilised Looms | 1 3 5 6
Available Looms | 6 4 7 6
Total Utilised Looms | 1 3 5 6
Available Looms | 6 4 7 6
What I'm trying to do is hide the second row...
Any ideas would be appreciated.
Many thanks
Rob
--
Message posted via http://www.sqlmonster.comIf you edit the properties of de detail-cel an set the visibility/hidden
property =TRUE it should work
"robhob via SQLMonster.com" wrote:
> Hi
> I'm trying to tidy up a report that has a detail row that's not needed but
> the subtotal row for that row is... hope that makes sense. The subtotal is
> in fact is an average of the detail row. If I hide the detail row, the AVG
> row also disappears! This is more or less what it looks like:
> Machine Name | Cloth | Utilised Looms | 1 3 5 6
> Available Looms | 6 4 7 6
> Total Utilised Looms | 1 3 5 6
> Available Looms | 6 4 7 6
> What I'm trying to do is hide the second row...
> Any ideas would be appreciated.
> Many thanks
> Rob
> --
> Message posted via http://www.sqlmonster.com
>

Hiding Matrix column data but still have totals displaying.

Hi,
I'm working on a matrix report with salary information. One of my
requirements is to have the sub total display but not the detail
within the report. Is this possible? "Here is an example: This "-"
is showing hidden salary information.
December January
HOURS TOTAL HOURS TOTAL
Employee A 5 - 4 -
Employee B 5 - 4 -
TOTAL $500 $450On Dec 18, 1:45 pm, michael h <mikej...@.gmail.com> wrote:
> Hi,
> I'm working on a matrix report with salary information. One of my
> requirements is to have the sub total display but not the detail
> within the report. Is this possible? "Here is an example: This "-"
> is showing hidden salary information.
> December January
> HOURS TOTAL HOURS TOTAL
> Employee A 5 - 4 -
> Employee B 5 - 4 -
> TOTAL $500 $450
Use the InScope() function in your Details Expression. Basically, the
InScope("groupName") returns True when the Details section is
contained in the named group. If your use the name of the Row Group,
then you will be InScope = True when the report is rendering the rows,
and InScope = False when the report is rendering the totals.
Use an Expression like:
= IIF( InScope( "matrix1_Employees"), "-", Sum( Fields!
Salary.Value ) )
-- Scott

hiding header row in a group

I have a table with a group. I have one row of the group that is the header for the detail section. How can I suppress the row header in the group if there is no data in the detail section for a group value? I was thinking something along the line of setting the visibilty of the row header to an expression based on the existence of data in the detail, but don't know how to go about this.

Thanks.

Hi steve,

You can try using the Count function for any fields.

The expression in the HIdden property of the table header would be
=IIF(Count(Fields![WhateverField]) = 0, True, False)

I tried it out and it seemed to work on my test.
Hope this works !

BErnard Ong

|||

To check for the existence of records in a given group, you can use count function with scope parameter like this in the visibility expression of the group header row:

=IIf(Count(Fields!YourField.Value, "Group1")=0, true, false)

Where Group1 is the name of the group that you have in your table.

Shyam

Hiding duplicates in a details row and hiding the row when it's em

I have a report that is using the drill down feature. So i have 2 detail
rows. The first row is field labels for the 2nd details row. What i would
like to do is only show the first details row once. I know i can set the
properties for each field to hide duplicates but then i'm still stuck with it
showing the blank row. So if i could find a way to suppress the first row
when it's blank that would be good or find a way to only print the first
details row once.well i answered my own question. i moved the field labels to the bottom of
the last grouping before the details, made sure all of the textbox fields
were marked hide duplicates, set the row height to 0, set visibility for the
row to true, and set the toggle setting to be the same as the detail toggle
setting.
"deniseamat" wrote:
> I have a report that is using the drill down feature. So i have 2 detail
> rows. The first row is field labels for the 2nd details row. What i would
> like to do is only show the first details row once. I know i can set the
> properties for each field to hide duplicates but then i'm still stuck with it
> showing the blank row. So if i could find a way to suppress the first row
> when it's blank that would be good or find a way to only print the first
> details row once.

Hiding a row in a table based on whether another row is hidden

Is it possible to determine whether or not another row in a table is visible?
The example is in a multiple detail row table, where I want to display a
'header' row (really just another detail row), if any of the other detail
rows in the 'section' are visible. Is there some syntax like
ReportItems!TableRow7.property("Hidden")=' that I could use to determine the
visibility state of a row?
ThanksDid you find a solution on your problem? I have a simular problem.
"PD" wrote:
> Is it possible to determine whether or not another row in a table is visible?
> The example is in a multiple detail row table, where I want to display a
> 'header' row (really just another detail row), if any of the other detail
> rows in the 'section' are visible. Is there some syntax like
> ReportItems!TableRow7.property("Hidden")=' that I could use to determine the
> visibility state of a row?
> Thanks|||I have the same problem. Is there any on
"aCa" wrote:
> Did you find a solution on your problem? I have a simular problem.
> "PD" wrote:
> > Is it possible to determine whether or not another row in a table is visible?
> > The example is in a multiple detail row table, where I want to display a
> > 'header' row (really just another detail row), if any of the other detail
> > rows in the 'section' are visible. Is there some syntax like
> > ReportItems!TableRow7.property("Hidden")=' that I could use to determine the
> > visibility state of a row?
> >
> > Thanks