suppress blank space for a crosstab 1

[pl1101]

I have a crosstab in a subreport. The crosstab has rows that are blank and I have suppressed blank section set in the main report and in the subreport. The section is still not being suppresed. It shows space where the crosstab should be. Help please!!!

 

[pl1101]

Update to this thread...

I don't need to suppress the whole subreport, just the crosstab which is in it's own section. The cross tab is blank, but the space is still there. I have suppress blank space checked.

 

[lbass]

If you are trying to suppress the section containing the crosstab, you should use the field corresponding to the row value in the crosstab to suppress the section in the section expert. Let's say it is a group header. Then go to suppress (not suppress blank section)->x+2 and enter something like this:

isnull({table.field})

-LB

 

[pl1101]

Thank you soooo much lbass this worked. I have worked on this issues for quite some time. You are a GENIUS!!!!