Home Forums SQL Server 2008 T-SQL (SS2K8) Always Return X Number of records, even if less in the recordset RE: Always Return X Number of records, even if less in the recordset

  • J Livingston SQL (6/30/2015)


    just a thought......move the "grand total" into the report footer section and not in the detail section.

    google will be your friend if you are not sure how to do this in your access version

    Although that would get me close, it's still not what I was looking for. It would push the grand total to the bottom below all the white space, but I'm trying to eliminate the white space. Essentially simulating blank records is the only way I know of to achieve this. When doing it that way, it fills the white space with gridlines, which is what I'm looking for. Think of it as being able to handwrite a record below the ones that are printed. It's a lot easier with the gridlines.