Hiding/Showing Columns based on Parameters

I have a report that has a matrix in it. It is a multidimensional report with
drill down effects resulting from an MDX query. It has 2 columns (measures).
I have created a parameter in order to hide/show a column. I have written the
following expression for the Visibility property of my Heading and Field
Values of a column:
=iif(Parameters!Show.Value="Measures_COUNT",True, False)
What happens is: My column heading and the values both disappear (appears
blank) but the column remains there. i.e the column width doesnt become zero.
Has someone faced a similar problem' I could not find an expression for the
"width" property of my textboxes so that I could set them to zero.
Also, what I would like to get done:
User selects a list of fields from a page that will act as a filter for my
report data (i.e. where clause of the query ) can i modify my MDX query of
the report to take these values into account?
Also, the user selects a list of fields that he/she wants appearing in the
report. Can i pass these fields to the report and manipulate the columns at
run time. This is what i was trying to achieve by hiding/showing columns?
Thanks,
RishitHi,
The "width" property for a textbox can be founf by expanding the "size"
property. In order to do what you want to do you have to do the following:
Set the visibility of the column - not the individual fields that make up
the column.
Hope this helps.
"Rishit" wrote:
> I have a report that has a matrix in it. It is a multidimensional report with
> drill down effects resulting from an MDX query. It has 2 columns (measures).
> I have created a parameter in order to hide/show a column. I have written the
> following expression for the Visibility property of my Heading and Field
> Values of a column:
> =iif(Parameters!Show.Value="Measures_COUNT",True, False)
> What happens is: My column heading and the values both disappear (appears
> blank) but the column remains there. i.e the column width doesnt become zero.
> Has someone faced a similar problem' I could not find an expression for the
> "width" property of my textboxes so that I could set them to zero.
> Also, what I would like to get done:
> User selects a list of fields from a page that will act as a filter for my
> report data (i.e. where clause of the query ) can i modify my MDX query of
> the report to take these values into account?
> Also, the user selects a list of fields that he/she wants appearing in the
> report. Can i pass these fields to the report and manipulate the columns at
> run time. This is what i was trying to achieve by hiding/showing columns?
> Thanks,
> Rishit|||I'm sorry. I am not that familiar with using matrices and didn't realise they
are handled differently. Please let me know if you find an answer.
"Rishit" wrote:
> Hi,
> I checked the properties for the matrix column. The Visibility propert isnt
> present. Besides, the Width property of the field cannot be set to zero using
> an expression. It doesnt allow width to be set to zero thru an expression.
> Mithun
> "Andrew Byrne" wrote:
> > Hi,
> >
> > The "width" property for a textbox can be founf by expanding the "size"
> > property. In order to do what you want to do you have to do the following:
> >
> > Set the visibility of the column - not the individual fields that make up
> > the column.
> >
> >
> >
> > Hope this helps.
> >
> > "Rishit" wrote:
> >
> > > I have a report that has a matrix in it. It is a multidimensional report with
> > > drill down effects resulting from an MDX query. It has 2 columns (measures).
> > > I have created a parameter in order to hide/show a column. I have written the
> > > following expression for the Visibility property of my Heading and Field
> > > Values of a column:
> > > =iif(Parameters!Show.Value="Measures_COUNT",True, False)
> > > What happens is: My column heading and the values both disappear (appears
> > > blank) but the column remains there. i.e the column width doesnt become zero.
> > > Has someone faced a similar problem' I could not find an expression for the
> > > "width" property of my textboxes so that I could set them to zero.
> > >
> > > Also, what I would like to get done:
> > > User selects a list of fields from a page that will act as a filter for my
> > > report data (i.e. where clause of the query ) can i modify my MDX query of
> > > the report to take these values into account?
> > > Also, the user selects a list of fields that he/she wants appearing in the
> > > report. Can i pass these fields to the report and manipulate the columns at
> > > run time. This is what i was trying to achieve by hiding/showing columns?
> > >
> > > Thanks,
> > > Rishit|||you must go to the properties pane of the Matrix itself. Then go to
groupings. Go to the column grouping properties for visibility. Put your
coditional statement there.
"Andrew Byrne" wrote:
> I'm sorry. I am not that familiar with using matrices and didn't realise they
> are handled differently. Please let me know if you find an answer.
> "Rishit" wrote:
> > Hi,
> > I checked the properties for the matrix column. The Visibility propert isnt
> > present. Besides, the Width property of the field cannot be set to zero using
> > an expression. It doesnt allow width to be set to zero thru an expression.
> >
> > Mithun
> >
> > "Andrew Byrne" wrote:
> >
> > > Hi,
> > >
> > > The "width" property for a textbox can be founf by expanding the "size"
> > > property. In order to do what you want to do you have to do the following:
> > >
> > > Set the visibility of the column - not the individual fields that make up
> > > the column.
> > >
> > >
> > >
> > > Hope this helps.
> > >
> > > "Rishit" wrote:
> > >
> > > > I have a report that has a matrix in it. It is a multidimensional report with
> > > > drill down effects resulting from an MDX query. It has 2 columns (measures).
> > > > I have created a parameter in order to hide/show a column. I have written the
> > > > following expression for the Visibility property of my Heading and Field
> > > > Values of a column:
> > > > =iif(Parameters!Show.Value="Measures_COUNT",True, False)
> > > > What happens is: My column heading and the values both disappear (appears
> > > > blank) but the column remains there. i.e the column width doesnt become zero.
> > > > Has someone faced a similar problem' I could not find an expression for the
> > > > "width" property of my textboxes so that I could set them to zero.
> > > >
> > > > Also, what I would like to get done:
> > > > User selects a list of fields from a page that will act as a filter for my
> > > > report data (i.e. where clause of the query ) can i modify my MDX query of
> > > > the report to take these values into account?
> > > > Also, the user selects a list of fields that he/she wants appearing in the
> > > > report. Can i pass these fields to the report and manipulate the columns at
> > > > run time. This is what i was trying to achieve by hiding/showing columns?
> > > >
> > > > Thanks,
> > > > Rishit