how can I hide a particular row depending on the dataset rowcount in a table ?

how can I  hide a particular row depending on the dataset rowcount ?
eg: if the number of rows returned are less than 7 I want to show this row. I have a dataset that is talking to oracle and fetches me rows. This is a row in a table of the report. How would I do this ?
tech_questionAsked:
Who is Participating?
 
Auric1983Commented:
Best bet is to highlight the row you want to hide expand the Visibility properties (as described below) and use an expression

You may have to play w/ the exact syntax to get the expression just right, but.

=IIF(RowNumber < 7, False,True)


Visibilityexpression.JPG
0
 
Auric1983Commented:
You can also use CountRows instead of RowNumber.
0
 
tech_questionAuthor Commented:
can I also set the height of the row ? eg : if the record count is 7 then height should 7, if the record count is 6 then height should be 6, if the record count is 5 then the height should be 5 and so on.
0
 
Auric1983Commented:
Not that I am aware of, alternatively you could have 7 rows each with a different expression to show/hide

You would just have to modify the expression for each row depending on when you want it to show/hide
0
 
Chris LuttrellSenior Database ArchitectCommented:
It sounds like you want to exclude a row of data from the dataset, not hide a row on the report. I was originally thinking the same thing Auric suggested but your comments make me think this is a query question.

"can I also set the height of the row ? eg : if the record count is 7 then height should 7, if the record count is 6 then height should be 6, if the record count is 5 then the height should be 5 and so on."

The height is pixel height not number of rows of data.  Can you share the query with some sample data and expected results?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.