Page 1 of 1
Cross Tab - blank line
Posted: Wed Oct 26, 2016 7:54 pm
by Leandro Borges
Hello.
I developed a report using the Crosstab component. When generated, appear a blank line. How do I hide?
in attached my example.
Thank you.
Leandro
Re: Cross Tab - blank line
Posted: Thu Oct 27, 2016 6:52 am
by Alex K.
Hello,
Please send us your report with test data which reproduces the issue for analysis.
Thank you.
Re: Cross Tab - blank line
Posted: Thu Oct 27, 2016 11:45 am
by Leandro Borges
Hello.
Unfortunately I do not have permission to send the report.
In my tests, i realized that the blank line is because some null, records returned by my select.
Thank you.
Re: Cross Tab - blank line
Posted: Fri Oct 28, 2016 9:59 am
by HighAley
Hello.
Please, try to check your SQL-query or add a filter to remove the empty rows.
Thank you.
Re: Cross Tab - blank line
Posted: Fri Oct 28, 2016 12:23 pm
by Leandro Borges
Hello.
My SQL query is right. How do I do to add that filter to remove the empty rows?
Thank you.
Re: Cross Tab - blank line
Posted: Fri Oct 28, 2016 2:22 pm
by HighAley
Hello, Leandro.
You could do it different ways.
One of them is to check the column for Null value with next expression:
Code: Select all
DataSourceName["ColumnName"] == DBNull.Value
Thank you.
Re: Cross Tab - blank line
Posted: Mon Nov 28, 2016 5:30 pm
by Leandro Borges
Hello.
Got it!
Thank you.
Re: Cross Tab - blank line
Posted: Mon Nov 28, 2016 6:50 pm
by Alex K.
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.