highlighting a table row

Have generated a report that uses a table. In the table are 2 fields, the
first is a severity and the last is the timeOfResponse which is a numeric. I
would like to highlight a row if the combination of severity and
timeOfResponse exceeds a maximum. Is this possible for a table? If not, in
a matrix?
The function would be like
iif( (fields!severity = 1 and timeOfResponse > 900),"pink",nothing)In the properties window, put your IIF statement under background color. So
it would be something like
= iif( (fields!severity = 1 and timeOfResponse > 900),"pink","transparent")
"Glass" wrote:
> Have generated a report that uses a table. In the table are 2 fields, the
> first is a severity and the last is the timeOfResponse which is a numeric. I
> would like to highlight a row if the combination of severity and
> timeOfResponse exceeds a maximum. Is this possible for a table? If not, in
> a matrix?
> The function would be like
> iif( (fields!severity = 1 and timeOfResponse > 900),"pink",nothing)|||scraejtp:
I actually have this in the background color property and it colors all rows
of the table pink.
= iif( (fields!timeOfResponse > 900),"pink","transparent")
A warning is also issued:
Value of the background color property for the textbox 'timeOfResponse' is
"transparent", which is not a valid background color.
I tried changing "transparent" to "blue". No warnings but all rows returned
pink.
Glass
"scraejtp" wrote:
> In the properties window, put your IIF statement under background color. So
> it would be something like
> = iif( (fields!severity = 1 and timeOfResponse > 900),"pink","transparent")
> "Glass" wrote:
> > Have generated a report that uses a table. In the table are 2 fields, the
> > first is a severity and the last is the timeOfResponse which is a numeric. I
> > would like to highlight a row if the combination of severity and
> > timeOfResponse exceeds a maximum. Is this possible for a table? If not, in
> > a matrix?
> >
> > The function would be like
> > iif( (fields!severity = 1 and timeOfResponse > 900),"pink",nothing)|||Okay... problem solved. Have placed the expression under the background
properties for 'tablerow'. Also, discovered that cannot use 'transparent' or
'nothing' so used 'white'.
"Glass" wrote:
> scraejtp:
> I actually have this in the background color property and it colors all rows
> of the table pink.
> = iif( (fields!timeOfResponse > 900),"pink","transparent")
> A warning is also issued:
> Value of the background color property for the textbox 'timeOfResponse' is
> "transparent", which is not a valid background color.
> I tried changing "transparent" to "blue". No warnings but all rows returned
> pink.
> Glass
> "scraejtp" wrote:
> > In the properties window, put your IIF statement under background color. So
> > it would be something like
> > = iif( (fields!severity = 1 and timeOfResponse > 900),"pink","transparent")
> >
> > "Glass" wrote:
> >
> > > Have generated a report that uses a table. In the table are 2 fields, the
> > > first is a severity and the last is the timeOfResponse which is a numeric. I
> > > would like to highlight a row if the combination of severity and
> > > timeOfResponse exceeds a maximum. Is this possible for a table? If not, in
> > > a matrix?
> > >
> > > The function would be like
> > > iif( (fields!severity = 1 and timeOfResponse > 900),"pink",nothing)|||Yeah, I thought you were already under table row, or an individual cell.
That is weird that it will not allow transparent because that looks to be
the default background for mine.
"Glass" wrote:
> Okay... problem solved. Have placed the expression under the background
> properties for 'tablerow'. Also, discovered that cannot use 'transparent' or
> 'nothing' so used 'white'.
>
> "Glass" wrote:
> > scraejtp:
> >
> > I actually have this in the background color property and it colors all rows
> > of the table pink.
> >
> > = iif( (fields!timeOfResponse > 900),"pink","transparent")
> >
> > A warning is also issued:
> >
> > Value of the background color property for the textbox 'timeOfResponse' is
> > "transparent", which is not a valid background color.
> >
> > I tried changing "transparent" to "blue". No warnings but all rows returned
> > pink.
> >
> > Glass
> >
> > "scraejtp" wrote:
> >
> > > In the properties window, put your IIF statement under background color. So
> > > it would be something like
> > > = iif( (fields!severity = 1 and timeOfResponse > 900),"pink","transparent")
> > >
> > > "Glass" wrote:
> > >
> > > > Have generated a report that uses a table. In the table are 2 fields, the
> > > > first is a severity and the last is the timeOfResponse which is a numeric. I
> > > > would like to highlight a row if the combination of severity and
> > > > timeOfResponse exceeds a maximum. Is this possible for a table? If not, in
> > > > a matrix?
> > > >
> > > > The function would be like
> > > > iif( (fields!severity = 1 and timeOfResponse > 900),"pink",nothing)

Hiding/unhiding a report field by mouse click

How would you go about making one of your fields hidden until you click on it?right click the textbox and go to properties, go to the visibility tab. Check hidden and check "can be toggled by another item". The Item selected will have a + or - on it, or you can set an expression to control visibility otherwise. If this is not what you're looking for, please provide more information about the report, mainly type of report (matrix, tabular).|||Its a matrix report, and the specific field is a picture. What I want to do is have the report run without displaying the picture, but if you click on the box the picture will then display. So I want it to default as hidden and then have some sort of button or check box to display the image.|||I have never used an image control but if there is a visiblity tab in the properties you could have it controlled by an arbitrary textbox placed perhaps in the corner of the matrix that says "Show Picture". When you set the visibility control property of the image to a textbox, the textbox will automatically show the plus or minus signs.

Hiding two fields.

