Matrix: Hide null value row

The matrix that i have contains null values and is creating empty rows. I tried grouping the row and then setting the visible property, but that just hides the entire rows. Is there an expression that i would need to ensure that only the null rows are not visible on the matrix?

Thanks for taking the time to read.

The database tables looks like:

Month Sales Product

- - --

August 2007 700.00 Apples

August 2007 400.00 Oranges
September 2007 380.00 Apples
October 2007 1200.00 Oranges
November 2007 NULL NULL
December 2007 NULL NULL
Jan 2008 400.00 Grapefruit

The matrix looks like:

August 2007 Sept 2007 Oct 2007 Nov 2007 Dec 2007 Jan 2008

Apples 700.00 380.00

Oranges 400.00 1200.00

Grapfruit 400.00

Try filtering these records. You can use the filter within the Matrix properties to filter all records where Product Names are NULL

|||

I actually tried filtering in the edit group searching for nulls but it didn't work.

I did a bit of searching and found that i needing to use this: =IsNothing(Fields!productname.Value) in the filter expression for the group.

Thanks for your help.sql

Matrix 'Total' formatting

Hey All,
Maybe I have been looking in the wrong places for the last 2 hours but
can someone tell me how to add a borderstyle property to the 'subtotal'
row on a matrix. I can get it to work for the 'total' textbox itself
but not the entire row. I have even looked in the XML (which I never
miss with) and still cannot find anything. Please! Please! Someone help
me! This is for a client. Even if it cannot be done, let me know!!!!
Thanks in advance a billion times over,
KerrieJust click once on the row field then go to view and click properties
window. You can change the borderstyle there to solid. You can do that on
any column or row or just one field.
"Kerrie" <ksorrell@.cincom.com> wrote in message
news:1156788001.882559.169420@.75g2000cwc.googlegroups.com...
> Hey All,
> Maybe I have been looking in the wrong places for the last 2 hours but
> can someone tell me how to add a borderstyle property to the 'subtotal'
> row on a matrix. I can get it to work for the 'total' textbox itself
> but not the entire row. I have even looked in the XML (which I never
> miss with) and still cannot find anything. Please! Please! Someone help
> me! This is for a client. Even if it cannot be done, let me know!!!!
> Thanks in advance a billion times over,
> Kerrie
>|||Ben,
I have tried that and for some reason it will only do it for the Total
testbox, not the whole row. It is driving me nuts. I am not sure where
to go from here.
Thanks for your help though, it is greatly appreciated!
Thanks, Kerrie
Ben Watts wrote:
> Just click once on the row field then go to view and click properties
> window. You can change the borderstyle there to solid. You can do that on
> any column or row or just one field.
> "Kerrie" <ksorrell@.cincom.com> wrote in message
> news:1156788001.882559.169420@.75g2000cwc.googlegroups.com...
> > Hey All,
> >
> > Maybe I have been looking in the wrong places for the last 2 hours but
> > can someone tell me how to add a borderstyle property to the 'subtotal'
> > row on a matrix. I can get it to work for the 'total' textbox itself
> > but not the entire row. I have even looked in the XML (which I never
> > miss with) and still cannot find anything. Please! Please! Someone help
> > me! This is for a client. Even if it cannot be done, let me know!!!!
> >
> > Thanks in advance a billion times over,
> > Kerrie
> >|||You need to right-click on the little green triangle at the top right-hand
corner of the total textbox to get to the properties of the actual total.
HTH,
magendo_man
"Kerrie" wrote:
> Hey All,
> Maybe I have been looking in the wrong places for the last 2 hours but
> can someone tell me how to add a borderstyle property to the 'subtotal'
> row on a matrix. I can get it to work for the 'total' textbox itself
> but not the entire row. I have even looked in the XML (which I never
> miss with) and still cannot find anything. Please! Please! Someone help
> me! This is for a client. Even if it cannot be done, let me know!!!!
> Thanks in advance a billion times over,
> Kerrie
>|||YOU ARE THE GREATEST!!!!!!
THANK YOU! THANK YOU!
It worked!!!!!!
Thanks, Kerrie
magendo_man wrote:
> You need to right-click on the little green triangle at the top right-hand
> corner of the total textbox to get to the properties of the actual total.
> HTH,
> magendo_man
> "Kerrie" wrote:
> > Hey All,
> >
> > Maybe I have been looking in the wrong places for the last 2 hours but
> > can someone tell me how to add a borderstyle property to the 'subtotal'
> > row on a matrix. I can get it to work for the 'total' textbox itself
> > but not the entire row. I have even looked in the XML (which I never
> > miss with) and still cannot find anything. Please! Please! Someone help
> > me! This is for a client. Even if it cannot be done, let me know!!!!
> >
> > Thanks in advance a billion times over,
> > Kerrie
> >
> >

