I have noticed that you have opened a Support Ticket (#1162428) with the same content as this forum post. I have suggested a solution of the problem there.
For the benefit of the rest of the community members I will post the essence of my response and attach the sample also here.
If further questions on this topic arise I suggest to continue our discussion in the support ticket.
Following is my response to the support ticket:
My suggestion is to use a multivalue Report Parameter indicating which CheckBoxes are checked, and based on this parameter values to use Bindings
to set the Visibility
of the columns.
The Column should be Visible
if the corresponding CheckBox is checked, i.e. if its representative value/name is in the report parameter values. I suggest an Expression like:
= 'CheckBoxNameInParameter' In Parameters.ParameterName.Value
The Columns Width
should be equal to the default one when all columns are Visible (for example W, in inches) multiplied by the total number of columns and divided by the number of visible columns, i.e.
=CStr(W*CDbl(TotalNumberOfColumns)/Parameters.ParameterName.Value.Length) + 'in'
Explicit conversion to Double
is required since both the numerator and the denominator are Integer
. The value of Width property is set as a string containing the width and the measuring unit.
I have attached a sample report demonstrating the approach.
In the sample W
=1in (hence is omitted), TotalNumberOfColumns
=6, and the AvailableValues (i.e. the possible CheckBoxNameInParameter
) of the Multivalue Parameter (ParameterName
is 'Hide') are 'id', 'value01' ... 'value05'.
By default all columns are Visible.
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?
Telerik Feedback Portal
and vote to affect the priority of the items