Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Reports

Jacob H.
Jacob H. ✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

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.

Capture.JPG

Tags:
· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    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.

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

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

    Craig

    · Share on FacebookShare on Twitter
  • Jacob H.
    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

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    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.

    Sorry for the confusion.

    Craig

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories