Hiding columns , reclaiming the space.

13 posts, 0 answers
  1. Paul Buxton
    Paul Buxton avatar
    39 posts
    Member since:
    Jan 2007

    Posted 09 Sep 2008 Link to this post

    I apologise first for not trying this, but I'm currently out of the office, but have a user request to deal with concerning reporting.

    Imagine I have a report with 4 columns -  Col1, Col2, Col3 and Col4

    Optionally, the user can request that they do not want Col2 on the report.  Is there an easy way to hide Col2 (that i can do Visible=false), but ensure that Col3 and Col4  (and their headers) then move left to take up that space?

    Regards
    Paul.
  2. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 09 Sep 2008 Link to this post

    Hi Paul,

    Please take a look at the following forum thread that elaborates on the available solutions for your inquiry.

    All the best,
    Steve
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. DevCraft banner
  4. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 07 Apr Link to this post

    Hi Steve, 

    Seems like above link does not open anymore. We are also troubled with the same issue in our reporting engine.

    We are using Telerik reporting v.8.2.14.1204. While setting column visibility to false the hidden columns widths are claimed by other columns at run time, thus affecting the report layout.
    For more information please find attachment.

    Kindly advise on how to avoid such cases?

    Thanks,

    Nitin

  5. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 07 Apr Link to this post

    Hi Nitin,

    Please check the  hide table column and resize table width Reporting forum discussion, and check if the item in your report is docked in the section or other container.


    I hope this information is helpful.

    Regards,
    Stef
    Telerik
    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
  6. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 14 Apr Link to this post

    We tried as per your suggestions but 
    1.for some reports the column group option is not visible (refer ColumnGroupNotVisible)
    2. For other when column group apply to table it's showing duplicate columns in reports
       (refer ColumnGroupSet)

    Pls advise what could have beeb missing here.

     

    Thanks 

    -Nitin

  7. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 18 Apr Link to this post

    Hi Nitin,

    To show/hide columns you need to apply filters on the existing column groups, which can be seen in the Group Explorer in Extended Mode.

    The attached video (SWF file) can be previewed in IE browser. It illustrates how to add a filter to a column group.

    Regards,
    Stef
    Telerik
    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
  8. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 18 Apr Link to this post

    Hi Stef,
    Thank you again for your advice. As I can see you are using simple table 
    with column grouping and indeed its working well.
    The case at our end is bit different - 

    - We have grouing on row level instead of columns.
    - Table has only 2 static columns visible in group explorer.
     
    See attached snapshot for more understanding.

    With this kind of report setup, your suggestion doesnt seems to work. 
    Appreciate your thoughts on how to deal with it?


    Thanks,
    Nitin
  9. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 18 Apr Link to this post

    Pls find attached images
  10. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013
  11. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 20 Apr Link to this post

    Please find attached image

    there are many column in table but report explorer its show only two of them

     

    Thanks 

    Nitin

  12. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 21 Apr Link to this post

    Hi Nitin,

    The created Table item has only one static column, and some totals. The rest columns are result of the row groupings, which produce a parent cell for the grouped rows.

    To hide these group cells, you can apply the filter on row groups, where hiding a group cell will result in hiding the related sub rows.


    If you want to visually hide the cells you can:
    1. Design the Table item in such manner that groupings are specified directly on the Detail row group - this will not add a group cell and will let you group detail rows to avoid repeating data.
    2. Use the TextBox items' Visible and Style properties. If you need to control the visibility conditionally, test to apply Conditional formatting on the corresponding TextBox items.



    Regards,
    Stef
    Telerik
    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
  13. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 26 Aug Link to this post

    Hellow Stef,

     

    Please find an attached file.

    Diner Note column is displayed as Group Explorer.

    Here, i want to show/hide "Diner Note" column data on expand/collapse of row group.

    Can you please suggest me how to achieve this functionality.

    Regards,

    Rahul

  14. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 26 Aug Link to this post

    Hellow Stef,
     

    Please find an attached file.

    Diner Note column is displayed as Group Explorer.

    Here, i want to show/hide "Diner Note" column data on expand/collapse of row group.

    Can you please suggest me how to achieve this functionality.

    Regards,

    Rahul
Back to Top
DevCraft banner