This is a migrated thread and some comments may be shown as answers.

Hiding columns , reclaiming the space.

12 Answers 366 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Paul Buxton
Top achievements
Rank 1
Paul Buxton asked on 09 Sep 2008, 09:35 AM
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.

12 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 09 Sep 2008, 11:45 AM
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.
0
systems
Top achievements
Rank 1
answered on 07 Apr 2016, 09:58 AM

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

0
Stef
Telerik team
answered on 07 Apr 2016, 05:34 PM
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
0
systems
Top achievements
Rank 1
answered on 14 Apr 2016, 06:46 AM

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

0
Stef
Telerik team
answered on 18 Apr 2016, 09:45 AM
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
0
systems
Top achievements
Rank 1
answered on 18 Apr 2016, 01:37 PM
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
0
systems
Top achievements
Rank 1
answered on 18 Apr 2016, 01:38 PM
Pls find attached images
0
systems
Top achievements
Rank 1
answered on 18 Apr 2016, 01:39 PM
0
systems
Top achievements
Rank 1
answered on 20 Apr 2016, 06:38 AM

Please find attached image

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

 

Thanks 

Nitin

0
Stef
Telerik team
answered on 21 Apr 2016, 07:32 AM
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
0
systems
Top achievements
Rank 1
answered on 26 Aug 2016, 07:26 AM

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

0
systems
Top achievements
Rank 1
answered on 26 Aug 2016, 07:28 AM
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
Tags
General Discussions
Asked by
Paul Buxton
Top achievements
Rank 1
Answers by
Steve
Telerik team
systems
Top achievements
Rank 1
Stef
Telerik team
Share this question
or