Hiding Subtotals

Is there a way to hide subtotals based on a parameter value?
--
Is that a cursor in your code!Yes! Just have to write a condition statement in visibility option.
"Ammar" wrote:
> Is there a way to hide subtotals based on a parameter value?
>
> --
> Is that a cursor in your code!|||There is no visibility option associated with the value of the subtotals. The
visibility option pertains to the header cell only. I have tried this and
ended up with subtotal columns with no header. What I am trying to do is to
eliminate the sub total columns all together from appearing (disabling the
subtotal) for a given group if a parameter equals to a predefined value.
"Asim" wrote:
> Yes! Just have to write a condition statement in visibility option.
> "Ammar" wrote:
> > Is there a way to hide subtotals based on a parameter value?
> >
> >
> >
> > --
> > Is that a cursor in your code!|||Ammar:
For any report item, you should be able to set the "visibility -> Hidden"
option.
In the "Hidden" option use the expression value to set it with your
parameter.For example, if you have a parameter say, 'HideSubtotal' and you
want to hide the subtotal column from displaying when 'HideSubtotal' is 1,
then in the expression of subtotal column visibility -> Hidden you will use:
=(Parameters!HideSubtotal.Value = 1)
That should do the trick.
"Ammar" wrote:
> There is no visibility option associated with the value of the subtotals. The
> visibility option pertains to the header cell only. I have tried this and
> ended up with subtotal columns with no header. What I am trying to do is to
> eliminate the sub total columns all together from appearing (disabling the
> subtotal) for a given group if a parameter equals to a predefined value.
> "Asim" wrote:
> > Yes! Just have to write a condition statement in visibility option.
> >
> > "Ammar" wrote:
> >
> > > Is there a way to hide subtotals based on a parameter value?
> > >
> > >
> > >
> > > --
> > > Is that a cursor in your code!|||Once again, there is no visibility option associated with the actual values
in the subtotal columns. In a matrix control when you add a subtotal
reporting designer adds a column with a "Total" label. There is a visibility
option when you select the cell, but if you click the green triangle to
modify the properties of the values of the subtotal column you do not see a
visibility option there. If I added an expression in the visibility option by
selecting the â'Totalâ' cell, then that only control the header of the columns
not the values.
Take some time and try it and you will see
"sam" wrote:
> Ammar:
> For any report item, you should be able to set the "visibility -> Hidden"
> option.
> In the "Hidden" option use the expression value to set it with your
> parameter.For example, if you have a parameter say, 'HideSubtotal' and you
> want to hide the subtotal column from displaying when 'HideSubtotal' is 1,
> then in the expression of subtotal column visibility -> Hidden you will use:
> =(Parameters!HideSubtotal.Value = 1)
> That should do the trick.
> "Ammar" wrote:
> > There is no visibility option associated with the value of the subtotals. The
> > visibility option pertains to the header cell only. I have tried this and
> > ended up with subtotal columns with no header. What I am trying to do is to
> > eliminate the sub total columns all together from appearing (disabling the
> > subtotal) for a given group if a parameter equals to a predefined value.
> >
> > "Asim" wrote:
> >
> > > Yes! Just have to write a condition statement in visibility option.
> > >
> > > "Ammar" wrote:
> > >
> > > > Is there a way to hide subtotals based on a parameter value?
> > > >
> > > >
> > > >
> > > > --
> > > > Is that a cursor in your code!