My report has two fields that are only visible if the report is for the
company "HOOSIER".
so in the two fields I wonted to hide I did this:
Visibility-->Hidden-->=iif(Fields!AgencyCode.Value = "HOOSIER","false","true")
Why does this generate an error?
The Hidden expression used in textbox "Textbox60" returned a data type that
is not valid.
Is not "false" and "true" not false and true?
or is there another way false and true have to be returned from an iif
statement?
Scott BurkeOn Oct 17, 11:28 am, Scott Burke
<ScottBu...@.discussions.microsoft.com> wrote:
> My report has two fields that are only visible if the report is for the
> company "HOOSIER".
> so in the two fields I wonted to hide I did this:
> Visibility-->Hidden-->=iif(Fields!AgencyCode.Value = "HOOSIER","false","true")
> Why does this generate an error?
> The Hidden expression used in textbox "Textbox60" returned a data type that
> is not valid.
> Is not "false" and "true" not false and true?
> or is there another way false and true have to be returned from an iif
> statement?
> Scott Burke
Try this: =iif(Fields!AgencyCode.Value = "HOOSIER",False,True) ,
further it would be good to check for NULL against AgencyCode using
Nothing(..
Thnaks.|||Try
iif(Fields!AgencyCode.Value = "HOOSIER",False,True)
Also good to check value of AgencyCode for NULL using nested IIF
Sambhaji|||That did it.
Normally I get an error if I dont "" the true and false.
I guess when they turn blue you dont need "".
Thank you
Scott Burke
"Sanraj" wrote:
> Try
> iif(Fields!AgencyCode.Value = "HOOSIER",False,True)
> Also good to check value of AgencyCode for NULL using nested IIF
> Sambhaji
>
>

Hiding Sub Total Rows depending upon the certain fields

I am trying to hide a sub total row depending upon certain fields . How would i go about doing that?

Thanks in Advance

This is how the report looks like......

Jan Feb March

Revenue R1 2 3 4

want to hide this line subtotal 2 3 4

R2 5 6 7

Total 7 9 11

Hi,

For the table row has visibility property.Write the condition in the expression of the Visibilty Property for that row.

Hope this helps

|||Its not a table . Its a matrix|||

You can select edit the matrix group, in the visibility property, select expression and used the 'runningvalue' to determine when you want not to displace your group subtotal

Hiding series in a chart

Good afternoon
I have a hidiously complicated union select statement that i am feeding in
to a chart.
This creates two series and two data fields, some of these combinations dont
hold usefull data and so i would like to hide them. e.g
Series 1 and data field 1 = good data
Series 1 and data field 2 = crap data
Series 2 and data field 1 = crap data
Series 2 and data field 2 = good data
I cant find a way of hiding the series-datafield combinations that i dont
need.
The crap data that i dont want to show is always 0's but by filtering i
remove a whole data field not just part of it.
Please help
Thanks
Steve Dcan you get needed fields from your existing query?
something like this:
select Series1, Field1 from ( your complicated query ) as
ExistingQuery
where Series1 = 'whatever'
union
select Series2, Field2 as Field1 from ( your complicated query) as
ExistingQuery
where Series2 = 'whatever'
you might add extra integer field to your existing query
when Series 1 then 1
Series 2 = 2
and use it in where statement above
Steve Dearman wrote:
> Good afternoon
> I have a hidiously complicated union select statement that i am feeding in
> to a chart.
> This creates two series and two data fields, some of these combinations dont
> hold usefull data and so i would like to hide them. e.g
> Series 1 and data field 1 = good data
> Series 1 and data field 2 = crap data
> Series 2 and data field 1 = crap data
> Series 2 and data field 2 = good data
> I cant find a way of hiding the series-datafield combinations that i dont
> need.
> The crap data that i dont want to show is always 0's but by filtering i
> remove a whole data field not just part of it.
> Please help
> Thanks
> Steve D

hiding repeated data

please i would like to know if there is a way to hide repeated data(fields) in the details section.
like below:

before hiding:
1 xyz 569869
1 xyz 536214
2 aaa 236569
2 aaa 214521
3 tt1 854785

after hiding:
1 xyz 569869
536214
2 aaa 236569
214521
3 tt1 854785

thank you for any suggestion.click format field and check surpress if duplicated

hiding null rows from a matrix

All,
I have a matrix that is being populated by a sproc.
The sproc returns data which are broken into sections by fields and
then sorted by another field.
The matrix is group on the section designator.
However, each section is getting an initial row that is null.
I want to drop out the null rows from the matrix.
I am not allowed to change the sproc.
Thanks in advance,
MI have a couple of typos and things to add.
I was trying to say that the matrix is grouped on the section
designator.
within each section this is a null row showing up.
I just want the matrix to filter out the nulls.
I don't have that option to do it from within the sproc.|||Hi Max,
Did you find a solution for this, even I am facing the same problem, I need
to hide the empty rows in a matrix.
Please reply back if you have found any solution for this.
Thanks,
Kiran

Hiding fields in Fact-Dimension Table

I have a fact table i set as both dimension and fact. so this one is linked to different dimension tables and at the same time, some of its values are in measure group.

the thing is, in the list of its attributes, i can see the keys to which the different dimensions are linked. i cannot remove these key because they serve as links. but i dont want the users to see this key. it's not helpful to them anyway. how can i do it?

Example:

Fct_ServiceJobItem (Set as both dimension and fact)

JobNo

LineNum

Partkey

Amount

Dim_Parts (Dimension)

PartKey

PartNo

.

.

I dont want to see the Partkey in the Dimension Fct_ServiceJobItem. But this is linked to Dim_Parts and removing it can cause error.

cherriesh

In the designer , highlight the Fact, or attribute you want to hide and press F4.

set Visible for facts, or attributehierarchyvisible for dimensions to false