title: RDLC invoice with tablix, header, detail and totals aligned to page bottom
body: <p>I need to print invoices from my ASP.NET 4.0 application.
  I am using RDLC reports.</p>
  
  <p>The invoice is made by:
  header (customer details, number, date, etc)</p>
  
  <p>details (item description, quantity, price)
  and if possible... I would like to have rows to separate the colums of the details...</p>
  
  <p>footer, which is the most difficoult part, it contains the totals, and some subreports with list of payment expected, VAT details (I can have different VAT rates and I have to print VAT subtotals).</p>
  
  <p>I couldn't find any tutorial or good solution on the internet...</p>
  
  <p>Till now I found two solutions but both of them are not 100% correct:</p>
  
  <p>1) create a tablix and Group the detail data by invoice id.
  Add two rows in the tablix, one for header and one for the footer.
  Add one more tablix for details in the central row.
  With one page invoices it works fine. But when I have longer invoices there is no way to repeat the header in the second page.
  In fact, headers are repeated when there is one full instance of details in another page. But in my case I have just one big row with all the details, which is no a full instance, so repeatonnewpage doesn't work.</p>
  
  <p>2) create tablix, create a Group with header and footer.
  put the invoice header in the Group header, and the invoice footer in the invoice footer.
  and use the detail row for details.
  Seems very straightforward... and in this way it repeats the header on any new page.
  BUT, the footer is just under the last details row.
  I need it to be at the bottom of the page.</p>
  
  <p>I tried to make the query so I have the right number of rows to fill the page, but this doesn't work either, because each detail rows might consist of more than a row actually, in case it's a long description.</p>
  
  <p>Any suggestion?</p>
  
  <p>a link to an image that is similar to what I want: <a href="http://i.stack.imgur.com/4axFt.jpg" rel="nofollow">http://i.stack.imgur.com/4axFt.jpg</a></p>