empty row

Hello everyone,

I made a crosstab. But the first row is always empty (see attached file png). do you have any idea?
How could I supress this row?
I guess maybe the failure is because I made a left outer join. (please see DataSet Join)

Normaly this empty field would be no problem, but I use pagebreak on "ABT_NAME" and so the first page is always empty.

best regards
Rafael

PS. If I made single sql queries in my database I dont have empty rows.

Find more posts tagged with

Comments

mwilliams

With your join, you probably get null values in your fields you're using for the dataSet. You should be able to just filter these values out, I would think.

birtprofi

Do you hava any idea?

Maybe it would be better if I could make a pagebreak manually? I made the pagebreak after every new "ABT_NAME".

after the empty row, birt also makes a pagebreak. Could I supress this?

best regards

rafael

mwilliams

Rafael,

Did you try to filter out the null values?

birtprofi

yes, but if I say ABT_NAME is not null, or something like this. (I?ve tried differnet things), then my crosstab change his look.

without filter = days 1-30 of current month (one empty row)
with filter: days 1,2,3, 6,7, 10 (no empty row)

but I need to display all days.

best regards

mwilliams

Rafael,

If you know a name that will always be in ABT_NAME or are able to figure one out somehow and create a computed column in your dataSet that fills in the null ABT_NAME values with the valid one, this should merge this row with a valid row and not change any of the numbers since they are null.