Reports

I have several reports built that pull from several sheets. I have rules created for a couple columns so that only specific lines are included in the reports. They all have 50 lines even if there are only 25 lines with information. The rest of the lines are blank and not able to be edited. I have other reports that are much longer than 50 lines and have no blank lines at the bottom. Is it a default to have at least 50 lines in a report no matter what or is there a way to remove those unneeded lines? It would make the reports look cleaner to have no blank lines.

I've included a screenshot to show the blank lines that can't be edited.

Find more posts tagged with

Reports

Comments

Shaine Greenwood

Hi Jacob,

Reports (and sheets) display a minimum of 50 rows by default, even if that includes blank rows. There currently isn't a way to delete the blank rows in a report.

When you have a moment, submit a Product Enhancement Request using the form under Quick links on the right of the Community site and let our Product team know you'd like a way to have these blank rows removed.

J. Craig Williams

If the Report criteria is set up properly, it should not pull in blank rows.

Craig

Jacob H.

Craig,

even if it's less than 50 lines of actual data? I don't seem have this problem with reports longer than 50 lines. Is there something I'm missing?

Regards,

Jacob

J. Craig Williams

Jacob,

I might be the one missing something.

As Shaine said, what you are seeing is a display issue. The grid shows blank rows, but there is no data there. They have not been "pulled" from anywhere.

The Sheet Name column is blank.

If you export the Report to PDF, only the rows containing data are exported. (When exporting to Excel, well, Excel has its own blank rows)

There was an Enhancement Request somewhere for allowing Filters in Reports (and if there wasn't, there should be) which would solve your visual problem.