an example of a culprit for an extra blank page in an SSRS report

...is this:

<TablixRowHierarchy>
   <TablixMembers>
      <TablixMember>
         <Group Name="list1_Name">
            <GroupExpressions>
               <GroupExpression>=Fields!Name.Value</GroupExpression>
            </GroupExpressions>
            <PageBreak>
               <BreakLocation>Between</BreakLocation>
            </PageBreak>
         </Group>
         <SortExpressions>
            <SortExpression>
               <Value>=Fields!Name.Value</Value>
            </SortExpression>
         </SortExpressions>
         <DataElementOutput>Output</DataElementOutput>
         <KeepTogether>true</KeepTogether>
      </TablixMember>
   </TablixMembers>
</TablixRowHierarchy>
<DataSetName>Whatever</DataSetName>
<PageBreak>
   <BreakLocation>End</BreakLocation>
</PageBreak>

 
 

Note the discrepancy between Between and End! The solution: Use Between in both places. The extra blank page can cause heartache when attempting to export from SSRS into Excel (where the individual pages in the pagination will manifest as independent tabs). This is one of the errors in our logs caused by an extra blank page:

ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: The row item structure object corresponding to a line cannot be null, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;