Cross tab issue

[Former Member]

Cr 2008, SQL server 2008

I have created a cross tab that has 1 row and 11 static columns, the issue is I am getting an extra row which looks like reserved space that I can not seem to suppress or hide. Any Ideas? I have other cross tabs that I have 3 rows and multiple columns and this is not happening.

Thanks,

Glenn

[Former Member · Accepted solution]

I think you have a null record for the field inserted in rows so try to avoid null fields in the record selection like this

isnull({field})=false or trim({field})<>""

regards,

Raghavendra.G

[Former Member · Accepted solution]

I was just looking at that and thought that might be the issue.

Thanks for the reply.

Glenn