Hiding columns , reclaiming the space.

[Paul Buxton]

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.

[Steve]

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.

[systems]

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

[Stef]

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

[systems]

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

[Stef]

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

[systems]

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

[systems]

Pls find attached images

[systems]

PFA

[systems]

Please find attached image

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

 

Thanks 

Nitin

[Stef]

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

[systems]

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

[systems]

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