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

Dynamically hide Rows and Columns

3 Answers 2160 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Frank
Top achievements
Rank 1
Frank asked on 28 Jul 2016, 06:57 PM

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.

Hung
Top achievements
Rank 1
commented on 31 May 2021, 04:10 AM

You can use its Binding to set value for Visible value on Telerik Report Designer. See the example below:
Property Path: Visible
Expression: = Your parameter value

3 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 29 Jul 2016, 07:52 AM
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
0
Frank
Top achievements
Rank 1
answered on 29 Jul 2016, 04:50 PM

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.

0
Frank
Top achievements
Rank 1
answered on 29 Jul 2016, 09:19 PM

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

Tags
General Discussions
Asked by
Frank
Top achievements
Rank 1
Answers by
Stef
Telerik team
Frank
Top achievements
Rank 1
Share this question
or