Matrix Subtotal Action Hyperlink

I've created a matrix report that uses the "Jump to URL" option of the action property to allow my report to drill down to a website using query strings.

For example, the action property looks something like this:
="www.mywebsite.com/page.htm?company=" + Fields!Company.Value + "&status=" + Fields!Status.Value

This works nicely for all the cells in the matrix, but it doesn't work for the subtotals. For example if I click on the subtotal for company "ABC" for all statuses, I would like my query string to link as follows:
="www.mywebsite.com/page.htm?company=" + Fields!Company.Value + "&status="
where no status is specified.

Any ideas or suggestions?
ThanksI did a little more searching and found my question has already been answered here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=24371&SiteID=1

Matrix report export to Excel

I created a report based on matrix.
I set the can grow property of all fields to false.
In the report the fields are behaving as expected - the size is fixed.
When I'm exporting to excel the fields are growing according to the text size.
(I have other report based on table and the can grow property controls the
fields alos when exporting to excel).
How can I control the can grow?
Thak'sHello,
It seems that you're running into a limitation in Excel. When there are
merged cells in a row, Excel cannot apply it's equivalent of CanGrow on the
row. You're likely running into merged cells due to the layout of your
report. If items in the report don't line up with each other vertically,
SRS are forced to span items across multiple cells in order to preserve
your layout.
I have forwarded your feedback to the product team. In the meantime, I also
encourage you submit via the link below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Please note that the newsgroups are staffed weekdays with a goal to provide
ONE BUSINESS DAY RESPONSE to all posts.
If this response time does not meet your needs, please contact CSS for more
immediate assistance:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607

Matrix Conditional Formatting

I have a matrix and want to put a border on only one column. I have
this expression in the right and left borderstyle property:
=iif(First(Fields!desc.Value)="Sent Census","Solid","None")
So if the value column = "Sent Census" then I want the column to have a
left and right border. My problem is that if the data cell has a 0 in it, the
border doesn't appear. I know why, I'm just looking for a work around to
have the whole column bordered even if a 0 is placed in the data cell.
Thanks!Seems like as soon as I post a question, I figure out the answer:
=iif(ReportItems("desc").Value="Sent Census","Solid","None")
You reference the textbox, not the data. doh.
"Sharon" wrote:
> I have a matrix and want to put a border on only one column. I have
> this expression in the right and left borderstyle property:
> =iif(First(Fields!desc.Value)="Sent Census","Solid","None")
> So if the value column = "Sent Census" then I want the column to have a
> left and right border. My problem is that if the data cell has a 0 in it, the
> border doesn't appear. I know why, I'm just looking for a work around to
> have the whole column bordered even if a 0 is placed in the data cell.
> Thanks!
>

Matrix column visibility

Hello,

I have one column group and three static columns. I'd like to control static column visibility property depending on a field value. I.e. Hidden: =Fields!GroupId<>5.

But I'm not able to find visibility property in column object. Neither in properties explorer nor RDL documentation. I'm only able to set hidden property in textbox objects.

I have RS 2005.

Thank you for any idea.

Jirka Nouza

Currently, the visibility of static matrix columns cannot be controlled. We are considering to lift this restriction in a future release.

-- Robert

|||

Well, nothing doing. Thank you for your replay.

Jirka

|||This would definitely be nice to have... is there any way to hack around this?

Matrix column visibility

Hello,

I have one column group and three static columns. I'd like to control static column visibility property depending on a field value. I.e. Hidden: =Fields!GroupId<>5.

But I'm not able to find visibility property in column object. Neither in properties explorer nor RDL documentation. I'm only able to set hidden property in textbox objects.

I have RS 2005.

Thank you for any idea.

Jirka Nouza

Currently, the visibility of static matrix columns cannot be controlled. We are considering to lift this restriction in a future release.

-- Robert

|||

Well, nothing doing. Thank you for your replay.

Jirka

|||This would definitely be nice to have... is there any way to hack around this?