Hide Rows and columns

Question

Post reply

Hide Rows and columns

varunkum

Default port

Points: 1479
More actions
March 1, 2011 at 10:29 am

#388945

Q1. I have a row with all zero's and another row with all nulls(empty). How do i hide them both ?
Q2. I have a column with all zero's and another column with all nulls(empty). How do i hide them both ?
Note: I have other rows and columns which have data and i want to see them. l Just want to hide 0's and nulls.BTW its a matrix report.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

Please post your DDL and DML.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

varunkum (3/1/2011)
Q1. I have a row with all zero's and another row with all nulls(empty). How do i hide them both ?
Q2. I have a column with all zero's and another column with all nulls(empty). How do i hide them both ?
Note: I have other rows and columns which have data and i want to see them. l Just want to hide 0's and nulls.BTW its a matrix report.

Q1 - with a where clause.

Q2 - don't include them in the select statement

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 3

varunkum (3/1/2011)
Q1. I have a row with all zero's and another row with all nulls(empty). How do i hide them both ?

Select * from table

where isnull ( (c1 + c2 + c3 + c4 ) , 0) <> 0

Ron McCullough SSC Guru Points: 63877 More actions · Answer 4

without additional information .. all I can say is use the proper WHERE clause

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]