Dynamically hide Rows and Columns

4 posts, 0 answers
  1. Frank
    Frank avatar
    86 posts
    Member since:
    Mar 2012

    Posted 28 Jul Link to this post

    Having read a number of posts here it does not appear that you can hide columns or rows dynamically.  Is there any plans on add this capability?

    I have tried

    performSubReportTable.Body.Rows[2] = new TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.001));

    but neither the Rows or when I change to columns they do not resize.

    I have a report that has a few sub-reports and these sub-reports have tables in them.  Depending on what account is being printed I want to dynamically show and hide specific columns and rows.  As of now it appears my only option is to either create multiple table with each possible combination of rows an columns and then hide and show the appropriate table  or create multiple sub-reports with each possible combination of rows an columns and then dynamically hide and show the proper sub- report.  It would be much nicer if I could create one sub-report with one table and then conditionally hide and show rows and columns, much like how SQL reporting works.

  2. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 29 Jul Link to this post

    Hello Frank,

    Table items have complex structure, thus the recommended approach is to filter row/column groups to show/hide them. For the purpose select the Table item and display the Group Explorer in Extended mode. Each table group has Filters collection where you can specify based on what condition the group is shown/hidden.

    Please check the attached video in IE browser, it illustrates the above suggestion.


    Let us know if you need further help.

    Regards,
    Stef
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Frank
    Frank avatar
    86 posts
    Member since:
    Mar 2012

    Posted 29 Jul Link to this post

    I want to be able to hide a row based on a parameter that I pass to the report. In SqlReport it was easy.

    I understand that in Telerik we can hide rowgroups but not rows. but I am having a hard time understanding how to add a rowgroup in my table for this situation. I can't run a flash file in the office computer.

    I load the report values from a dataset. Here is my table. Can you help me understand what i need to do? Thanks.

  5. Frank
    Frank avatar
    86 posts
    Member since:
    Mar 2012

    Posted 29 Jul in reply to Frank Link to this post

    Never mind. I found the video. http://www.telerik.com/videos/reporting/grouping-sorting-and-filtering-in-telerik-reports

    and i got my filtering working properly. once i understand it, it feels simple. thanks

Back to Top