Hide Telerik Table row

[Manisha Shivjiani]

Hi,

I need help hiding a tablerow object conditionally from code behind.

I researched on the forums and knowledge base and could not find the answer.

I also looked at the article - http://www.telerik.com/help/reporting/faq-accessing-items.html
but it does not show how to get the tablerow object.

Following is my code.

private void detail_ItemDataBinding(object sender, EventArgs e)
{
    // Get the detail section object from sender
    Telerik.Reporting.Processing.DetailSection section = (Telerik.Reporting.Processing.DetailSection)sender;
    // From the section object get the current DataRow
    Telerik.Reporting.Processing.IDataObject dataObject = (Telerik.Reporting.Processing.IDataObject)section.DataObject;
    object rowdata = (object)section.DataObject.RawData;
    if ((dataObject["EEODStatement"] == null) || (dataObject["EEODStatement"].ToString().Length == 0))
    {
        Telerik.Reporting.Processing.Table table1 = (Telerik.Reporting.Processing.Table)section.ChildElements.Find("table1", true)[0];
        // Here I want to access a particular tablerow object and hide it
    }
}

[Ivan]

Hi Manisha Shivjiani,

The simplest way to hide certain rows from a table is to apply a filtering condition to that table. For example, to hide all table rows where the value of a given field is null or an empty string, you can use a filtering expression like the following one:

= Len(IsNull(Fields.MyField, "")) > 0

Please refer to the online documentation about the Filters property of the Table report item for more information. A good general explanation about filtering data can be found in the following help section: Filtering Data. Anyway, there is no need to write custom code in the ItemDataBinding event handler to accomplish this.

If the above explanation does not help you to resolve your problem, could you be so kind to elaborate what are trying to accomplish, so we can provide you more help.

All the best,
Ivan
the Telerik team

[Błażej]

Hi , I have a table in my report and I want to hide rows which haven't got any data (string ==null or string is empty).
So i tried to use this filter but i don't know what is the 'Fields.MyField' ? 

[Steve]

Hi Błażej,

It is the field/column from your database with name MyField.

Kind regards,
Steve
the Telerik team

[Błażej]

Hi,

when I add this filter to my table , in this case:  fields.myfield==null my all table disappear, I want only one row to be not visible.
Any sugestion ? 

[Steve]

Hi Błażej,

This means that your column myfield has no null values and the result of the filter would always be false i.e. it would never show any data.

All the best,
Steve
the Telerik team

[Travis]

Is it possible to hide a footer row that I use for sub totals based on a certain condition?  I want to hide the sub total row when there is only one record in the group.

[Robert]

I have a similar problem, but one that can't be solved by table filtering. (I think.)

My table has two rows inside the same group. The first row will always be display for each data item, but the second row should be visible or invisible based on the value of a field in the data item.

I can easily use conditional formatting to hide the text boxes in question, but I can't seem to get ride of the empty space left over.

I've tried handling ItemDataBound and setting the textbox height to 1px, but the empty space remains the same.

Thoughts?

[Peter]

Hello Robert,

You should be able to conditionally control the row visibility. Our recommendation is to review the table groups with Group Explorer in extended mode and add the required filters to the to the second row group.

Regards,
Peter
Telerik

[Muhammad]

Hello Admin
If you're still active to reply on this post or if there is any other person willing to help me out or seeing this post please help me out with this. I applied this filtering on the field in the table and now I am getting result in 'True' / 'False' format. Like if the column contains NULL value it returns False and if the column contains any value it is returning True but the scenario was to hide the NULL row means it should be shifted up with the column that contains any value.


= Len(IsNull(Fields.MyField, "")) > 0