Cross Tab - blank line

[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

[Alex K.]

Hello,

Please send us your report with test data which reproduces the issue for analysis.

Thank you.

[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.

[HighAley]

Hello.

Please, try to check your SQL-query or add a filter to remove the empty rows.

Thank you.

[Leandro Borges]

Hello.
My SQL query is right. How do I do to add that filter to remove the empty rows?
Thank you.

[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.

[Leandro Borges]

Hello.

Got it!

Thank you.

[Alex K.]

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.