Remove rows from a table after a manual build

capedica

Hi, i've the following problem:
i'm using ManualBuild event to build a table. I need to use the manual build because i need to revert rows with columns. After i've built the table (using PrintColumn and PrintRows), i'd like to remove some rows (in particular i need to remove rows that have all zeros as value). Is there a way to manipulate table after manual build? I've tried using before print event, removing a row from the table, but it had no effect. I've even tried manipulating the datatable at the beginning of manualbuild event, removing some columns but during the table building an exception is raised. Is there a way?
Thank you

Gabriele

capedica wrote: »

Hi, i've the following problem:
i'm using ManualBuild event to build a table. I need to use the manual build because i need to revert rows with columns. After i've built the table (using PrintColumn and PrintRows), i'd like to remove some rows (in particular i need to remove rows that have all zeros as value). Is there a way to manipulate table after manual build? I've tried using before print event, removing a row from the table, but it had no effect. I've even tried manipulating the datatable at the beginning of manualbuild event, removing some columns but during the table building an exception is raised. Is there a way?
Thank you

Hi, me too I have the same problem, i don't know how hide rows after the manualbuild. If I try to use the

MyTable.RowCount

or

MyTable.ColumnCount

I have like result the numbers of cols or rows of the base table I have add on a report but I don't know how gain the access to the rows / cols of rendered table.

Best regards,

Gabriele

AlexTZ

Hello,

Here is some reports that demonstrate how to manipulate the TableResult data. Run it from Demo.exe.

capedica

Ok, thank you, i will try with a matrix. Maybe the ModifyResult event could be usefull for the table object too?

AlexTZ wrote: »

Hello,

Here is some reports that demonstrate how to manipulate the TableResult data. Run it from Demo.exe.

AlexTZ

The Matrix uses the same rendering procedure. So you can use this with Table object too.

Gabriele

Thank you all for quick support! I try to modify my reports!
Best regards

Gabriele

Gabriele

Thank you all for the support, here the final example with his code, MyBaseTable is the table object in FastReport Designer:

      TableResult table = MyBaseTable.ResultTable;
      for (int r=table.FixedRows; r < table.RowCount -1; r++)
        {
            bool bRowEmpty = false;   
            for (int c=table.FixedColumns; c < table.ColumnCount; c++)
            {
                if (table[c,r].Value != null && table[c,r].Value != DBNull.Value)
                {
                    if ((table[c,r].Value) is string)
                    {
                      if (!String.IsNullOrEmpty((table[c,r].Value).ToString()))
                      {
                        bRowEmpty = true;
                        break;
                      }
                    }
                    else
                    {
                      if (Convert.ToDouble(table[c,r].Value) != 0)
                      {
                        bRowEmpty = true;
                        break;
                      }
                    }
                }
            }
            if (bRowEmpty == false)
            {
              table.Rows[r].Height = 0;
            }
        }