all groups > sql server reporting services > march 2005 >
You're in the

sql server reporting services

group:

How to hide/collapse detail records when blank


How to hide/collapse detail records when blank Jason Ratke
3/21/2005 3:40:45 PM
sql server reporting services:
This may sound strange, but is there anyway to collapse a detail line on a
report if all of the fields in the detail line are null?

I have a report that has several levels of grouping, and it is entirely
possible that all the fields in the actual detail line of a table will be
null. In this scenario, I would like to shrink the detail line on the
report.

I've set the CanShrink property to true on all textboxes in the detail line,
and I've got a visibility expression that hides the textboxes if the value
"is nothing".

Any suggestions would be greatly appreciated.

Thanks,
Jason Ratke

Re: How to hide/collapse detail records when blank Jeff A. Stucker
3/22/2005 10:41:12 AM
Do you also hide the table row?

--
Cheers,

'(' Jeff A. Stucker
\
[quoted text, click to view]

Re: How to hide/collapse detail records when blank Jason Ratke
3/22/2005 4:00:52 PM
Well, I would like to, but I'm not sure how. Perhaps this is a simple
question, but I just started with RS.. Just to reiterate, I need to
shrink/hide the detail line of my table, not one of the group
headers/footers (Although I would like to know how to do that too.)

Thanks,
Jason

[quoted text, click to view]

Re: How to hide/collapse detail records when blank Jeff A. Stucker
3/24/2005 2:23:28 PM
You can select the whole row and set its properties. Most properties'
values, including visibility, can be set using expressions, so you can have
conditional show/hide based on the value of a field or something else on the
report.

--
Cheers,

'(' Jeff A. Stucker
\

[quoted text, click to view]

AddThis Social Bookmark Button