TableObject Sum(Cell6) Not Working in Community Designer about fastreport HOT 7 CLOSED

Hi,

You can check the count of available rows and make the page brake from a code: table.PageBreak();
For example:

      int rowIndex = 0;
      while (rowData.HasMoreRows)
      {
        // print the table body  
        Table1.PrintRow(1);
        Table1.PrintColumns();        
        // check for table footer for last page
        if (rowData.RowCount - rowIndex < 3)
        {
          Table1.PageBreak();
          rowIndex = 0;
        }
        else
          rowIndex++;
        // go next data source row
        rowData.Next();        
      }

from fastreport.

Hi, in your report the data cell is Cell4, not Cell6, so you should use [Sum(Cell4)].

from fastreport.

Thank you. That Worked.
How do I get the Table Header to get printed repeatedly for each new page?

In the designer, Table1 PrintOn property has RepeatedBand checked, in my SCriptCode,
i added:
// printing the table header

  Cell1.PrintOn = PrintOn.RepeatedBand; //added
  Cell2.PrintOn = PrintOn.RepeatedBand; //added
  Table1.PrintRow(0);
  Table1.PrintColumns();

Couldn't get it to work.

Thanks for helping!
HowToGetTableColumnHeadersToPrintRepeatedlyOnEachPage.zip
HowToGetTableColumnHeadersToPrintRepeatedlyOnEachPage.zip

from fastreport.

sorry didnt mean to close this issue yet.
i guess i dont understand what this means:

https://www.fast-report.com/en/forum/index.php?showtopic=11079

Tablecell have printon property. This may work.

TableCell tc
tc.PrintOn = PrintOn.RepeatedBand;

also band must have repeat on every page checked.

in my template, Table1.RepeatHeaders is set to true

from fastreport.

The tc.PrintOn (Gets or sets a value that determines where to print the object.) property is not related to the repetition of the table header.

Use the following code:

table.RepeatHeaders = true;
table.FixedRows = 1; // for repeat only first row on every page

from fastreport.

thanks. that worked. now i may have a different problem.

in the last page, i get only the table header and table footer printed with no data in between because there's no more data.

so it looks like this:

Name Price
Total: 2345678.90

Can I do better than this? Just wondering :-)

Any conditional capabilities I could explore?

Thank you so much for helping a newbie!

from fastreport.

thank you for the tip!

from fastreport.